Hello.
Is it possible to create an automation that, when triggered, will update all records linked to a common record?
Example:
3 tables- Customers, Entries, Payments
In Entries there will be several records linked to a customer. When a customer makes a payment for those entries a record, linked to the customer, is created in Payments. I’d like to set up an automation that updates all the records that are linked to that customer as ‘paid’.
Any help would be greatly appreciated!
Katy