Cannot get date from google sheet filled by google forms -

-

Purpose: To remove date and time from the sheet (created by filling Google Forms) and sending them to the body of the e-mail Automatically use script to set script editor code: 

  sendEmails function () {var sheet = SpreadsheetApp.getActiveSheet (); Var startRow = 16; // var numRows = 1 first row of data to process; // Number of rows for processes (var j = startrow; j & lt; startRow + numrows; j ++) {var color = sheet.getrange (j, 10) .getBackground (); Get a range of ("# 00ff00" == color) {// cell A2: B3 var row = sheet.getSheetValues ​​(j, 1, 1, 14); // J row with 14 / NSE color names with stdents = row [0] [0] + "" + row [0] [1]; Var time = line [0] [6] + "at"; // + row [0] [7] + "at" + row [0] [8]; Var named = "Dear" + row [0] [9] + ","; Var email receipt = line [0] [13]; Var topic = "date and time" + line [0] [5] + "at" + row [0] [6]; Var msg = nameRecipient + sheet.getRange ("L11"). GetValue () + nameStudent + sheet.getRange ("M11") getValue () + Time + Name Student + Sheet.GetRnZ ("N11"). GetValue (); MailApp.sendEmail (email receipt, subject, message); Sheet.getRange (J, 10) .setBackground ("#FF9900"); }}}

In output (i.e. e-mail):

The date is filed by the person who fills the Google form. I created the form using Google Screenshot of sheet accessing sheet: Cell (when double clicked) opens the calendar shown on the screenshot above. I use the following code (using Google Apps Script) to get a line from the sheet: 

  var line = sheet.getSheetValues ​​(j, 1, 1, 14 ); The J line looks like the date of extracting the line from  
  [["Gaaav", "Budapest", " De@erta.com ", 9823527827," San Francisco International Airport (SFO) ", 41855, 0.5277777777810115," C 0016 "," Al 02 "," Man "," Public Relations "," 3112 ", 94984802569," JClfusz @ Kgsesfacl .com "]]  
 
 Number 41855 is the date in the above statement. This is actually 8/4/2014 but I can not read it, neither can I read the time, which is 0.5277777777810115 in above debug O / P. 
 
 I am attaching a screenshot of the debug screen:

Assuming submitting your time is 14 in your spreadsheet.

Change both the date and time values ​​in the Javascript date objects, then update the form with the date object form with the hour and minute time objects. 

  function sendEmails () {var sheet = SpreadsheetApp.getActiveSheet (); Var startRow = 16; // var numRows = 1 first row of data to process; // Number of rows for processes (var j = startrow; j & lt; startRow + numrows; j ++) {var color = sheet.getrange (j, 10) .getBackground (); Get a range of ("# 00ff00" == color) {// cell A2: B3 var row = sheet.getSheetValues ​​(j, 1, 1, 14); // J row with 14 / NSE color names with stdents = row [0] [0] + "" + row [0] [1]; Var time = line [0] [6] + "at"; // + row [0] [7] + "at" + row [0] [8]; Var named = "Dear" + row [0] [9] + ","; Var email receipt = line [0] [13]; // Prepare the date time object var dateInput = New date (line [0] [5]); Var Time Input = New Date (line [0] [6]); DateInput.setHours (timeInput.getHours ()) dateInput.setMinutes (timeInput.getMinutes ()); // String var dateString = Utilities.formatDate (dateInput, Session.getScriptTimeZone), "MM / dd / yyyy hh: mm a" Format date / time object;); Var topic = "date and time" + date string var message = name recieve + sheet.gaterenz ("L11"). GetValue (+) + Extend + Sheet.GetRenz ("M11"). GetValue () + Time + NameHydient + Sheet.GetRenz ("N11") getValue () .; MailApp.sendEmail (email receipt, subject, message); Sheet.getRange (J, 10) .setBackground ("#FF9900"); }

}}


Comments

Post a Comment

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

-
I have written a simple httprequest / response code and I am getting this error below: I used to type in my classpath httpclient, httpcore, common -Codecs and general logging. I am very new to Java and I do not know what's going on here. Please help me. code: import org.apache.http.client.HttpClient; Import org.apache.http.client.methods.HttpGet; Import org.apache.http.HttpResponse; Import org.apache.http.impl.client.HttpClientBuilder; Import org.apache.http.Header; Import org.apache.http.HttpHeaders; Public class UnshorteningUrl {public static zero main (string [] args throws exception {HttpGet request = zero; HTTP Client Client = HTTP ClientBuilder.credit (). Build (); Try {Request = New HTTP Gate ("trib.me/1lBFzSi"); HttpResponse httpResponse = client.execute (request); Header [] header = httpResponse.getHeaders (HttpHeaders.LOCATION); // Preconditions.checkState (headers.length == 1); String new url = header [0] .getValue (); System.out.println ("new url...
Read more

java - Gradle dependencies: compile project by relative path -

-
Is it possible to specify a dependency on another gradeal project in the granular (in android studios) outside the current project limits? For example, with a relative path like this: dependence {collection project ('../../ stdlib / dagger'}} MyApp (path / user / foo / workspace / mypad) The app (Path / User / Foo / Workspace / MyPass / App) And I have an Android Library Project with 3 subdomules: stdlib (path is / user / foo / Utilities (Path / User / Foo / Workspace / Stadlib / Utilis) http (Path / User / Foo / Workspace / Stadlib / HT) / Li> What I have to do is compile the Dagger, Util, http module in the MyApp project. The Stidelib Library module under heavy development And MyApp will grow in the form of Growth, so I do not want to push them into a Mewen repository. I am a little change. is likely to add another Gredle projects in some way? I will push the study library into the Maven repository after the source is in search of a temp...
Read more

ruby on rails - Object doesn't support #inspect when used with .include -

-
So I have participated in a glitch error that I do not even know how to debug. I am very new to the railing, so it has kicked my ass well when I use the .includes (school) seen by the student, it gives a blue box error, But when I look at any other model and .includes (school) , the school works just fine. class student & lt; ActiveRecord :: Base has has_many: relationships, foreign_key: "liker_id", dependent :: has_many: matches, foreign_key: "student_1_id", dependent :: deleted belong_to: school belong_to: conference belong_to: would_you_rather belong_to: home city belong_to: year is_to: Major and class school & lt; on the console activatecord :: Affiliate for the base: conference includes: respondent, class: "school", foreign_key: "rival_id" (e.g. For: School) Select SQL generated Select "School". * "School" from "school" "ID" IN (1) error message back NoMethodError: u...
Read more