I am still struggling with Apps in my shared drive. I was able to finally create apps directly in a Shared drive with the help of this group. Now my struggle is automations.
I have a simple app built from a Google form. They fill in the form and it is supposed to create a certificate. The reason why we are using forms is that from time to time someone outside our domain needs to fill it out. I have both the sheet and the form added to the app. I have tried the automation using both the sheet and the form as the event source to trigger the automation which is to simply email a certificate from a template.
The sync does not work unless I do it manually even though I have set the delay sync to off and automatic updates and sync on start is on. Once it syncs, the bot is still not triggered. The bot does work when I test and execute the trigger.
But you need the app to trigger the BOT. I asume that is the problem. Maybe it should trigger on a scedualed basis (e.g. every hour). Have you tried that?
I haven’t tried that but I will. I think that the issue may be more on the sync side. I have to manually sync appsheet to see the row show up. This still doesn’t trigger the bot once it syncs so it may be a combination. I will tryu your suggestion and let you know if it works.
It worked with schedule send but send it to all that are on the sheet. I am trying to work out how to just send to the recent ones since the last scheduled send.
[_THISROW] = MAXROW(“Your_Table_Name”, “Timestamp”) I found this suggestion but I think this only sends to the last one, if I am not mistaken, so if three are submitted since the last scheduled send not all three will be sent.
Scheduled send will work for this one but have have others that need to be sent immediately after submittion as there are time constraints.