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.
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
Page 1 / 1
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
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.
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:
Filtering on the linked record field itself (in the Data layer).
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.