hi i am trying to add data into my google sheet and have used the script below but i still cant get it to work, please help?
- There should be two curly brackets } at the end of the script, one for the else if and one to close the original if.
- Check/show the content of your global URL - need to ensure you have the ? and the & in the right places....
- Do you want the data posted to the first sheet of the spreadsheet? That is what
ss.getSheets()[0]
does
been getting
[Ljava.lang.Object;@1bb0c141
[Ljava.lang.Object;@7c5c71a9
[Ljava.lang.Object;@242eef4a
[Ljava.lang.Object;@73336c63
instead of text input by user, what should i do
Try:
sh.appendRow([e.parameter.id,e.parameter.task,e.parameter.note,e.parameter.time,e.parameter.date]);
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.