Skip to main content

Hi there, 

I’ve been using Airtable for a while and using Pre-filled form for about 3 years now, but I’m having issue recently with some pre-filled form with linked records. 

I have 4 pre-filled linked record in this form : https://airtable.com/app3VaYZ9KK6HEimn/pag88B7PDY9L5izzt/form?prefill_Session=70&prefill_Formateur=Camille+Rabineau&prefill_Entreprise=Founders+Pledge

And only 3 show up and the last one doesn’t. It does appears in the URL though, it’s just nor displaying it. 

Here is the formula I’m using : 

SUBSTITUTE(CONCATENATE("https://airtable.com/app3VaYZ9KK6HEimn/pag88B7PDY9L5izzt/form","?prefill_","Session","=",ENCODE_URL_COMPONENT({ID 2026}),"&prefill_","Formateur","=",ENCODE_URL_COMPONENT(Formateur),"&prefill_","Entreprise","=",ENCODE_URL_COMPONENT({Projet de formation}))," ", "+")

I’m not too sure what’s wrong, 

Thank you so much for your help ! 🙏

Céline

Hey ​@Celine LEmarquand,

I did not get the chance to dig deep into this yet, however it is curious to see that a different user posted this exact same issue yesterday. See this post. 

I’ll try to get back to this soon. However, if you play around with it and the issue persists you might want to reach out to support@airtable.com

Completely different matter, but would love to have you join our Airtable Hackathon! Make sure to sign up!!

Mike, Consultant @ Automatic Nation 
YouTube Channel


@Celine LEmarquand ​@Mike_AutomaticN 

Wow, it looks like this is a current bug in Airtable’s forms.

I can’t get Airtable’s forms to prefill any linked records anymore, although I can still get it to prefill all the other fields.

Please be sure to report this as a bug to support@airtable.com, and hopefully they will fix it ASAP.

In the meantime, this is probably the best time ever to talk about the MUCH MUCH better way of creating forms for Airtable, which is to use Fillout’s advanced forms for Airtable.

Fillout is 100% free, and people have been using it for years to not only workaround Airtable’s bugs like this, but more importantly…

Fillout offers hundreds of features that Airtable’s native forms don’t offer, including 4 different ways to prefill a form — and 3 of those ways don’t even require you to create a complicated prefill URL at all!

Actually, I lied — Fillout also offers a 5th way to prefill a form, because it allows you to update Airtable records directly with a form, You would use this method if you’re trying to update an existing record in Airtable.

Fillout also offers the ability to update Airtable records using a formcreate custom PDF files from a form submissionaccept payments on formspre-fetch dynamic data from an Airtable recordcustomize the style and branding of your formcustomize a theme for your form, display Airtable lookup fields on forms, create new linked records on a formadd 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:

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


Hm, you mention you have 4 prefilled linked records, but in the link / formula you provided there are only 3 prefills, so it makes sense that only 3 are showing up

 

 

Could you provide some screenshots of the form / table setup?  A screenshot of the Form with the 4 linked fields and the URL that’s supposed to prefill all 4 would be helpful too!

As a datapoint, prefilling the 3 linked fields with your formula works fine for me as well:

 


@Celine LEmarquand ​@Mike_AutomaticN .

Oh, never mind what I said above. I figured out why my linked record prefill wasn’t working.

This isn’t a bug (at least on my end).

I didn’t realize that I had conditional filtering setup on my linked record field in the Data layer.

This was preventing my form from prefilling the linked record!

So that’s probably your issue as well.

Airtable actually offers 2 different places to filter linked record fields, so be sure to check BOTH places:

  1. Filtering on the linked record field itself (in the Data layer).
  2. Filtering the linked record field on the form itself (in the right margin under “Selection”).

Make sure that you don’t have any filtering. Or if you do have filtering, make sure that it allows the record that you’re trying to prefill.

- ScottWorld, Expert Airtable Consultant