How to update field with conditional logic

  • Profile Image
    enetknowhow
    Asked on February 01, 2016 at 10:49 PM

    How I can use CALCULATE FIELD for this aktion.

    I have two Filds:

    a) Breite

    b) GK1

     

    Want selekt:

    if "Breite" < 100 and "Breite" >50 than

    set

    "GK2" = 1

     

    ---------------------------------

    anohter question:

     

    How can use calculation table?

    sample calculation table

    x;1,2,3,4

    a;w1,w2,w3

    b;s1,s2,s3

    c;r1,r2,r3

    d;y1,y2,y3

     

    I have 3 filds


    a) height

    b) width

    c) value1

     

    so 

    if "height" =2 and "width" =b than to fill

    "value1" =s2 (ist the position calculation table)

     

    Thank!

  • Profile Image
    BJoanna
    Answered on February 02, 2016 at 04:03 AM

    If I understood you correctly you want to pass value to GK1 field if value that is entered inside of Breite field is greater than 50 and less than 100. 

    First you need to change type of Breite  field to number field, because greater and less conditional options are only available for number and spinner field.

    Then you need to use conditional logic UPDATE/CALCULATE FIELD option and set your condition like this. 

    Here is my demo form: https://form.jotform.com/60321927041951

    Feel free to clone it.

    If you want to perform calculation inside of your form this guide can help you:

    http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form 

    I have moved your other question to separate thread and we will provide you an answer there shortly: http://www.jotform.com/answers/762250