Capture data from number field

  • Resolved mehar1

    (@mehar1)


    6 years, 5 months ago

    Hello sir,

    I need help. I made 2 fields , 1 is for number field and 2nd for check box…
    I made this formula fieldname1*1.25$ + fieldname3 .

    my fielname3 is for checkbox and i want to capture the value for this checkbox field from number field.. So when anyone select the number field as 4 number then the value for check box should be automatically 4 , if anyone select the number field 5 then value of check box should be automatically change to 5 .

    Please help me ASAP

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

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author codepeople

    (@codepeople)

    6 years, 5 months ago

    Hello @mehar1

    I’ve visited your web page, but the checkbox field has only one choice. So, I don’t understand what do you mean with:

    …So when anyone select the number field as 4 number then the value for check box should be automatically 4 , if anyone select the number field 5 then value of check box should be automatically change to 5….

    Best regards.

    Thread Starter mehar1

    (@mehar1)

    6 years, 5 months ago

    Please see this screenshot , This will help you to understand what i’m looking for.

    https://drive.google.com/file/d/16yev8Q_X-7ZzOvk40dgvk726SDOGx4aj/view?usp=sharing

    Thread Starter mehar1

    (@mehar1)

    6 years, 5 months ago

    Hello i found the solution , I just changed the formula to this fieldname2*1.25 + (fieldname3*fieldname2) , It’s to my requirements ,

    Thank you!

    Plugin Author codepeople

    (@codepeople)

    6 years, 5 months ago

    Hello @mehar1

    Assuming the fieldname1 is a number field for entering a time in minutes. You have two alternatives:

    * inserting an unique checkbox field with 4 choices (the fieldname3), whose values are the numbers (numbers only): 1.25, 1, 0.25, 0.5 respectively, and the texts of choices the corresponding texts in your image.

    The equation would be simply:

    
PREC(fieldname1*fieldname2, 2)

    * Inserting separated checkbox fields: fieldname2, fieldname3, fieldname4, and fieldname5

    The equation would be:

    
PREC(fieldname1*(fieldname2+fieldname3+fieldname4+fieldname5), 2)

    Best regards.

    Thread Starter mehar1

    (@mehar1)

    6 years, 5 months ago

    thank you soo much!

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Capture data from number field’ is closed to new replies.