Help

Re: Filling multiple feilds with a url formula

Solved
Jump to Solution
1023 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I cant seem to get this formula to work. its prefilling an airtable form but i cant get the second feild to fill. it says its a good link it just doesnt fill the second box.
heres what i have
CONCATENATE(‘https://airtable.com/shr4cGVHhm4dRLllz?prefill_UNIT=’,{UNIT} & ‘&PLANT=’,{ENCODE PLANT})
here is an example of what that outputs
https://airtable.com/shr4cGVHhm4dRLllz?prefill_UNIT=261A&PLANT=12-CONV
the unit number prefills fine but the plant does not. 261A is the data from the UNIT table. the title of the field on the form is also UNIT. 12-CONV is the data in the feild PLANT. The title of the feild on the form is also PLANT
note everything in my base is in all caps and “encode plant” is all the plant names run through the url encode formula. i also have a single select with three options id like to prefill also if someone can help me with adding that as well?

1 Solution

Accepted Solutions
gwynn_kruger
6 - Interface Innovator
6 - Interface Innovator

To add the manager single select might look something like:

CONCATENATE('https://airtable.com/shr4cGVHhm4dRLllz?prefill_MANAGER=',{MANAGER}, '&prefill_UNIT=',{UNIT} & '&prefill_PLANT=',{ENCODE PLANT})

See Solution in Thread

3 Replies 3
gwynn_kruger
6 - Interface Innovator
6 - Interface Innovator

It looks like you’re missing the prefill_ prefix on the second field. Give this a try:

CONCATENATE('https://airtable.com/shr4cGVHhm4dRLllz?prefill_UNIT=',{UNIT} & '&prefill_PLANT=',{ENCODE PLANT})
gwynn_kruger
6 - Interface Innovator
6 - Interface Innovator

To add the manager single select might look something like:

CONCATENATE('https://airtable.com/shr4cGVHhm4dRLllz?prefill_MANAGER=',{MANAGER}, '&prefill_UNIT=',{UNIT} & '&prefill_PLANT=',{ENCODE PLANT})

thank you not only did this work but i get it now. lol