Hello! I have a base - we will call it base 1. It contains visible and non-visible records.
I have a view within the base specifically for “visible” records. When a record changes from non-visible to visible, only records in that view are seen.
I have synced the “visible” view to Base 2 and set up an automation that when a new record enters the view, it creates a new record in table 1 within Base 2. All is working as expected.
When a record is updated in Base 1, it updates, as expected via sync to Base 2 visible view. Working as expected.
What is not working.
I am attempting to set up an automation that when a record in Base 2 Synced visible view is updated, it updates the fields in the “new” record within table 1.
I keep getting an error that the record does not exist.
Any tips? Thank you!