Managing multi-select fields via buttons and automations?

Get Help
1

In my database Action Items I have a multi select field called “MultiSelectField” that I’d like to use a button to update. The values assigned should mirror a set of strings delimited by a space " " contained in a text field called valuesAsStrings.

I am working with the AI formula assistant, and I try the following formula in the Action section:

MultiSelectField.Filter(
Find([Step 1 Action Items].[valuesAsStrings], Name) >= 0
)

when I hit the button, it assigns ALL possible values of MultiSelectField, not only those that match strings in valuesAsStrings.

Is there a way to do this? I’m not really able to use scripts at this point.

2

Try without the =

i.e.

But be aware that using Find is risky if there could be overlap in the strings, e.g. your options include ‘SWDev’ and ‘SW’

3

Ah, that worked -thanks!