Hi. I’m really enjoying the sync feature that was recently released.
I currently have tables from multiple brands’ bases synced to my team’s base. Each sync table has the same 9 fields for uniformity. My ultimate goal is to consolidate the records from each of these sync tables into one table, so that I can assign date-specific tasks to my team. The easy part was getting this data into my table. I used the automation “When a record enters a view -> Create Record.”
The hurdle I’m facing is that the synced tables I’m pulling from are getting updated with new publish dates, newly created notes, etc.
Is there a way for the records in my table to automatically update when records in a synced table get updated? One thing I tried was another automation: “When a record is updated -> update record,” but I couldn’t figure out what to enter into the mandatory Record ID field.
If you haven’t guessed, I’m a newbie to scripting and coding and such, but I am open to any and every suggestion. I will soon have as many as 15 synced tables to pull from, so I could definitely use the help.