Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 22, 2022 03:56 AM
Hey guys !
i have an interface for my customer with a form and other data.
He wants the form to be prefilled with the same message “long text field” in the interface.
See the screenshot.
it it possible to do that? and how?
Thank you
Sep 07, 2023 07:39 AM
Just agreeing with this feature and use case!!
Sep 07, 2023 07:40 AM
Were you able to achieve pre-filling a dynamic linked field in an interface? I don't see anything unique in the form URL when I select a linked record.
Sep 07, 2023 08:25 AM
It seems to be working for me - here's what I did:
Created a form layout Interface with all the default settings from Airtable connected to my Projects table. Publish it. View it. Copy the link from the address bar.
In my table, I created a new button field set to Open URL. In the URL portion I put the following:
"[Link from Interface]?prefill_"&"Project+Name="&{Project Name}
Note the quotation marks - they are all necessary!
Save the field. Click on any Project and the form will load with the selected Project prefilled in the form. This same concept can be repeated to prefill multiple fields like this:
"[Link from Interface]?prefill_"&"Project+Name="&{Project Name}&"&prefill_Start+Date="&Today
You can also fill it with static data instead of dynamic like this:
"[Link from Interface]?prefill_"&"Project+Name=Sample Project"
Hope this helps!
Dec 01, 2023 02:37 PM
I'm having an issue with Interface Forms where I can't prefill a linked record field (even when using the Record ID of the linked record in the query string parameter). I am able to successfully prefill all other field types on the same form, just not a linked record field. Does anyone have suggestions?
Jan 06, 2024 07:16 AM
I am having the same issue — I've tried @Ashley_Jackson's method of using the field name and I've tried using the record ID, but it's not working for me to prefill a linked record field of a Interface Form. 😞
//Airtable formula:
'https://airtable.com/appquN7zlOyyK8sMF/pagtD6NLFZVUDVlkQ/form?prefill_Shipment=' & RECORD_ID(Shipment)
//Resulting URL:
https://airtable.com/appquN7zlOyyK8sMF/pagtD6NLFZVUDVlkQ/form?prefill_Shipment=recsgslGPYbDrtueH
Jan 06, 2024 07:43 AM
Never mind, I figured it out! I was using the wrong record id because I thought RECORD_ID({Shipment}) would give me the record ID of the linked shipment but it just gave me the record ID of the current record, as if I had just been using RECORD_ID() without any parameters.
So @Jonathan_Straus I recommend double-checking your record ID to make sure it's valid for the field you're trying to prefill!
Jan 07, 2024 08:37 AM
I have tried long and hard to make Ashley's solution work - but I am foxed.
In my normal base, the following button field URL works well, and is key to our business
Jan 11, 2024 02:03 PM
Same here, I've tried the solution and it works on standard forms, but will not work on a form I've created in an interface for link fields only.
Feb 09, 2024 01:40 AM - edited Feb 09, 2024 01:41 AM
It used to work, now it doesn't anymore. It's getting quite frustrating. One day it works, the other it doesn't...
If I test with the old forms, I can pre-fill a linked field normally, and if I do exactly the same for a new interface form, it doesn't work
Feb 22, 2024 05:00 AM
I also confirm that it's not working anymore (dynamically fill a linked record with record ID on an interface form). It only works on legacy forms...