Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: Prefilling a form with a linked record

Solved
Jump to Solution
287 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Phaderon
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there,

I have two tables and an interface with a form. The first form is used to add an entry to the table. I have this displayed as a nice gallery.

I wanted to add a button on the gallery, so the user can click the button on the record and it will take them to another form to request a change to that record. I've got about 90% there, but getting the field to prefill with the record_ID has been miserable. I've tried every combination and it just doesn't work.

On the form I added a new field "Link to another record". I select my primary table and select some columns to bring in via lookup. It looks great, the user can use the drop down to view all submissions and select the one they want. But the prefill doesn't work to auto select it. 

https://airtable.com/HIDDEN/HIDDEN/form?prefill_Vacancies=["rec1YlesldDRjs06V"]
https://airtable.com/HIDDEN/HIDDEN/form?prefill_Vacancies=rec1YlesldDRjs06V

Nothing prefills the entry. If I try another field, like Name or Title which isn't a linked record field, it works fine.

I also don't want to use any extensions which have the word "Pricing" in the header bar either. Any ideas?

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hmm, I managed to get this to work but I'm not sure if our setup is the same?

Assuming your data looks like this:

Screenshot 2025-02-03 at 10.54.26 AM.png

Screenshot 2025-02-03 at 10.54.29 AM.png

And your gallery looks like this:

Screenshot 2025-02-03 at 10.54.31 AM.png

And you want the opened form to look like this with the Vacancies prefilled: 

Screenshot 2025-02-03 at 10.54.36 AM.png

Then this is the formula I ended up using, which looks the same as yours, really

 

 

'https://airtable.com/apppBA7UfjDul9W4z/pagfAPuU0opCeirkX/form?prefill_Vacancies=' & RECORD_ID()

 

If you could DM me a link to your base I could help you take a look at it?  And heres a link to the base I set up in case you'd like to use it as a comparison!

See Solution in Thread

5 Replies 5
ScottWorld
18 - Pluto
18 - Pluto

@Phaderon 

You can use @kuovonne’s Prefilled Forms Extension, which will generate the proper URL formula for you.

Also, if you would like your users to update the record directly (without needing to request an update), this is much easier done via Fillout, which is 100% free and lets you directly update Airtable records from a form with no prefill URLs necessary.

- ScottWorld, Expert Airtable Consultant 

Phaderon
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you for the extension. I followed it and it produced links for me, but those were the same as the links I had before. No matter what I do, the field in the form just refuses to prefill.

I don't want to look into Fillout, looks alright (not sure if you need to disclose you are posting affiliate links or not), but I'd rather keep things all with Airtable.

TheTimeSavingCo
18 - Pluto
18 - Pluto

Hmm, I managed to get this to work but I'm not sure if our setup is the same?

Assuming your data looks like this:

Screenshot 2025-02-03 at 10.54.26 AM.png

Screenshot 2025-02-03 at 10.54.29 AM.png

And your gallery looks like this:

Screenshot 2025-02-03 at 10.54.31 AM.png

And you want the opened form to look like this with the Vacancies prefilled: 

Screenshot 2025-02-03 at 10.54.36 AM.png

Then this is the formula I ended up using, which looks the same as yours, really

 

 

'https://airtable.com/apppBA7UfjDul9W4z/pagfAPuU0opCeirkX/form?prefill_Vacancies=' & RECORD_ID()

 

If you could DM me a link to your base I could help you take a look at it?  And heres a link to the base I set up in case you'd like to use it as a comparison!

Phaderon
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you for that link. Looking at it, it does look identical (almost) to how I have mine, just with a lot more fields.

When you added the field to be pre-filled, did you add "Link to another record"?
That is all I've done on my form and the prefill just refuses outright to fill it in for me. No matter what I do. 

Phaderon
5 - Automation Enthusiast
5 - Automation Enthusiast

Well, the problem is fixed. 

For whatever reason, the form which was all attached to, was I guess bugged? I ended up deleting the table associated to it, the form then broke so I delete that. I rebuilt it, added my Vacancies column and it just works now. So pleased with that. Thanks for pointing me in the right direction.