Help

Prefilled single select field

1675 1
cancel
Showing results for 
Search instead for 
Did you mean: 
jn08
6 - Interface Innovator
6 - Interface Innovator

Hi, I’m a bit stuck with prefilling a form. I’ve got a single select field that won’t prefill, and I’m not sure what’s causing it. Could be a bug, but a different single select field is prefilling, so I’m not sure what the issue is. The XXXX is the URL of the form, but I haven’t included that for security reasons.

"https://airtable.com/XXXX?prefill_Body%20Matter%20End%Page=" & SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( {Body Matter End Page}, "%","%25")," ","%20"),"?","%3F"),"&","%26"),"=","%3D"),"{","%7B"),"}","%7D"),"[","%5B"),"]","%5D"),"\n","%0A")"

Would appreciate any help!

1 Reply 1
jn08
6 - Interface Innovator
6 - Interface Innovator

I’ve done a little more digging and it appears that I can get the above code to work with a single select field so long as the contents of the single select field are more than one word. If it’s just a single word then the single select field just doesn’t recognise it or something. No idea why.