We are using Airtable as a research database and want to make some of our work public through Our main base for entry has a series of 5 tables that are all interconnected (we take advantage of the ability to have relational tables within bases). For example, in table 1, our records link to records in tables 2, 3, and 4. Some of the information in our main base has sensitive information (like researcher identifying information) which we do not want to make public.
Is there a way to create a synced version of the base that maintains the relations between the tables (e.g. “link to record from other table fields”) while allowing us to limit the fields that are shown on the public version? We want to make research public as we continue to update the main base, so just duplicating the base and removing fields isn’t an option (need some sort of sync with the main base that is being updated).
I tried to create a synced base with all the tables from the main base, however, those “link to another record” fields were broken and changed to text fields.