So I have a table called “US states”, which other tables have linked fields to. One issue I encounter often is that when I have a form in a different table and add a field called “Select state”, which is linked to the “US States” table, I often have people who fill out the form start typing in the state and accidentally insert a new State (sometimes misspelled or sometimes just the abbreviation) thereby creating a new record in the linked “US States” table. Is there a way that a linked field in a form restrict creation of new records and only allow users to select from the list of linked records?
Solved
Prevent linked reference field in Form from accepting new values that aren't in the reference table
+15Best answer by ScottWorld
Airtable's forms will not allow creation of new records through a linked record field. Users are required to choose a pre-existing value only.
Note that some people actually want the exact opposite behavior of this (i.e. the ability to create new linked records from a form.)
If you want that behavior, you can use Fillout's advanced forms for Airtable, where you will have the option of either enabling or disabling the ability to create new linked records from a form.
Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, pre-fetch dynamic data from an Airtable record, display Airtable lookup fields on forms, create new linked records on a form, add a login page to your form, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.
I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:
- Using Fillout to create an eSignature approval process with PDF file creation.
- Using Fillout to create an order entry form with line items.
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
+35Airtable's forms will not allow creation of new records through a linked record field. Users are required to choose a pre-existing value only.
Note that some people actually want the exact opposite behavior of this (i.e. the ability to create new linked records from a form.)
If you want that behavior, you can use Fillout's advanced forms for Airtable, where you will have the option of either enabling or disabling the ability to create new linked records from a form.
Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, pre-fetch dynamic data from an Airtable record, display Airtable lookup fields on forms, create new linked records on a form, add a login page to your form, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.
I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:
- Using Fillout to create an eSignature approval process with PDF file creation.
- Using Fillout to create an order entry form with line items.
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
+15Airtable's forms will not allow creation of new records through a linked record field. Users are required to choose a pre-existing value only.
Note that some people actually want the exact opposite behavior of this (i.e. the ability to create new linked records from a form.)
If you want that behavior, you can use Fillout's advanced forms for Airtable, where you will have the option of either enabling or disabling the ability to create new linked records from a form.
Fillout offers about 100 advanced features for Airtable that Airtable's native forms don't offer, such as dynamic linked record filters (i.e. dynamic dropdown selections), the ability to update Airtable records from a form, the ability to accept payments on forms, the ability to have multi-page forms with conditional paths, the ability to create new linked records on a form, the ability to display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, visually displaying as many fields as you want to see in a linked record selection list (including attachment fields), limiting the number of linked records that can be chosen, and much more.
I give a brief demonstration of Fillout on this episode of the BuiltOnAir Podcast: https://www.youtube.com/watch?v=xrqXdRNmQIY&list=PLqssva4liHRwHhQIpTXekG8WObEoyC2F1
p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld
D-uh, I should have checked. Thanks, Scott. This implies that someone on the team is entering records directly in the table rather than using a form and hence is creating new linked records that way. Thanks a bunch once again.
+35You’re welcome! You could also change permissions in the table so that nobody can create new records there.
+15You’re welcome! You could also change permissions in the table so that nobody can create new records there.
Thanks, Scott. Now that I did not think of. To be honest, I’ve never really explored the “Edit field permissions” options, assuming that’s what you were referring to. I tried looking into this and it seems like it gets me halfway there.
I set all the fields in my “US States” table to allow nobody to edit them. I thought that this will prevent someone entering a new state record through a related table e.g. so no one can enter NYC when selecting the state in a different table when the “US States” table already has a record called NY.
What actually happens though is that when in a different related table, I select the state, and instead of selecting NY from the list of available linked records, decide to type in NYC – a record is still created in the “US States” table. Albeit has its primary field blank (unnamed), it still creates a lookup back to related table from where NYC was entered. It’d be great if a the “US States” table prevented new records from being created altogether, so that no other table that a field linked to US States, could create a new record in the US States table.
+35I was actually referring to editing table permissions, where you can prevent people from creating new records.
I just tested this, and it works across all scenarios, including preventing the creation of records through linked fields.
+15I was actually referring to editing table permissions, where you can prevent people from creating new records.
I just tested this, and it works across all scenarios, including preventing the creation of records through linked fields.
Thanks, Scott. That’s another area I hadn’t explored until now. In fact I had to do a quick Google search to see how to set Table permissions and realized that it’s right next to where I constantly enter the table description – but somehow have never noticed this option. This will seem to do the trick and so I’ll enforce permissions to that no new linked records can be created in my States table.
Thanks so much, once again. Really appreciate it.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.