Prefill linked record in form by record ID

[Martin_Kopischk]

I am very glad Airtable has added options to the possibilities for prefilling forms, especially the ability to prefill linked records. However, it seems this functionality expects the record index string as the prefill query parameter. I’m happy to have someone point me to the right way to do this if I am mistaken, but if I am not, I would find it very useful to link records by record ID. This would make scenarios like this possible:

1. enter the One part in a One to Many data relationship in a first form;
2. redirect the first form to https://airtable.com/formForManyPart?prefil_link={record_id} on success;
3. enter one Many part correctly linked to its One.

Our exact usage scenario is to allow students to request resources for a project, with the ability to add the project to our DB first if it does not exist yet. Having that newly created project linked straightaway to the requested resources in the form would take away a lot of friction.

[Antony_Rappai]

Hello there @Martin_Kopischke, Nice work on the record ID URL prefill, however, i had a question, what if it was not the record_id and if it was another field from the table? Would you just put that field name ?

Thanks
Anto

[Martin_Kopischk]

Hi Anthony, as linked to in my original post, Airtable has a support page explaining form pre-filling. I think you will find the answer to your question there.

[Adnan_Ahmed]

This is very helpful. Thank you very much for taking the time to break it down with images so that the rest of us can recreate it easily :grinning_face_with_big_eyes:

[Moe]

Antony_Rappai:

what if it was not the record_id and if it was another field from the table? Would you just put that field name ?

We built an advanced form for Airtable. It allows you to redirect the users to a “field in Airtable”. Which could include any other value, not just the record ID.

miniExtensions for Airtable

Redirect to an Airtable Field with miniExtensions Form

Redirect users to a formula and pass any variables. E.g. After they submit the form, send them to different URLs based on their answers