Since Airtable lacks the ability to limited permissions by table and does not allow linking of records between multiple bases, I need use API or Zapier to keep child bases in sync with our parent base.
The Parent Base contains only two fields - Project Number & Project Name. I can easily use Zapier to detect new record in Parent Base and push those two fields into the child bases. But often the Project Name will be updated in the Parent Base. I need those updates to push to the child bases as well.
One workaround I tried was to create a Last Modified Field linked to Project Name, create a view filtered by “in the last day” and use New Record in View as the trigger. That works for the 1st time a project is renamed in the last 24 hours. But if the project is renamed several times in the span of a few minutes, Zapier only recognizes the first change as “new”.
Any way to do this via API or otherwise?