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?
- Make it so that all sales people can view all prospects but only the team who owns the prospect can edit
- Make it so that only the team that owns the prospect can view the prospect, and only the specific sales person assigned to the prospect can edit the prospect
Can somebody please advise if either of the above is possible, please?
Thank you, Brendan