Skip to main content

Prefill a form in interfaces


Forum|alt.badge.img+3

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

19 replies

Forum|alt.badge.img+17

Hi @Slim_BENAZIZA ,

Welcome to Airtable Community!

You cannot prefill forms in the interface , you can only do that in the form link. Please see this help article.


Karlstens
Forum|alt.badge.img+20
  • Inspiring
  • 601 replies
  • March 5, 2023

Pre-filled field data within an Interface Form is now possible, thanks to the recent March 2023 updates to Interfaces.

EDIT: FFFSS I can't stand these buggy forum bugs >_<. Now I have the wrong screenshot uploaded capturing the forum bug of my real post that was trying to help. *sigh*


Forum|alt.badge.img+15
Karlstens wrote:

Pre-filled field data within an Interface Form is now possible, thanks to the recent March 2023 updates to Interfaces.

EDIT: FFFSS I can't stand these buggy forum bugs >_<. Now I have the wrong screenshot uploaded capturing the forum bug of my real post that was trying to help. *sigh*


Hi there, Is it possible to have a dynamic value prefilled into a form?  For instance, I have a library base for a small organization lending library.  You can view / search the catalog and if you find a book you'd like to check out, I want to offer a button that takes the viewer to a check-out form with the book pre-filled.  Possible?  Thanks!


Forum|alt.badge.img+3

Any updates about prefilling a form in interface dynamically?
Let say I want to comment the record (not with the record block), could the "current record" already be filled in the form?


Forum|alt.badge.img+3
  • Participating Frequently
  • 5 replies
  • June 22, 2023
Karlstens wrote:

Pre-filled field data within an Interface Form is now possible, thanks to the recent March 2023 updates to Interfaces.

EDIT: FFFSS I can't stand these buggy forum bugs >_<. Now I have the wrong screenshot uploaded capturing the forum bug of my real post that was trying to help. *sigh*


Is this documented anywhere? 


Forum|alt.badge.img+3
  • Participating Frequently
  • 5 replies
  • July 11, 2023
Bobby_Ackerman wrote:

Is this documented anywhere? 


Following up on my own inquiry here. It's possible to set a default value in interface forms, but it is not possible, at least not from what I've encountered so far, to prefill interface forms via url parameters in the same way that you can standard forms. 


Forum|alt.badge.img+7
Bobby_Ackerman wrote:

Following up on my own inquiry here. It's possible to set a default value in interface forms, but it is not possible, at least not from what I've encountered so far, to prefill interface forms via url parameters in the same way that you can standard forms. 


I think it's possible for fields like boolean fields, text fields, single/multiple select, but I haven't found a way for linked records...


Forum|alt.badge.img+3
  • Participating Frequently
  • 5 replies
  • July 12, 2023
Marielle_Gueis1 wrote:

I think it's possible for fields like boolean fields, text fields, single/multiple select, but I haven't found a way for linked records...


Oh, really? That'd be helpful, even if it is limited to those fields. Do you have any examples you could share? I've not been able to get it to work using syntax that works for regular forms. I did get filters in interfaces prefilled at one point, but that was pretty complicated and involved some base 64 encoding, which I mostly learned about here: https://community.airtable.com/t5/interface-designer/navigate-between-airtable-interfaces-how-to-generate-dynamic/td-p/120785


Forum|alt.badge.img+7

Hi Bobby, now even the linked fields can be prefilled!!

What I've done is create a form in the interface, publish, then use the url and write the variables like you would for the other forms. (documentation here). 
I think the link you shared is for filters on other types of pages, not for forms. 


Forum|alt.badge.img+10
Ashley_Jackson wrote:

Hi there, Is it possible to have a dynamic value prefilled into a form?  For instance, I have a library base for a small organization lending library.  You can view / search the catalog and if you find a book you'd like to check out, I want to offer a button that takes the viewer to a check-out form with the book pre-filled.  Possible?  Thanks!


Just agreeing with this feature and use case!!


Forum|alt.badge.img+10
Marielle_Gueis1 wrote:

Hi Bobby, now even the linked fields can be prefilled!!

What I've done is create a form in the interface, publish, then use the url and write the variables like you would for the other forms. (documentation here). 
I think the link you shared is for filters on other types of pages, not for forms. 


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.


Forum|alt.badge.img+15
Meredith_Scrog1 wrote:

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.


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!


Forum|alt.badge.img+4
Ashley_Jackson wrote:

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!


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?


Forum|alt.badge.img+16
Jonathan_Straus wrote:

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?


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

 


Forum|alt.badge.img+16
Celeste_Bancos wrote:

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

 


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!


Forum|alt.badge.img+11

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

 
I am trying to 'upgrade' to interfaces.  Whether I try to link to the original form, or to an Interface Form, I cannot pick up the current record when linking from an Interface button with the Action 'go to external URL'. 
 
I also have tried using Interface button with action 'go to interface page', but I cant see how to do prefills at all with that.
 
Can anyone else advise further?
 
Thanks

Forum|alt.badge.img+3
Margaret_Picker wrote:

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

 
I am trying to 'upgrade' to interfaces.  Whether I try to link to the original form, or to an Interface Form, I cannot pick up the current record when linking from an Interface button with the Action 'go to external URL'. 
 
I also have tried using Interface button with action 'go to interface page', but I cant see how to do prefills at all with that.
 
Can anyone else advise further?
 
Thanks

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.


Forum|alt.badge.img+7
  • Participating Frequently
  • 17 replies
  • February 9, 2024

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


Forum|alt.badge.img+2
  • New Participant
  • 1 reply
  • February 22, 2024

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


Reply