New error - java.lang.Long

New error - java.lang.Long

 Hello,

This refers to my application :  https://creator.zoho.com/stressrecess/therapists/#Form:Contractor_Invoice

When I open existing records and try to update them, I get an "invalid entry error" with a link to click to "view error details" which then says the problem is "java.lang.Long".    The one forum discussion on this topic does not contain an answer.  

My app is shared to zoho support:  


I have some additional information:

1)  I am not sure exactly when the problem began, because no one has edited records today until now.

2)  a little while before I noticed the problem, I created and then deleted a field that got values from another field.  This may be the cause, because it looks like class java.lang.long is used when comparing two values.

- I already had a formula field called MT_WholeNameFormula, which was supposed to combine the text of MT_NameFirst and MT_NameLast.  When I realized it did not show in my View was when I created a new field...

- The field I created was called MT_NameFullVariable (Full Name).  I created it as a hidden text field.  In script builder, I put a script on MT_NameLast (on User Input) that set input.MT_NameFullVariable = input.MT_WholeNameFormula;. 

- I was still unable to make the name come up in MT_NameFullVariable, so I decided to do this a different way, and I deleted the script and the field.

- I tried to recreate the field and the script when I got the java error, but that did not fix the problem.

As I said, this was right before the error started to happen, but I cannot be sure that the deletion is related.

3)  I don't why this is related, but on many of my records, the "Terms Agreement" checkbox field (Invoice_TermsAgreementBox) was no longer checked, even though it is a required field so it definitely was checked when the user added the record, None of the other required fields or other fields were affected, just this one.  I filled out a form myself and I definitely checked the box, but it was unchecked when I opened it.

UPDATE:  10:04 PM EST - All these problems mysteriously fixed itself, when a fellow user logged out.  He had signed in on an embedded copy of the view for this invoice form on our website. he had the same log in and password as I.  When I am logged in on zoho, we both get the error, if one of us logs out, the other person is fine.    I did change this today it so that the user has to log in with a zoho password in the embedded form..  Having everyone log out is a workaround for now so we can edit records, but obviously we still need a fix.

Devorah