Action/Bot to insert value based on another table

AppSheet AppSheet Q&A
1

I have two tables:

Contacts
Name | Email

Payments
Name | Email |Payment Date

I want to create a Bot or Action to run at a set interval to look at the Payments table for a blank email field, compare Client Name to the Contacts table, and fill the email value from that table into the Payments row.

Can anyone help point me in the right direction for the process for this?

2

Use a ForEveryRow scheduled event, with condition ISBLANK([email]). Set the [email] value with a LOOKUP() expression.

https://help.appsheet.com/en/articles/2357309-lookup

https://help.appsheet.com/en/articles/4865307-appsheet-automation-the-essentials

3

Thank you for the guidance! I am up and running.

4

Quick question, for some reason, it is returning the email address of the first record, it doesn’t seem to be comparing the “Client Name” Column.

LOOKUP([Client Name], “Contacts”, “Client Name”, “Email”)

5

Use THISROW, check the help article again.