Formula Help

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • In Progress

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

Photo of Mike

Mike

  • 40 Points

Posted 1 month ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 57,468 Points 50k badge 2x thumb
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
Photo of Mike

Mike

  • 40 Points

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
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 57,468 Points 50k badge 2x thumb
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.
Photo of Mike

Mike

  • 40 Points
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.