Show hide fields on mask...

I have problems with the field display formulas:

If the option selected is Pool it shows Category and Customer Fields

If the selected option is Robot or Mosquito AND Option Type is selected (shown only for these selected options) it shows Category and Customer Fields.

The formula is set to Category and Customer Fields.

if Settore != null and text(Settore) == "Piscine" then
    if Tipologia == null and text(Settore) == "Piscine"  then
            if Tipologia != null and text(Settore) != "Piscine"  then
                true else false

But with this formula if i select Pool Option sector the Category and Customers data field is hiddend but i want show in this case!!!

Where did I go wrong?

Thank you


2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • This new formula doesn't work, what can I do?

    (Sector != null and text(Sector) == text("Pool")) or (Sector != null and Type != null and text(Sector) != text("Pool"))
    • Fred
    • Fred
    • 6 mths ago
    • Reported - view

    Ninox doesn’t use the double equal sign so things should start working if you remove one of them.

Like Follow
  • 6 mths agoLast active
  • 2Replies
  • 35Views
  • 2 Following