what is the language?

F

what is the language used for formulas with Ninox? I want to learn this language to improve myself

Ninox Profile

Hi,

Ninox is a custom user-friendly english-like language to help users digitize their business processes. 

You can learn the language and syntax from here, https://ninoxdb.de/en/manual/calculations/mathematical-functions

Regards,
Sakshi- Ninox

F

Hi, thank you for your reply. after looking in the manual, I did not find how to make formulas with multiple choices. How to select the answer choice in a formula?

 

42BFB596-650F-4B4F-8D9C-94739CBF18F3

Ninox Profile

Hi,

Given below,

chosen(field) - Get all chosen values from a multiple choice field
chosen('multi choice field') => ["Option 1", "Option 2"]


 

Find it here,

https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language

 

Regrads,
Sakshi- Ninox

F

Hi,

Thank you for your response but i didn't understand everything.

i have a case multi choice: "1er essai"

i have 3 options: "en cours", "oui", "non"

what is the formula for choice "oui"?

and more complicated, what is the formula for calculate: "% of oui" of "oui+non"

 

regards,

Francois

Ninox Profile

Hi Francois, 

to get the "oui" from your multiple choice field you can use the formula:

 

chosen('multiple choice field') like "oui"

 

if it is only a choice field you do not need the function chosen() 

it would be enough like this:

 

'choice field' = "oui"

 

The question about "% of oui" of "oui+non" I have answered you in your other thread for that question: 

https://ninoxdb.de/de/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/calculate-a-percentage-with-a-multiple-choice-formula-5bb20c80ee4fde095b3085a0?post=5bbb6fafbf9a0a019d58f60e&page=1

Best, Jörg

Reply