Prefill from field with another table field content

[yuval_hass]

Hey,

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?
Thnaks

[Nathalie_Collin]

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.

Airtable

Linking Basics - Airtable

Explore the "Linking Basics" base on Airtable.

[Justin_Barrett]

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

Airtable - Support

Prefilling a form

When making an Airtable form, you can use prefill_ parameters in the URL of the form to prefill specific fields. Find the URL for the form you wish to prefill. Once you get the form URL, you can ...

[yuval_hass]

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

[Justin_Barrett]

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.

[yuval_hass]

Hey,
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?

[Justin_Barrett]

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.

[yuval_hass]

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?

[Justin_Barrett]

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.

[yuval_hass]

Thanks justin
it works!!