I use a formula to combine different categories e.g. Category1 + Category2 + Category3 ... to display them in a table.
That's the formula:
That works fine in general if there weren't some conditional field usabilitity errors.
It happens that an agent initially selects ticket-form1, and selects a value from category1.
Then for some reason he changes the ticket to ticket-form2 and selects a value from category2. The agent does not clear the category1 value.
Now, of course, the formula shows a value "category1category2" because category1 is still selected in the background of the ticket, instead of showing "category2" which is visible in the ticket.
I now need a command for the formula that allows only those values to be selected that are currently in the visible layer in the ticket.