0

Make a function writable

Hi, sorry but I am not familiar with coding...

I need a function to give a result if TRUE and to leave blank (so that I can insert a different number each time) if FALSE.

Exaple:

IF the "client" field is YES, let me write each time the final price

ELSE (so if he is NOT a "client")  

 make 'price' * 1,22 (add VAT)

Thanx in advance!

3 replies

null
    • Peppe
    • 3 yrs ago
    • Reported - view

    better explanation: the filed "Numer" has to be written by me, the field "Formula" is self written dipending on the formula. Can I put something in the formula so that it can be both? Like with an IF function. IF xxxx then the field is "Number" else is "Formula".

    Thanx

    • Peppe
    • 3 yrs ago
    • Reported - view

    better explanation: the filed "Number" has to be written by me, the field "Formula" is self written dipending on the formula. Can I put something in the formula so that it can be both? Like with an IF function. IF xxxx then the field is "Number" else is "Formula".

    Thanx

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

    Supose you have a yes/no field checkbox 'client' and a numberfield 'price'. 
    The formula in the formula field could be:

    if client then price else price*1,22 end

    Steven.

Content aside

  • 3 yrs agoLast active
  • 3Replies
  • 1057Views