Nov 04, 2021 09:34 AM
Hello. Is there a way to create a single or multiselect field using records from a linked field? In other words, if you have records in a linked field and you want them to be displayed in another field as single select or multiselect options, is this possible and how?
Nov 04, 2021 11:13 AM
From my experience so far, there are two ways to do this type of action:
The automation is quite ease to be set up, follow this script:
For a first massive upload, once you have enabled the auto, you can just delete the source column and then undo the action. This fact will trigger the automation since the value has changed for the source, then the target will be filled conveniently
For any upcoming record, every time that the multilink is updated, the multiselect will mimic it
I hope that this helps
Nov 09, 2021 12:49 PM
Hi Xavier. I followed your script, step-by-step, but when a new record is selected and added to the source (multi link) field, the target (singleselect or multiselect) field tacks it on at the end of an existing select field option, separated by a comma. The automation appears to add this as a new select option in the target field, but it is made up of an existing record combined with the new record, just separated with a comma, instead of delineating it as a separate target (singleselect or multiselect) field option. Any ideas?
Nov 10, 2021 12:48 AM
I did a test myself in a simple base, and in my case it worked. I will add pics and comments so you can follow every step and be sure that I understood your needs.
Contains the key (LKX values) and the link to the base table created by Airtable
Contains its own key (BKX values) and a linked field to the linked table (it can be populated with multiple values) and a multiselect that is populated by my automation when there’s a change in the linked field key
Automation 1st step
Triggers when the linked key value changes in the base table
Automation 2nd step
The record in the base table that has been modified (linked key change) is updated by setting the linked field multiselect to the name of the linked field key
The values in the multiselect are created individually by the automation from scratch and are not a concatenation by commas
I did also the same test but populating the multiselect in the base table with the contents of a new field that I created in the linked table, just to be sure that the procedure was right. It also worked fine
My guess is that you are using a Single select field instead of a Multiselect field for the target, in that case, you get the behavior you describe, the only way for the automation to create a new option is by concatenating the source values into a single one
I hope that this helps, let me know if you can solve the issue
Nov 10, 2021 07:04 AM
Thanks Xavier. It wasn’t clear before, whether this automation worked for single and multi select or just multiselect. Appreciate the clarification.