Keep fields in sync across multiple bases

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?

You could do this via the API with a script that periodically loops or checks for changes in the parent base and updates the child bases. You’ll need to host the script somewhere though. I have processes that do this sort of thing and I run them on Heroku.