Calculated field text string

  • Resolved PB

    (@ohtusabes)


    2 weeks, 3 days ago

    Hi @codepeople

    I want to obtain a calculated field showing 1 or more of 4 posible options:

    1. Ventilación con bolsa/máscara dificultosa
    2. Ventilación con máscara laríngea dificultosa
    3. Intubación traqueal dificultosa
    4. Crico dificultosa

    Some fields are associated with one, some with more than one, and some with all. How could I do it? It shouldn′t be repeated. I mean: if two fields have the same options, it should show once.

    Thanks in advance

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author CodePeople2

    (@codepeople2)

    Hello @ohtusabes

    Thank you very much for using our plugin. To create dependencies related with multiple fields you can use a calculated field as an auxiliary. However, the implementation depends on your project.

    For example, assuming have three fields, fieldname1, fieldname2, and fieldname3, and you want to activate the fieldname3 field only if the values of both fields fieldname1 and fieldname2 are “Si” and ignore it otherwise.

    In this hypothetical case, you can insert a calculated field in the form (you can hide it by ticking a checkbox in its settings) and enter the equation:


    (function(){
    if(AND(fieldname1=='Si', fieldname2=='Si')) {
       ACTIVATEFIELD(fieldname3|n);
    } else {
       IGNOREFIELD(fieldname3|n);
    }
    })()

    Note that fieldname3 includes the |n modifier. It tells the plugin you are referring to the field’s name directly instead of its value.

    Best regards.

    Thread Starter PB

    (@ohtusabes)

    Hi @codepeople2

    Thank you for the support.

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.