Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Prefill Linked Record in Interface forms

Topic Labels: Interface Designer
Solved
Jump to Solution
3307 7
cancel
Showing results for 
Search instead for 
Did you mean: 
Jason_Jakarta
7 - App Architect
7 - App Architect

Hi

I'm really, really trying to love interface forms and the design is much improved but is it really the case that you cannot prefill linked record in the form? I've tried with Recordid and with the name and it doesn't work. Other fields are fine (that I have tried) but not linked records. 

I believe its also the case that users need access to the base to submit if its being used as an internal form. 

Can anyone confirm these, are there work arounds. I'm having to abandon them for now and build with old forms 😞 

 

Cheers

 

Jason

 

 

 

 

1 Solution

Accepted Solutions

I see that clear does not solve the problem.
I am specifying the link record by record ID.

I use a formula like this to link.

"https://airtable.com/app~/pag~/form" &
"?prefill_" & ENCODE_URL_COMPONENT("Link Record" ) & "=" & RECORD_ID()

 

See Solution in Thread

7 Replies 7
Sho
11 - Venus
11 - Venus

Hi @Jason_Jakarta,

It is functioning properly.
However, the form in the new interface now remembers the value being input
If you have trouble with pre-filling, try clearing it.

2024-01-22 153932.png

ScottWorld
18 - Pluto
18 - Pluto

This seems to be a bug with the interface forms. Be sure to report it to support@airtable.com.

In the meantime, as you mentioned, you can use the old forms to do this.

Alternatively, if you are using prefilled forms to update existing records in Airtable, you can skip over prefilling altogether and use Fillout, which is 100% free and allows you to update existing Airtable records directly from a form.

Fillout also offers the ability to prefill, and they offer dozens of advanced form features that Airtable doesn’t offer, such as creating new linked records from a form.

Thanks Sho but it's just not working for me on multiple forms. I've tried clearing but no joy. Are you using Name or recordID of curiosity?  

Thanks Scott, does seem to be hit and miss from what I'm reading. Love Fillout but clients wants to try and keep it all on the platform. 

I see that clear does not solve the problem.
I am specifying the link record by record ID.

I use a formula like this to link.

"https://airtable.com/app~/pag~/form" &
"?prefill_" & ENCODE_URL_COMPONENT("Link Record" ) & "=" & RECORD_ID()

 

Thanks @Sho  this dint work either initially, I was just about to post back and I decided to clear the form again. It worked!! I'm not sure what was going on but thanks for your help in confirming it works and sharing your formula. 🙏🏻 

CristianCG
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi there!

At miniExtensions, we've created a third-party form that integrates seamlessly with Airtable and supports default values, and offers advanced prefilling capabilities, such as prefilling hidden fields (the fields don't have to be part of the form's structure or its URL) or automatically submitting the form after prefilling, which is ideal when you need to add extra information to your existing workflow (e.g., capture IP address or location data):

CristianCG_0-1736387904096.png

Feel free to explore these features and many more with a free account on our site.