Jan 21, 2024 08:39 PM
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
Solved! Go to Solution.
Jan 22, 2024 09:45 PM
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()
Jan 21, 2024 10:41 PM - edited Jan 21, 2024 10:42 PM
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.
Jan 22, 2024 03:16 AM - edited Jan 22, 2024 03:17 AM
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.
Jan 22, 2024 09:21 PM
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?
Jan 22, 2024 09:23 PM
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.
Jan 22, 2024 09:45 PM
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()
Jan 23, 2024 09:48 PM
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. 🙏🏻