Help

Re: Preventing modification of single select field

988 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Alba_Machado2
7 - App Architect
7 - App Architect

Hi all,

I can't keep my work partner from accidentally adding options to our single select fields. He forgets they are single select fields and just types in his value—often misspelling them. Is there a way to prevent this? One that doesn't depend on me somehow managing to finally get him to remember? I sure hope so. TIA for your thoughts!

4 Replies 4
Jake_Wilson
6 - Interface Innovator
6 - Interface Innovator

What's his permission level?  I believe if you make his permission level "Editor" instead of "Creator" or "Owner", he won't be able to make base schema changes (like adding field options). 

Is downgrading his permission level an option for you guys?

Thanks, but his permission level has always been "Editor." 😕

ScottWorld
18 - Pluto
18 - Pluto

 

Unfortunately, this is not a built-in feature of Airtable.

Your only real option is to change the single-select field into a linked record field, and prevent him from creating new records in the linked record table. 

Alternatively, if  this is only a problem when he creates brand new records, you could create a form for him to fill out, because forms are the only part of Airtable that prevents people from adding new options into single-select fields.

You could also create a formula or an automation to alert him or you that an invalid entry was entered, but the best option is to just change the single select field to a linked record field. 

Depending on your relationship with your work partner, you could try creating an option called “Stop making new options and choose one that’s already here!” and then making that the default option for that field. That way, every new record has that option shown in it first and he has to click out of that in order to click into the one he wants. 

Is this the most professional and appropriate way to handle this? Absolutely not. Could it work? Absolutely.