I have two tables:
Table A: Populated from a form from an external source. It has 3 columns: Customer Name, Customer ID and Entry Date.
Table B: Contains 10 columns of customer information, including Customer Name, Customer ID and Completed. Options for the completed field are Yes/No.
I want to update the Completed field in Table B to “Yes” whenever a customer completes the form/a new entry is added to Table A.
I’ve gotten close and can do it manually by creating a linked field of Customer ID, but is there any way to do it with an automation? I feel like I’m missing something simple.
Thanks in advance for your help.