Discussions

Expand all | Collapse all

Formula Help

  • 1.  Formula Help

    Posted 12-12-2018 20:55

    I have 10 Text ? Multiple Choice fields that use the same 3 choices; A, B or C. I want to extract just the ?B?s. I?m looking for a better way than 10 separate Formula ? Text field with if statements looking for the ?B?s and another Formula ? Text field with the results. Tried Case & If but can?t seem to get it.

    Thanks

    Mike



  • 2.  RE: Formula Help

    Posted 12-12-2018 21:05
    What do you mean to "extract".  A report?
    Just make a report with 10 "any" conditions.

    or else make a field with

    [Field 1] = "B"
    or
    [Field 2] = "B"
    or
    [Field 3] = "B"
    etc

    or
    [Field 10] = "B"

    Then you have a clean hook for any reports


  • 3.  RE: Formula Help

    Posted 12-12-2018 21:25

    Thank you for responding so quickly, after posting I realized I wasn't clearly explaining what I want to do. The users pick choice A, B or C from Field 1, then choose from a conditional drop down in Field 2. I want to take the results of a B choice in Field 1 from Field 2 and combine them in another text field. For example; if the choices in Field 1 are: Dog, Cat & Bird & the user chooses Dog he only can pick different dogs. I want to pull out just the dog picks for the text field which would be something like "customer prefers [choice 1], [choice 2], [choice 3]". Hope this helps
     Mike


  • 4.  RE: Formula Help

    Posted 12-12-2018 21:33
    There is not a naive way to have a conditional multi select drop down in Field B.  By that I mean that if the user chooses Dog, then a conditional drop down can offer up only Dogs breeds, and then the use may select 1 dog. and that can be the field Choice 1.

    Then you can have a separate Conditional drop down, also set by the same initial selection of Dogs in field A, and then the user can once again choose a Dog breed as Choice 2.

    same for choice 3.

    Then if you like you can use a formula field to concatenate them all together n a comma separated list.


  • 5.  RE: Formula Help

    Posted 12-13-2018 01:04
    Thank you for the info, I thought that might be the case. What I tried was multiple if statements to pull out the choices, then a formula text field to concatenate them. It worked somewhat, but if you give people 10 places to pick from 3 choices it makes for a pretty ugly outcome. Plus I had 2 more that had 15 fields. Thanks again, moving on to the next stumbling block.