Skip to main content
Question

Formula Help

  • December 13, 2018
  • 0 replies
  • 32 views

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

This topic has been closed for replies.

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

  • Author
  • Quickbase Alumni
  • December 13, 2018

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

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.