Until Airtable add this feature, have you considered connecting JotForm directly to Airtable?
JotForm has a built in Airtable integration so you don’t need to use Zapier.
This could already simplify some things for you?
I have built a very similar HR CRM system for a client that involved linking private and public tables that automatically updated each other.
From your brief specification it sounds like you’d be looking for something similar and is some...