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
-
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 -
Is regex (regular expressions) matching supported in any way? Or, is wildcard matching supported? Thanks!
-
Hello, Regex are not supported.
But variables can be defined withlet 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 -
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. -
Hi,
you can insert a formula field:
substr('multiline field', 0, index('multiline field', "
"))
Click Enter between quotation marks
regards
Leo -
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?
-
In the field settings, you have the option to "display field only if".
Here you can define: choice = 1 -
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.
-
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
-
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
- 4533Views