So I created a base, with a bunch of tables. The first Table is sort of a summary table of the other tables.
My use case:
Let’s say I change the status of the item in my General Manager Table from Define to Communicate:
I want to update the corresponding field in the Status column to the same value:
These selections are drop down selections.
So I setup an automation that when a record is created in General Manager table, that it will update the corresponding object (sorry, I’m none-technical, and don’t know the proper terminology) in the Status table:
The automation keeps failing, and I’m not sure whey.
Any help would be super appreciated!