
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 19, 2023 05:46 PM - edited ‎Mar 19, 2023 05:55 PM
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
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 21, 2023 11:03 PM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 19, 2023 10:41 PM - edited ‎Mar 19, 2023 10:42 PM
It's probably because of an extra space. Try replacing:
{Client Commercial Controls}
With:
SUBSTITUTE(
{Client Commercial Controls},
", ",
","
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 21, 2023 01:06 PM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 21, 2023 07:11 PM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 21, 2023 11:03 PM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 12, 2023 07:20 PM
Thanks Adam @TheTimeSavingCo that's worked a treat!
