AppSheet sending out duplicate email from automation bot after the original submission

Basically, I have an app setup with a form view. There is an automation bot set to send an email to multiple recipients when a new row is added (Data Change type is only set to "Adds"), the bot works fine. The issue I'm having is hours/days later, the email is getting sent again and a 2nd duplicate entry is added to the source sheet without the user submitting another form just by the simple fact of them opening the app. It would be impossible for them to submit a complete duplicate entry as in the form view I have a field with a "Day/Date + 8 Digit Alphanumerical" code which randomly generates each time they click to open a new form. I have been on with AppSheet support and had a case open for about a week and they do not know what's causing it so I thought I might post it here to see if anyone else has had anything similar and could offer some advice, please?

Solved Solved
0 3 402
1 ACCEPTED SOLUTION

AppSheet support have come back to say that it was a server acknowledgment issue between their server and the users device. It seems like an AppSheet issue but I have found a work around. The solution is to put this condition "NOW()<[Date & Time Reported]+โ€œ000:45:00โ€" in the condition formula bot on your automation. Obviously, you will have to change the field [Date & Time Reported] to whatever field you have set to record the time of the for submission. The condition basically says that if the time now (in real world) is more than 45 minutes after the form submission started it will not trigger the bot. Posting the solution as couldn't find it anywhere myself

View solution in original post

3 REPLIES 3

How are you triggering the bot in the first place?

By someone adding a new row to that table which is done by submitting a new
form

--



AppSheet support have come back to say that it was a server acknowledgment issue between their server and the users device. It seems like an AppSheet issue but I have found a work around. The solution is to put this condition "NOW()<[Date & Time Reported]+โ€œ000:45:00โ€" in the condition formula bot on your automation. Obviously, you will have to change the field [Date & Time Reported] to whatever field you have set to record the time of the for submission. The condition basically says that if the time now (in real world) is more than 45 minutes after the form submission started it will not trigger the bot. Posting the solution as couldn't find it anywhere myself

Top Labels in this Space