Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Prefill form to multiple linked records

Topic Labels: Formulas
1547 4
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi guys,
I’ve been playing with the prefill form function that I’ve just discovered and am loving it! But I’ve hit a snag.
Im trying to prefill a form to link with multiple linked fields.
For example customer A has requested products A and B via a form. (products A and B are linked fields).
I then create a new prefilled form to send to purchasing with Prefilled sections on customer A, however I cannot figure out how to link to multiple products. I can only get Product A to prefill.

Heres the urls I’ve tried:
prefill_Equipment=Product+A,+Product+B
prefill_Equipment=Product+A++Product+B
prefill_Equipment=Product+A&+Product+B
prefill_Equipment=Product+A%20+Product+B
prefill_Equipment=Product+A/n+Product+B
prefill_Equipment=Product+A%0A+Product+B

Any ideas on how I can do this?

4 Replies 4

Hi there!

The following worked for me (you’ll want to replace “SharedViewID” with your own ID):

https://airtable.com/SharedViewID?prefill_Equipment=Product%20A,Product%20B

Hope that helps!

Thanks!
that worked, just need to figure out the formulas as I was using a substitute " ", “” to get that result. Might have to change my source to product codes instead of names

You’re very welcome! Happy to help further if need be :slightly_smiling_face:

Hi Neads
Can you be more specific about the replace “SharedViewID” with your own ID
Do I understand correctly The “SharedViewID” is the form ID
What is the own ID?

Ive got this formula which prefilled only first record from linked table “https://airtable.com/shrcqCEHRCq…?” & “prefill_Name=” & ENCODE_URL_COMPONENT({Name} & “”) & “&” & “prefill_INVOIC%20NUMBER=” & ENCODE_URL_COMPONENT({INVOIC NUMBER} & “”)