Appsheet automations in a shred drive

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.

I have tried in proptotype and deployed mode.

I have add the Appsheet Event extension as well.

We have a Core license.

Any help would be appreciated

Hi.

I bit too litle info to spot the problem.

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.

I appreciate all your help

Please provide screenshots of the configuration of all bots involved, including the events, processes, and tasks.

You can maybe set a value on the record once its sent (by adding an action to the bot).

Then you can filter out and only send thos that doesen’t have this value. (E.g. datetime value in a column [Sent])

Note that a sync does not trigger a bot or an action. You need to set a value or a scedual somehow…

Thanks to the suggestios I received. After working through the suggestions here and some other research, I have been able to come up with the solution for us. It was decided that the bot email did not have to run right away so I diod use a scheduled bot.

Steps:

In the spreadsheet, I added a column [Email Sent} . Any submissions that had previously received an email when we were using Form Publisher, I added a TRUE to the column.

I created the new app using the spreadsheet from the Google form. I did not add the Google form.

The [Email Sent] Column was set to Y/N . No initial value was set as this was not a field that was in the Form.

I created an action “Mark as Sent” and the do this was set to "Data set the values of some columns.

Set these columns was Email Sent =TRUE and then I hid the position.

I then created the Bot using Event Source Scheduled and set for 1 hour and toggled on "For Each Row in Table and the Filter condition "ISBLANK([Email Sent]) so that it would only sedn the new submits from the form.

I then set up the Process to send the email and with an attachment as usual and then set the next process as Run a data action using the action Mark as Set that I previously set up.

I moved it into my Shared drive for Training and put the Google form in a separate folder and made that available to anyone with a link and the forms, certificates and logo for the app in the app folder.
I changed the the default app folder to /[SharedDrive]Training/appsheet/data/ name of app

This seems to be working. Thanks again for all the suggestions.