Timeline for Copy last row to another spreadsheet upon form submission
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 5, 2017 at 17:31 | comment | added | Võ Tự Đức | Great to know that @Hink. :) | |
| Feb 5, 2017 at 17:28 | comment | added | Hink | The array is 2-D, which means there are arrays in the array [[data,data][data,data][data,data]] getting sourceData[0][0] is getting the first element of the first array. You will work with 2-D arrays a lot with google sheets. | |
| Feb 5, 2017 at 15:55 | comment | added | Võ Tự Đức | Ah, I'm not quite clear on If statement. There are two [0][0] in the if condition? I don't know what does it mean? Could you please explain to me? if (sourceData[0][0] != sheet.getRange(1, 1).getValue();){ (sourceData[0][0] != sheet.getRange(1, 1).getValue();){ target.appendRow(sourceData[0]); } } | |
| Feb 5, 2017 at 15:52 | vote | accept | Võ Tự Đức | ||
| Feb 5, 2017 at 15:46 | comment | added | Võ Tự Đức | You save not only my day but also help me to improve my understanding on GAS. Thank you in advance. :) | |
| Feb 5, 2017 at 13:02 | review | First posts | |||
| Feb 5, 2017 at 17:20 | |||||
| Feb 5, 2017 at 12:57 | history | answered | Hink | CC BY-SA 3.0 |