Skip to main content
Solved

Prefill Linked Record in Interface forms

  • January 22, 2024
  • 7 replies
  • 312 views
Jason_Jakarta
Forum|alt.badge.img+10

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

 

 

 

 

Best answer by Sho

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?  


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()

 

P

7 replies

S
Forum|alt.badge.img+21
  • Sho
  • Inspiring
  • January 22, 2024

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.

 

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • January 22, 2024

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's advanced forms for Airtable, 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.

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

Jason_Jakarta
Jason_Jakarta
Forum|alt.badge.img+10
  • Jason_Jakarta
  • Author
  • Known Participant
  • January 23, 2024

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.

 


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?  

Jason_Jakarta
Forum|alt.badge.img+10
  • Jason_Jakarta
  • Author
  • Known Participant
  • January 23, 2024

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 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. 

ScottWorld
S
Forum|alt.badge.img+21
  • Sho
  • Inspiring
  • Answer
  • January 23, 2024

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?  


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()

 

Jason_Jakarta
Jason_Jakarta
Forum|alt.badge.img+10
  • Jason_Jakarta
  • Author
  • Known Participant
  • January 24, 2024

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
Forum|alt.badge.img+15
  • CristianCG
  • Participating Frequently
  • January 9, 2025

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):

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

Terms & ConditionsAccessibility statement