Prefill from field with another table field content

Topic Labels: Formulas
7781 16
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast


I have a form and I wish to auto-fill a field with content in another table.
It’s already linked to another table and I want to have a specific info auto-filled.

How it’s done right?

16 Replies 16

Hi @yuval_hass and Welcome to Airtable!

Once you’ve linked the two sheets together, you can now add all sorts of functionality between the two sheets. What you’re looking for is the LOOKUP column. Create a LOOKUP column in your first sheet.
In the configuration, select the column that is currently linked to the other sheet and then below that, select the field in the other table that you’re looking to pull in.

Here’s the base if you want to copy and play around with it.


Linking Basics - Airtable

Explore the "Linking Basics" base on Airtable.

@yuval_hass: Here’s the info on prefilling form fields:

Thanks, prefilling of content works fine but not a value that lives in another table.

That’s where the suggestion from @Nathalie_Collins comes in. You’ll need to link/lookup the field you want to bring it into the table containing your form.

I’m not looking for lookup solution
I want to prefill several form fields with a value.
it’s already linked to another table and giving values using the URL doesn’t work :frowning:

any idea?

Could you share more details about the URL you’re trying to use when prefilling the form? Perhaps there’s a problem with the URL.

Thank you Justin

when its a text box I can easly use the prefil url parameters.
When it’s anoter entity we get a + sign on a button… clicking that open a new window and I can choose the parameter I wants.

what do you think?

If I understand you correctly, you’re saying that when trying to prefill a field that’s a link to another table, it’s not prefilling the entry, and you still have to pick the item manually. Is that correct? If so, then there may be a problem with how you’re building your form URL to prefill the field. I just ran a quick test with prefilling a linked field, and it worked fine.

Could you share the URL you’ve built? If you don’t want to share the URL for your actual project, perhaps make a quick temp table and form that you can use to demonstrate the problem.

Thanks justin
it works!!