I need an automation that, when there is a new record received in one table, to check a box with the matching ID in another table.
I have a (unique ID) four-digit “Repair Order” in table1 that, when the balance = $0, sends out a “Cust Survey”. The ‘Survey’ is identified by the same (unique ID) four-digit “Repair Order” number. WORKING PERFECTLY!
I then have the “Survey Results” table, or table2.
When a new set of ‘Survey Results’ are received in table2, we need to locate and match the “(unique ID) four-digit “Repair Order” number in table1 and check the “Survey Received” checkbox in that table.
All the sudden I can’t think of a flow for the automation!?!
I do know that I can’t LINK the tables because there is nothing in table2 to link to… right?
PLEASE HELP ME!!!