Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 26, 2018 07:59 AM
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.
Feb 07, 2019 06:46 AM
Hi Lauren,
You should be able to prefill a field by editing the form share URL like in this article: https://support.airtable.com/hc/en-us/articles/234982508-Prefilling-a-form
Keep in mind though that populating pre-fill data in the form view within the app or web-app is not possible. Only through share links and embeds can pre-filling of data be attained. This is also evident in the fact that you cannot submit data via a form view in the app or web-app.
Feb 07, 2019 07:10 AM
Thanks, @Patrick_Ford1. I’ll look into that workflow…
Mar 18, 2019 05:54 AM
Hi,
I have read through all this and other forum articles and have been trying for a while BUT I cant seem to prefill a form with a linked data field using the record_id in the URL with prefill_ parameter.
@Airtable or anyone else please can you share a basic example of an url that works? or some info on restrictions or what might not work in this case?
TIA
Cor
Mar 18, 2019 06:09 AM
Hi @cor I believe you would have to change the field name to something that does not have symbols in it that confuse the URL. For example putting slashes in a field name could be misread, as could the underscore, as in your case. Try renaming the field name.
Mar 18, 2019 09:00 AM
Hey @cor! Rather than using the record_id, you’ll need to use the actual name of the field (as seen in your grid view) to reference in the prefill URL.
Hope that helps!
Mar 05, 2020 06:12 AM
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
Mar 05, 2020 07:38 AM
Post an example prefill URL here. My hunch is there’s something wrong with the prefill link.
Mar 05, 2020 10:01 AM
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.
Mar 05, 2020 10:03 AM
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-ENC...
May 26, 2020 10:52 AM
Is there any update to this question please