Hello,
I have 3 tables which are linked to each other
- Customers
- Invoices https://airtable.com/app0jw4sAdW5VRy68/shrRhehmziVBIfiAG
- Budget vs. Costs https://airtable.com/app0jw4sAdW5VRy68/shrTYer8pWxDAuat6
The Invoices table is my catalyst.
I have created an automation to update the linked record field in the Invoices as follows
- created a new formula field that generates the right text to go into that linked record field.
- an automation that triggers whenever a specific field in the Invoices table is updated & then copy/pastes the info from the formula field into the linked record field
I’ve since had my obvious flaw pointed out in that this method isn’t reliable as the text of the field I want to link to might change and therefore the formula field would become invalid and the automation would breaking down. The suggested solution was to use Record ID instead as it's much more reliable than text.
I don’t know how to do this and would welcome a step by step guide (for an automation novice) on how to set up this automation using Record ID as opposed to me formula field.
Thank you