When using a form, you can pre-fill linked fields in forms by using the Record ID for the record you want into a single line text field instead of the actual name, then use Zapier, IFTTT, or (my personal favorite) Integromat to update the linked field with that record ID. I realize it’s cumbersome, but you just have to have it, it works. I do this for several of my forms.
Stan_DZ wrote:
Hey @Jason, I’m having the same issue that @cor was mentioning, ie prefill a form with a linked data, and I tried both using the record_id and the actual name as seen in the grid view, but both don’t seem to work… I still see the “+ add” button showing on my form, rather than the linked record.
Hope that’s clear ! Thanks a lot
Post an example prefill URL here. My hunch is there’s something wrong with the prefill link.
Hi @Stan_DZ, I’d recommend using the ENCODE_URL_COMPONENT formula function to help generate the field names to use in your prefill URL. This formula translates characters like spaces (and many other characters) into a format readable by your browser URL.
Using your example field name, Choix de la formation should read as Choix%20de%20la%20formation when entered as part of the prefull URL.
Also, here’s an article that walks you through setting this up in your base: https://support.airtable.com/hc/en-us/articles/360039781394-Build-a-custom-form-URL-filler-using-ENCODE-URL-COMPONENT
Cheryl_Treharne wrote:
Is there any update to this question please
About what? This a #show-and-tell post that shows how to do something.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.