Re: Possible to "Create New Record" from within an interface's form lookup field?

746 1
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Is it possible to create a new record from within an interface's form lookup field?

I'm running into an issue where I need to be able to use a lookup field in my form, but often need to create a new lookup field record on the spot.  See below image with what I need, but must not be an option.  

4 Replies 4
18 - Pluto
18 - Pluto

No, but you have 2 other ways of doing this:

1. You can place text on that form which gives them a link to click on, which will open up a new form in a new tab.

2. You can use Fillout, which is the world’s most advanced form tool for Airtable. It gives you the feature you’re looking for, along with hundreds of other advanced Airtable-specific features that Airtable’s native forms don’t offer. I just gave a demo of Fillout on this episode of the BuiltOnAir podcast.

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 





Thank you, Scott! Appreciate the feedback.  

FYI: Also, note that that field is called a “linked record” field, not a lookup field.

You can learn more about linked record fields & lookup fields in my free Airtable training course, which you can take for free by signing up for a trial membership with LinkedIn Learning: 

Also, as I mentioned in your other post on this exact same topic, there is also a clunky workaround for this — but I do not typically recommend this method because of all the clutter it adds.

You can add a fake linked record called “CREATE NEW RECORD” or something like that. When the user chooses that item, you can conditionally show a whole bunch of other temporary fields on your form for the user to fill out. Of course, when the form is submitted, all the data will go into the same table, so you would then use an automation to copy & paste all of the values from the temporary fields in the first table to the real fields in the other table.