Null not working | Community
Skip to main content
ReluctantProgrammer
New Participant
August 17, 2021
Solved

Null not working

  • August 17, 2021
  • 1 reply
  • 958 views

This formula worked but  I'm trying to leave the field (headwaterExistingMain10) blank unless there is an amount in one of the fields in the formula using this..

 

if (headFtExistingMain10.rawValue==null)
this.rawValue==null
else this.rawValue = (Math.round(hweFtMain10.rawValue*10)/10)+(Math.round(headFtExistingMain10.rawValue*10)/10)

 

....When I Preview the form I get this error...

"Illegal value: cannot assign 'True' to xfa[0].form[0].form1[0]0.page1[0].table1[0].row5[0]0.headwaterExistingMain10[0].#value[0].#float[0]."

 

The kicker is once I click on the 'ok' button in the error box the formula works.  How can I get it to not kick off the error message?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Pulkit_Jain_

@reluctantprogrammer 

Seems like there is a conflict while assigning the value to the field "headFtExistingMain10" as the value expected is float but some other js within the form is assigning a boolean value to this field

"Illegal value: cannot assign 'True' to xfa[0].form[0].form1[0]0.page1[0].table1[0].row5[0]0.headwaterExistingMain10[0].#value[0].#float[0]."

 

Although this pop-up may be benign, but you may have to cross check the other js in this form for the value of this particular field at the time of rendering of the form.

1 reply

Pulkit_Jain_
Pulkit_Jain_Accepted solution
Employee
August 17, 2021

@reluctantprogrammer 

Seems like there is a conflict while assigning the value to the field "headFtExistingMain10" as the value expected is float but some other js within the form is assigning a boolean value to this field

"Illegal value: cannot assign 'True' to xfa[0].form[0].form1[0]0.page1[0].table1[0].row5[0]0.headwaterExistingMain10[0].#value[0].#float[0]."

 

Although this pop-up may be benign, but you may have to cross check the other js in this form for the value of this particular field at the time of rendering of the form.