Action/Bot to insert value based on another table

[jlazoCP]

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?

[Marc_Dillon · Accepted solution]

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

[jlazoCP]

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")

[Marc_Dillon]

Use THISROW, check the help article again.

[jlazoCP]

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