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

[Joseph_Luk]

May I ask how you got it to work? I’m now stuck on what I believe to be the same problem

[Joseph_Luk]

May I ask how you got it to work? I’m now stuck on what I believe to be the same problem

[Joseph_Luk]

I’ve succeeded in prefilling the “Name of broker” field with ‘Clark Kent’, but i’m also trying to prefill the ‘individual_being_reviewed’ field (a linked field) with a selection from that other table. I’m just trying to pre-fill (or pre-select to be more precise) with an option. Is that possible?

I’d like just it to be option 1.

[Justin_Barrett]

The “prefill_” prefix has to be on every field reference, not just the first one. It should look like this (after your base form URL):

…prefill_Name%20of%20broker=Clark%20Kent&prefill_individual_being_reviewed=1

[Joseph_Luk]

Thanks so much! Works like a charm

[Joseph_Steenso1]

Another related question, not sure if its worth another whole question or if posting here is correct.

Is there a way to prefill using another field’s data if that data has spaces in it? eg in the example below if {Names} was John Doe it only shows up as John, as the Doe is after a space. I’m aware I probably don’t need the concatenate but with & and + signs in formulas and URLs it was getting confusing.

CONCATENATE(“https://airtable.com/xxxxxxxxxxx?prefill_Property=",Property,"&","prefill_Names=”,{Names})

Thank you in advance

[Justin_Barrett]

Welcome to the community, @Joseph_Steenson1! :grinning_face_with_big_eyes:

Joseph_Steenson1:

Is there a way to prefill using another field’s data if that data has spaces in it?

Wrap the field name in the ENCODE_URL_COMPONENT() function. It’s probably best to do that with all data pulled from other fields, in case there are other special characters that need to be escaped.

A couple other tips:

1. You don’t need to have the “&” as its own string item. It can be combined with the next prefill piece after it.
2. You don’t need curly braces around “Names”.

CONCATENATE("https://airtable.com/xxxxxxxxxxx?prefill_Property=", ENCODE_URL_COMPONENT(Property), "&prefill_Names=", ENCODE_URL_COMPONENT(Names))

Also, you can combine pieces using the & operator, which is often more compact than using CONCATENATE().

"https://airtable.com/xxxxxxxxxxx?prefill_Property=" & ENCODE_URL_COMPONENT(Property) & "&prefill_Names=" & ENCODE_URL_COMPONENT(Names)