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.
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:
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.
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.