Prefilled single select field


#1

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!


#2

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.