Logical Functions

Do your calculations support complex logical functions i.e.

If 1 then a
else if 2 then b
else if 3 then c
else d

10 replies

    • Alexander_Koenig
    • 8 yrs ago
    • Reported - view
    Hello, cascaded if then functions are supported.

    If field_name = 1 then a
    else if field_name = 2 then b
    else void

    In this example field_name could be a choice field.

    Best regards, Alex
    • GospelTheGrey
    • 7 yrs ago
    • Reported - view
    Is regex (regular expressions) matching supported in any way? Or, is wildcard matching supported? Thanks!
    • Alexander_Koenig
    • 7 yrs ago
    • Reported - view
    Hello, Regex are not supported.
    But variables can be defined with let a := data_field
    Another thing is to use substr() and index() to extract parts of text. You find more info in the function and language reference. Also if there are questions drop a line to support@ninoxdb.de
    Kind regards, Alex
    • Dr_Faustroll
    • 6 yrs ago
    • Reported - view
    Is there a way to extract the first line of a text from a multiline field?
    Can I read a field until I encounter a carriage return and put the contents into a container to store in another field?
    For instance, I have a field called Body that contains a poem.
    I want to extract the first line and put it in a field called First Line as a check against having the same poem in the DB under two different titles.
    • Leonid_Semik
    • 6 yrs ago
    • Reported - view
    you can insert a formula field:

    substr('multiline field', 0, index('multiline field', "

    Click Enter between quotation marks

    • jlightheart
    • 6 yrs ago
    • Reported - view
    I’d like to use the display field only function by pulling out a response from a drop-down field. E.g. If “Purchase” is selected from the multiple choice field, I’d like another field to pop up. How do I do that?
    • Alexander_Koenig
    • 6 yrs ago
    • Reported - view
    In the field settings, you have the option to "display field only if".
    Here you can define: choice = 1
    • kustra
    • 6 yrs ago
    • Reported - view

    I have a similar query to the above, but with a multiple choice field: I want a field to pop up if a multiple choice field is or INCLUDES a certain choice.  It is a form for performer types.  In the first field: A multiple choice of performer categories such as actor, conductor, instrumentalist etc. A person could be one or many of those.   The second, conditional field would be 'Instrumentalist Type', appearing only if 'instrumentalist' is selected or is among multiple selections in the first field.  Using = works only if the number for 'instrumentalist' (in this case, 3) is chosen on its own.  Thanks for your help.

    • Angel
    • 4 yrs ago
    • Reported - view

    Buenos días no prodigas decir que paso es el que me falta gracias En un campo llamado Megaohmios tengo que meter un valor numérico que me devuelva un testo según el valor Si el valor está entre 0 o16 mendiga Malo si está entre 16 o50 regular y si está entre 50 o100 bueno le tengo aplicada esta fórmula pero no consigo que me de las tres respuesta según el valor gracias. If Megaohmio <16 then “malo”else “regular”end

    • Customer Service Ninox
    • Maria_pasini
    • 3 yrs ago
    • Reported - view

    Hola Angel,
    Puedes usar el codigo abajo en un campo de Formula:
    if Megaohmio <16 then "Malo"
    else if Megaohmio >=16 and Megaohmio <50 then "Regular" 
    else "Bueno"

Content aside

  • 3 yrs agoLast active
  • 10Replies
  • 4524Views