Choose Multiple Field: Count number of choices?

Options
Jozef_783863
Jozef_783863 Posts: 331 admin
in Questions

Is Field: Field Formulas the best way to identify how many choices were input into a Choose Multiple field? After looking through the action list (at first glance), I did not see a specific action for this purpose. So I would like to place this question here while I test my Field Formula.

Along with returning the count I would also like to use this in a condition (ex: start if count is more than 1). I plan to include 5 choices in my Choose Multiple field.

Best Answer

  • Jozef_783863
    Jozef_783863 Posts: 331 admin
    Answer ✓
    Options

    I uncovered an alternative approach that does not need Field: Field Formulas (score!).

    The two steps include:

    1. Tables: Convert text to a data table
    2. Tables: Count Rows in a Table

    The first step takes in my Choose Multiple value (ex: One,Two,Three,Four,Five). Then it breaks up text into a data table by a custom row delimiter. In this case, the custom row delimiter is a comma. This creates a table where Column 1 includes one row for each selected choice.

    The second step counts the rows in Column 1 and returns the total number of selected choices. Selecting only 1 choice in the field works as well.

    I hope this helps in case others run into this same question.

Categories