![]() ![]() We have plenty of automations setup so it's more in terms of how to best approach identifying these changes between the data in "All Locations" and the Zapier table. Create automations that identify when changes occur in the Zapier data that our team should be made aware of so it will create a deliverable or some sort of notification. ![]() If an existing location record in "All Locations" has its Location ID modified, is there a way to automate a check that will reference back to the Zapier table and trigger something if it doesn't find a match?.Can this be done directly from the Zapier table using a linked record with the location's key field (Location ID)? Create a link between the Zapier table to the "All Locations" table to automatically update several fields with the values in the Zapier table.With all of the groundwork now laid out here is what we would like to accomplish: We currently have successfully deployed Zapier and have a constantly updating synchronized table with all the location data in Airtable, but we can't work off of that table as it needs to remain untouched for the sync to work as well as the fact all of the history is attached to the records in the Airtable "All Locations" table. We want to use the core organizational source of truth to update the marketing team's locations table in Airtable. The true "source of truth" is a locations table in our Datamart that comes from our organization's CRM system. Up until now keeping it up-to-date has been a challenge as employees don't necessarily stay on top of updating the data when changes to our locations occurs. We have a primary table called "All Locations" which is our "source of truth" for location-specific data about the retail showrooms we manage. Our marketing team manages all of their accounts through Airtable. I was hoping for some advice on how to best approach this use-case we have. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |