0

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
    true
else
    if Tipologia == null and text(Settore) == "Piscine"  then
         true
        else
            if Tipologia != null and text(Settore) != "Piscine"  then
                true else false
    end
end

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

Mauro

2 replies

null
    • Garden Più
    • Mauro_Schiappelli
    • 2 yrs ago
    • Reported - view

    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
    • 2 yrs ago
    • Reported - view

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

Login to reply

Content aside

  • 2 yrs agoLast active
  • 2Replies
  • 51Views
  • 2 Following