0

I'm using Google Form to collect data of my clients. An e-mail will be automatically sent out to the user with pre-filled information for them to review. However, whenever a user edit the form, the pre-filled information will extract the information from the last row.

I know why it happened because I used the e.values so it will always take the latest data/last row.

var firstName = e.values [1];

Is there another way to select the latest row just by looping, comparing all timestamps (first column ---> var time = e.values [0]; ) and select the latest row.

I have tried below code to get the active row but it did not work.

var lastActiveRow = firstsheet.getActiveRange().getRow()-1

I still haven't figure out how to get the latest timestamp/row.

Danial Asraf Norbee
  • 261
  • 7
  • 21
  • What do you mean by "when a user edits the form"? No response data is used and no submissions are sent when the form is edited. Or are you talking about when a **respondent** edits their *previously submitted response*? Note the difference between those two actions. – tehhowch May 24 '18 at 11:49

1 Answers1

0

getActiveRange returns the range that is active, meaning that it's highlighted.

The latest timestamp position usually is the last row with data but this isn't deterministic because the data could be sorted/rearranged. If you want the last submitted response, look for the largest (newer) timestamp.

First we should get the column with the timestamps, then We could use JavaScript to find the most recent timestamp

What is the elegant way to get the latest date from array of objects in client side?

Rubén
  • 34,714
  • 9
  • 70
  • 166