I would like to delete a select list item from all rows. For example, let’s say that Colors is a multi-select list column with the entries “Red, Green, Blue”. Thus, each row can have zero or more of these values selected.
Now let’s say I want to remove “Blue”. I can remove it from the column’s select list, but it still remains in all rows previously containing “Blue”. How can I remove this value from all rows without destroying the other values for that row. For example, if a row is marked as “Red, Blue”, it should end up being just “Red”.
My plan is to use a FormulaMap inside a button, but I am not sure how to “subtract” a value from a select list within a row. Something along the lines of:
Rooms.FormulaMap( CurrentValue.ModifyRows(Rooms.Colors, CurrentValue.Colors - "Blue") )