Making multi-select options with query result.

[Jefflai0315]

I am able to display the query result. However, would like to know if I am able to make the item within the result array into the choices of a multi-select option filed?

[mjashanks]

Hi @Jefflai0315

You need to surround your multi-select in a Data Provider

Your structure will look like

> Form
  > Data provider : Data = Your query
     > Options picker : Source = data provider

You'll also need to configure your options picker with Label and value columns, so that it knows which field to use for it's display.

[Jefflai0315]

Thanks for the quick response @mjashanks !

Instead of having it as a single option, how can I split it into multiple options by comma?

[mjashanks]

If you are using a REST query or a custom SQL query, you should use a transformer to do this.

So.

1. Find your query in the Data section
2. In the transformer box, you should be writing something like

return data.yourFieldName.split(',');

i.e. split will take a comma separated string, and return an array of items.