Skip to main content

Prefill form to multiple linked records

L

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

A
  • AlliAlosa
  • Inspiring
  • 382 replies
  • May 10, 2019

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!

D
T
J
3 people like this
  • D
    Dumpl
  • T
    Tony_Rogers
  • J
    Justin_Barrett
L
  • Lucas_Mason
  • Author
  • New Participant
  • 1 reply
  • May 11, 2019
AlliAlosa wrote:

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

A
1 person likes this
  • A
    AlliAlosa
A
  • AlliAlosa
  • Inspiring
  • 382 replies
  • May 13, 2019
Lucas_Mason wrote:

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:

J
  • Juraj_Marko
  • New Participant
  • 2 replies
  • March 14, 2021
AlliAlosa wrote:

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!


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} & “”)

Reply


Most helpful members this week

Terms & Conditions