AppSheet Bot Email Not Showing Order Detail Data on New Order Save

AppSheet AppSheet Q&A
1

Hello everyone,

I have an AppSheet application with two related tables: Orders and Order Details.

I have created a bot automation to send an email whenever a new order is saved.

When I test the bot directly from the Automation tab in the AppSheet editor, it works correctly and includes the related order detail data in the email.

However, when I actually save a new order through the application, the triggered email is sent, but it does not display the data from the related Order Details table.

Has anyone encountered a similar issue or knows what might be causing this discrepancy between the test environment and the live application trigger?

Any help or guidance would be greatly appreciated!

2

I think, when you create master and details table at the same time, details values are not ready for automations and lt looks empty. You can see difference between test and monitor screen.

Mesut_1-1745305745982.png
Mesut_1-1745305745982.png1045Ă—673 45.6 KB

3

The issue you are encountering is a common one.

Please take a look at the section “Send an email only after adding a parent record and all of its children” in the help article below for a solution.

Example automations - AppSheet Help

1 Like