Hello. This is my problem situation.
The two Google Forms receive different data from users.
Using zapier, combine the two data into one Google spreadsheet โAโ.
Each row of โAโ needs a unique ID, so I wrote the script with the help of
Google Sheets UniqueId Apps Script
However, scripts do not work on data coming through the zapier.
And unique IDs are also required for existing data, not new data. However, this script seems impossible because the trigger is โoneditโ.
How can I solve this problem?
To sum up, what Iโm asking is,
โI want to give a unique ID to the data that Zapier automatically puts inโ.
โI want to give unique ID to existing dataโ.
I tried to solve this problem for a long time, but I couldnโt solve it. If you give me advice, I think it will be a great help. Thank you.
Welcome to the community.
I suggest you to ask for help on that post since your usage of both AppScript and Zapier makes your case a kinda niche one
Youโre right. Iโm not familiar with the rules of this community. Thank you.
Use onChange() instead.
Thanks, I solved one problem thanks to you.
User | Count |
---|---|
42 | |
28 | |
25 | |
22 | |
13 |