Skip to main content

Prefill form to multiple linked records

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?

    This topic has been closed for replies.

    4 replies

    Forum|alt.badge.img+19

    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!

      • Lucas_Mason
      • Author
      • New Participant
      • May 11, 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!


      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

        Forum|alt.badge.img+19

        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:

        Forum|alt.badge.img+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!


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

        Terms & ConditionsAccessibility statement