How to update field with conditional logic

  • enetknowhow
    Asked on February 1, 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!

    Page URL: https://form.jotform.me/60312108551443
  • BJoanna
    Replied on February 2, 2016 at 4: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.

    How to update field with conditional logic Image 1 Screenshot 40

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

    How to update field with conditional logic Image 2 Screenshot 51

    How to update field with conditional logic Image 3 Screenshot 62

    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