May 12, 2021 12:12 AM
I have an Automation that updates a Multi-Select field in a different table. When the update occurs it over writes what is currently in that field. Each name has a different color.
I want to augment, or add to the existing data in the Multi-Select field not over-write it. Not sure how to approach the problem within Automation.
For Example, a field of user names, each name is in a color bubble separated with a space. Initially the field is updated with the name “John”. A second update to the field with the name of “Tom”. The resultI was expecting is : “John Tom”, or “John, Tom” each name in a different color bubble, but what I get is “Tom” and an empty color bubble.
May 12, 2021 05:24 AM
Welcome to the community, @Scott_Jenkins!
You can do this by inserting the current multi-select field (the “names” value) into the field, then adding a comma, then adding the new value.
May 12, 2021 03:54 PM
Scott, Thanks for the tip. From your tip, it dawned on me I need a Lookup of the field in the table I was wanting to modify.
Mar 30, 2022 07:39 AM
Somebody just emailed me to ask me about this thread. For those people who are finding this thread through a search, here’s a screenshot of how you can update a multi-select field to include BOTH the previous multi-select values AND the new value:
Jun 13, 2022 12:39 PM
this is useful!
But when I try this method, it adds a new blank option in my multi select and in the field updated by the automation
Can someone help me with this? :slightly_smiling_face:
Jun 13, 2022 01:01 PM
That means that your field was previously blank before adding the new value. Try swapping the 2 values and see if that solves the problem. So put the “new value” first, then add a comma, then add the multiselect field value last.
Sep 21, 2022 12:07 PM
Hi, i think i’ve the answer but… Is it possible to remove one of the selected options in a multi select field ?
Something like that :
Before = [Working] [Compiling] [Talking] [Waiting]
After = [Working] [Compiling] [Talking] [Running]
Takes all the selected items from the previous state of the field… Remove one on them (waiting)… And add one another (running)…
Thanks for all
Sep 26, 2022 03:27 AM
Hmm, how are you triggering the automation to do this?
I think if I were you I might just have a formula field that outputs the options I want selected, and pastes said value into the multiple select field
Dec 28, 2022 04:40 AM
i tested it. it doesn't make a difference whethere you include the variable for the previous multi select options. unfortunately airtable always adds a BLANK multi select option if it is previously empty. strangely, if initially there is a value, it only adds that value and not an additional blank category. it think that's a bug that should be fixed.