Missing Reference Data on Send Email Automation

[Tony_Landowski]

I have created an automation Bot to send an email when a record is added to the main table.  Within the Email Body Template, I have the related field table automatically created.  But when the form is submitted/saved, the email is sent and the table is blank.  But when we change the rule to run on Adds & Updates the update email includes the missing data.  Can someone point me in the direction of why the table is not being populated on add?  

I'm Using an Appsheet database.

[Vincent_P]

Hello, 

I just test a simply bot on add only and the email his correctly send with data. Is your formula wrong ?

[Tony_Landowski]

Here are screenshots showing how I have this setup the automation Bots and the custom email template from a Google Doc that does not work on add but works on update.

[BRUNOCDO2002]

Hello, I have the same problem, I insert the value in the child table to the right of the parent form, apparently the BOT is executed before the child values ​​are inserted in the database, so the table is generated blank, I couldn't find a solution to change the order of insertions in the table.

[Vincent_P]

Could you test with your gmail adress ? maybe this is your mail server that's blocking your email.

[BRUNOCDO2002]

I carried out a test with addition and update and it worked when updating the value, but when the ADD doesn't work, I use the ISPARTOF option in my REF column so I don't add the values ​​from the table_parent, I insert the value in the table_child referencing the table_parent