Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 19, 2022 01:25 PM
Let’s say I have a form integration connection to Airtable. When someone submit the form, an array of product IDS will be inserted into the product_ids field like [3294239423, 3873298293] (a long text field). Is there a way to use this array to lookup for products, using those ids?
Jun 19, 2022 06:29 PM
Welcome to the Airtable community!
It is possible, but how you do it depends on the setup of your base. If the product IDs are the primary field value in the linked table, you can copy/paste the long text field to the linked text field to make the links. Or you can use an automation to update the linked record field with the value from the long text field.
If the linked table has a different value in the primary field, this can be done with scripting, or possible with a third party automation tool.
Jun 19, 2022 07:35 PM
How it will work if the long text field includes multiple ids in a cell? It seems not to be the primary fill, it actually the Record ID. Is there a way that I can do this without using code? I’m free to modify the format of the id list field.
Jun 20, 2022 07:07 AM
If the long text field is a comma separated list of primary field values, you can copy/paste the values or use an update automation.
If the long text field is a comma separated list of Airtable record IDs, you cannot copy/paste the values, but you can still use an update automation. However, the examples you gave are not Airtable record IDs. Airtable record IDs stare with rec
and are followed by 14 alphanumeric characters.