0

what is the language?

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

5 replies

null
    • Sakshi_Singh
    • 6 yrs ago
    • Reported - view

    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

    • frcrettenand
    • 6 yrs ago
    • Reported - view

    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?

    • Sakshi_Singh
    • 6 yrs ago
    • Reported - view

    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

    • frcrettenand
    • 6 yrs ago
    • Reported - view

    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

    • Support
    • 6 yrs ago
    • Reported - view

    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

Content aside

  • 6 yrs agoLast active
  • 5Replies
  • 2754Views