0

I want to show a field only if a particular item in a multiple choice field is selected. How do I do this?

I tried setting it up as follows. In the field I want to show (not show) the I used the formula in the "Display Only if" formula as "Multichoice = TextForItemIWantToBeMet"  In other words, Field = Text, then I enter the text from the multiple-choice field. It doesn't work. I'm obviously doing something wrong.

7 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 4 yrs ago
    • Reported - view

    Use:   text(multiplechoice) = "textyouwanttocheck"

    • Peter_Saltzman
    • 4 yrs ago
    • Reported - view

    Perfect, that worked. Thanks, Steven!

    • Mr_K
    • 4 yrs ago
    • Reported - view

    I need help a formula to do this same thing when more than one "choice" is selected in the multi choice field.

    Here's my example. I want "Leauge Fees Paid" field to display if only one of the selections in the multichoice field is "PSO Home Games," irrelevant if any or all of the other multi choice sleections are selected. The formula I used is shwon here, and it only work if not other multi choices are selected.

    Screen Shot 2020-02-15 at 7.20.37 AMScreen Shot 2020-02-15 at 7.19.08 AM

    • Mr_K
    • 4 yrs ago
    • Reported - view

    I so badly wish I could edit my poorly spelled post!

    • Mr_K
    • 4 yrs ago
    • Reported - view

    I found the solution. Using the "like" function works:

    Screen Shot 2020-02-15 at 7.38.07 AM

    • Mr_K
    • 4 yrs ago
    • Reported - view

    FYI, you would think that this function would work as "not like" too, and the manual says that "not like" is the function, but it DOES NOT work. It has to be entered as "NOT (field) LIKE (text) instead of how you think it should be entered which is (field) NOT LIKE (text).

    Screen Shot 2020-05-13 at 10.58.48 AM

    • Ninox partner
    • RoSoft_Steven.1
    • 4 yrs ago
    • Reported - view

    Thanks for the information Mr. K, good to know.

Content aside

  • 4 yrs agoLast active
  • 7Replies
  • 2033Views