I have a base that represents validation tests. Let’s say I have a total of 30 records. 10 records need to be updated by Vendor 1, the next 10 by Vendor 2, and all 30 need to be updated by Employees.
Airtable does not support record level permissions at this time.
Am looking for solutions to accomplish this.
A potential solution: create a Master base with the 30 validation tests. Programmatically create a base per vendor and copy records from Master to Vendor base. When vendor updates the records in the Vendor base, copy the updated records to the Master base. Is this doable?
Is there something easier?