# How to update field with conditional logic

• 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!

• 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.