I have 2 Tables.
The first table is read only, because it get’s filled with Google App Script.
When a new row is added to Table1, the values should be copied to Table2.
I can’t use Webhook, because Table1 is not edited by AppSheet.
So I thought I could use Report that runs once a day.
I would like to use an Action “Add a new row to another table” that is fired with webhook in that Report.
In the HTTP Body I would like to use
<<End>> to copy all the rows that are new.
I forgot to mention: For this copy I can’t use Google App Script, because I have calculations in AppSheet.
Does anyone has experience with that?