Skip to main content
Solved

Pre-fill Formula to Work in a Form to Display Multiple Values from another Linked Record not as Text


  • New Participant
  • 2 replies

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})

Best answer by 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 

View original
Did this topic help you find an answer to your question?

4 replies

ScottWorld
Forum|alt.badge.img+20
  • Brainy
  • 8711 replies
  • Answer
  • February 13, 2025

@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 


  • Author
  • New Participant
  • 2 replies
  • February 13, 2025
ScottWorld wrote:

@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


  • Author
  • New Participant
  • 2 replies
  • February 13, 2025
ScottWorld wrote:

@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!


ScottWorld
Forum|alt.badge.img+20
  • Brainy
  • 8711 replies
  • February 13, 2025

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