Skip to main content

Hello,

I'm learning how to pre-fill a form.  I really like it but it would be even better if I could prefill a form entry with multiple values/entries from another linked record.  Currently, it is only pre-filling the first value of cell.  The linked record in this formula is the Residents Column.

I need them to stay selectable values, not text.  I can't expect the users to enter the text values exactly as they are written in the linked records.

 

& "prefill_Job=" & ENCODE_URL_COMPONENT({Job})
& "&prefill_Order=" & ENCODE_URL_COMPONENT({Order})
& "&prefill_Teams=" & ENCODE_URL_COMPONENT({Teams})
& "&prefill_Residents=" & ENCODE_URL_COMPONENT({Residents})
& "&prefill_Description=" & ENCODE_URL_COMPONENT({Description})

@malan 

If you’d like to do this with Airtable’s native forms, I would recommend using @kuovonne’s Prefilled Forms extension, which will generate the proper URL formula for you.

For another way of doing this, you can use Fillout’s advanced forms for Airtable, which is 100% free and guides you through the process of creating prefilled forms in many different ways.

Even better, if you ever need to update records from a form, Fillout lets you update Airtable records directly from a form without creating any lengthy prefill URLs at all!

Fillout also offers hundreds of other advanced features that aren’t available in Airtable’s native forms.

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 

@malan 

If you’d like to do this with Airtable’s native forms, I would recommend using @kuovonne’s Prefilled Forms extension, which will generate the proper URL formula for you.

For another way of doing this, you can use Fillout’s advanced forms for Airtable, which is 100% free and guides you through the process of creating prefilled forms in many different ways.

Even better, if you ever need to update records from a form, Fillout lets you update Airtable records directly from a form without creating any lengthy prefill URLs at all!

Fillout also offers hundreds of other advanced features that aren’t available in Airtable’s native forms.

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 


Hi @ScottWorld ,

The URL is formatted properly.  In the URL I see the multiple values separated by an %2C.  The issue is that the multiple values from the URL aren't propagating in the form correctly.  The first one shows up but the others don't. I'll play around with the extensions to see if they solve the problem!  I'll reach out if I'm still struggling.  Thanks for your help!

Tim

@malan 

If you’d like to do this with Airtable’s native forms, I would recommend using @kuovonne’s Prefilled Forms extension, which will generate the proper URL formula for you.

For another way of doing this, you can use Fillout’s advanced forms for Airtable, which is 100% free and guides you through the process of creating prefilled forms in many different ways.

Even better, if you ever need to update records from a form, Fillout lets you update Airtable records directly from a form without creating any lengthy prefill URLs at all!

Fillout also offers hundreds of other advanced features that aren’t available in Airtable’s native forms.

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 


Fillout is displaying multiple values from a linked record.  Thank you!

That's awesome! You're welcome! 🙂 Yeah, I love Fillout. It's one of my favorite tools to use with Airtable.

- ScottWorld, Expert Airtable Consultant

Reply


Terms & Conditions