Forum Discussion

GeorgeKhairalla's avatar
GeorgeKhairalla
Qrew Cadet
9 years ago

Trying to ""Count"" the number of selections in a multi-select text field

Hi, I have a multi-select text field : [ERP Products] I'm trying to have a Formula - Numeric field, to count the number of products that were selected. I have tried something like this: ...
Formulas and functions
Tables and fields
KevinBoyle's avatar
KevinBoyle
Qrew Trainee
7 years ago
It seems that the above solution has worked for people previously, but I am having a hard time with it. When I insert my multi-select text field after the ToText command, I get an error stating that was not expecting a textlist. It will still save, but doesn't return any results. I'm fairly new to this platform, so I'm not sure if I'm just doing something wrong or if this really isn't possible. Any help you can offer would be greatly appreciated. Thanks
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    I suggest you post your formula if you say it doesn�t work.
  • KevinBoyle's avatar
    KevinBoyle
    Qrew Trainee
    6 years ago
    Sorry for the delay. I have just copied the formula that you have shared above and changed the multi select field to the field in my app...

    var text value = ToText([Caller Needs, Interests, Drivers]);
    Sum(
    ToNumber(Trim(Part($value,1,";"))),
    ToNumber(Trim(Part($value,2,";"))),
    ToNumber(Trim(Part($value,3,";"))),
    ToNumber(Trim(Part($value,4,";"))),
    ToNumber(Trim(Part($value,5,";"))),
    ToNumber(Trim(Part($value,6,";"))),
    ToNumber(Trim(Part($value,7,";"))),
    ToNumber(Trim(Part($value,8,";"))),
    ToNumber(Trim(Part($value,9,";"))),
    ToNumber(Trim(Part($value,10,";"))),
    ToNumber(Trim(Part($value,11,";"))),
    ToNumber(Trim(Part($value,12,";"))),
    ToNumber(Trim(Part($value,13,";"))),
    ToNumber(Trim(Part($value,14,";"))),
    ToNumber(Trim(Part($value,15,";"))),
    ToNumber(Trim(Part($value,16,";"))),
    ToNumber(Trim(Part($value,17,";"))),
    ToNumber(Trim(Part($value,18,";"))),
    ToNumber(Trim(Part($value,19,";"))),
    ToNumber(Trim(Part($value,20,";")))
    )

    I have this in formula numeric field and trying to hopefully get a pie graph out of the data.
    • FadyIbrahim's avatar
      FadyIbrahim
      Qrew Member
      6 years ago
      Hi, I am trying this out but am getting a Syntax Error: Extra characters beyond the end of the formula. I copied the formula below. I am a bit of an amateur so forgive any silly mistakes. Any ideas? 

      New_variable = ToText();
      Sum(
      ToNumber(Trim(Part($value,1,";"))),
      ToNumber(Trim(Part($value,2,";"))),
      ToNumber(Trim(Part($value,3,";"))),
      ToNumber(Trim(Part($value,4,";"))),
      ToNumber(Trim(Part($value,5,";"))),
      ToNumber(Trim(Part($value,6,";")))
      )

      ------------------------------
      Fady Ibrahim
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        6 years ago
        not tested but try this.
        If there is a syntax error please post the your formula and the whole error message.

        var text value = ToText();

        Count(
        Trim(Part($value,1,";"))<>"",
        Trim(Part($value,2,";"))<>"",
        Trim(Part($value,3,";"))<>"",
        Trim(Part($value,4,";"))<>"",
        Trim(Part($value,5,";"))<>"",
        Trim(Part($value,5,";"))<>"")





        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        markshnier2@gmail.com
        ------------------------------
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    Try changing Sum to Count