I have seen that many people are requesting advanced permissions but haven’t seen my use-case if somebody could please confirm whether this is possible.
I would like to know if you can allow user view/edit rights based on cell value. I’m very new to Airtable so perhaps there’s a good way of doing this without me thinking like I’m working in Excel!
I’ll use the most simple example I can think of below.
Company XYZ has sales team made up of East and West, users are assigned to each team in a table.
Person A - East
Person B - West
Then there are prospects in a new table assigned to a Team and person. When adding a new prospect, the prospect should default to the team that the sales person is attached to.
Prospect A - East - Person A
Prospect B - West - Person B
What combination of the following can I do please?
Can somebody please advise if either of the above is possible, please?
Thank you, Brendan
Solved! Go to Solution.