Skip to main content

Prefilled single select field

  • March 28, 2018
  • 1 reply
  • 15 views
J
Forum|alt.badge.img+2
  • jn08
  • Known Participant

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

      J
      Forum|alt.badge.img+2
      • jn08
      • Author
      • Known Participant
      • March 28, 2018

      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.

      Terms & ConditionsAccessibility statement