
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
-
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. -
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