Skip to main content
Question

Sync data - give editor access to sync data and creator access to the rest of the table

  • July 9, 2025
  • 2 replies
  • 29 views

Forum|alt.badge.img+2

Hello,

 

I have a main base and several project bases that have a two-way sync with this main base. 

In these project bases, I receive data from my main base, but also have columns specific to these project which are freely editable by the teams.

I would like my columns from the main base (the sync one) to be in editor access to the teams (values are editable, but not the column), and the non-sync columns to be in creator access to the teams. How can I do that ?

 

Thanks !

Agnès

 

 

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Hmm, is this because you don’t want them to be able to add new / modify existing select options?  If so, synced select fields can’t have options added to them by default if that helps?


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9808 replies
  • July 10, 2025

@Agnès Arthaud 

That is not the ideal way to setup your system.
I would recommend merging all of your bases into one base, and then using interfaces & interface permissions to control who is allowed to see which data. 

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld