Skip to main content
Solved

Airtable form: Pre-fill two values from a linked field

  • March 20, 2023
  • 5 replies
  • 59 views
N
Forum|alt.badge.img+4

Hi,

I am trying to pre-fill two records in an Airtable form from the following column "Client Commercial Controls":

If I pull up the pre-filled form, currently I can only pre-fill the one value ("Police check to be performed"), but I also want to pre-fill the second value ("Data security policy to be added").

This is the formula I am using to pre-fill the form and have no issues when only pulling in one value, but can't work out how to pull in multiple values. 

Please advise.

Many thanks,

Nik

Best answer by TheTimeSavingCo

Hi Adam @TheTimeSavingCo ,

No luck yet unfortunately. I created a new column with your formula above:

But when I update the pre-filled form formula, only the first linked value appears rather than both. 

Any ideas?

Thanks,

Nik


Looks like the records you're linking to have commas in the primary field, causing the formula field to wrap them with quotes.  You could try getting rid of the quotes with a substitute, but if I were you I'd just use the record IDs instead.


To do that, add a formula field in your "Client Commercial Controls" table with the formula "record_id()", and then in your original table add a rollup field on the "Client Commercial Controls" field to grab all the record IDs of the linked records, then use that in your formula

Here's an example

 

5 replies

TheTimeSavingCo
Forum|alt.badge.img+31

It's probably because of an extra space.  Try replacing:

 

{Client Commercial Controls}

 

With:

 

SUBSTITUTE( {Client Commercial Controls}, ", ", "," )

 

Adam, Airtable Consultant - thetimesaving.company
Hannah_Wiginton
Hannah_Wiginton
Forum|alt.badge.img+19

If you want forms with more features and easier prefill options, you might look at our On2Air Forms app for Airtable. We have a Free version and upgraded versions - https://on2air.com/forms

---Hannah - On2Air.com - Automated Backups for Airtable
N
Forum|alt.badge.img+4
  • Nik_von_Pueckle
  • Author
  • Known Participant
  • March 22, 2023

It's probably because of an extra space.  Try replacing:

 

{Client Commercial Controls}

 

With:

 

SUBSTITUTE( {Client Commercial Controls}, ", ", "," )

 


Hi Adam @TheTimeSavingCo ,

No luck yet unfortunately. I created a new column with your formula above:

But when I update the pre-filled form formula, only the first linked value appears rather than both. 

Any ideas?

Thanks,

Nik

TheTimeSavingCo
Forum|alt.badge.img+31

Hi Adam @TheTimeSavingCo ,

No luck yet unfortunately. I created a new column with your formula above:

But when I update the pre-filled form formula, only the first linked value appears rather than both. 

Any ideas?

Thanks,

Nik


Looks like the records you're linking to have commas in the primary field, causing the formula field to wrap them with quotes.  You could try getting rid of the quotes with a substitute, but if I were you I'd just use the record IDs instead.


To do that, add a formula field in your "Client Commercial Controls" table with the formula "record_id()", and then in your original table add a rollup field on the "Client Commercial Controls" field to grab all the record IDs of the linked records, then use that in your formula

Here's an example

 
Adam, Airtable Consultant - thetimesaving.company
N
Forum|alt.badge.img+4
  • Nik_von_Pueckle
  • Author
  • Known Participant
  • April 13, 2023

Looks like the records you're linking to have commas in the primary field, causing the formula field to wrap them with quotes.  You could try getting rid of the quotes with a substitute, but if I were you I'd just use the record IDs instead.


To do that, add a formula field in your "Client Commercial Controls" table with the formula "record_id()", and then in your original table add a rollup field on the "Client Commercial Controls" field to grab all the record IDs of the linked records, then use that in your formula

Here's an example

 

Thanks Adam @TheTimeSavingCo that's worked a treat!

TheTimeSavingCo
Terms & ConditionsAccessibility statement