Checkboxes help

  • Resolved metesey

    (@metesey)


    3 months, 2 weeks ago

    I made a form with 14 options in the fieldname17 field of Checkboxes. The options in this field can be selected multiple times.

    I wanted to write a formula that will give a result of 1 when the “paper holder will be attached” item with a value of 8 is checked. I wanted to write a formula that will give a result of 0 when it is not checked. The formulas I tried for this.

    first formula: if(fieldname17==8,1,0)

    second formula: if(in(8,fieldname17|r),1,0)

    Both formulas work only when the value 8 is selected. However, if multiple other values other than 8 are selected, this time it returns the result as 0. Is there a solution for this? When a desired value is checked in the checkboxes, it should give a value of 1 when checked and 0 when unchecked and not be affected by other options.

    Thank you in advance for your help.

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

    (@codepeople)

    Hello @metesey

    Thank you very much for using our plugin. Javascript is a case-sensitive language, you should not confuse the “IF” plugin operation with the “if” conditional statement. Please edit the equation as follows:

    IF(IN(8,fieldname17|r),1,0)

    Best regards.

    Thread Starter metesey

    (@metesey)

    Thanks, problem solved.

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