Eanox
Canvas Initiate

Nintex Forms Calculated Value not working

Jump to solution

Hello all. I can't figure out why calculated value on one list(works in other lists) is not working. The fields in sharepoint are set as single line of text. I'm not getting results even in the simplest form i.e. column1 * column2. Any ideas?

0 Kudos
Reply
22 Replies
SimonMuntz
Nintex Employee
Nintex Employee

Re: Nintex Forms Calculated Value not working

Jump to solution
Hi,

Is there anything special about this list like the way it was created for instance? Do you see any errors in the browser console when opening the form in a browser?
Do you see any errors if you do a fiddler trace when opening the form?
If this a new form or was it imported from somewhere else?
0 Kudos
Reply
Eanox
Canvas Initiate

Re: Nintex Forms Calculated Value not working

Jump to solution

thanks Simon.
I don't see any error. I created another list from scratch have problem with calculated value on this one also. i have four calculated value fields in one form and when one works the other doesn't. Also shows #value on the fields that don't work.

0 Kudos
Reply
SimonMuntz
Nintex Employee
Nintex Employee

Re: Nintex Forms Calculated Value not working

Jump to solution
Are you able to provide an export of your test form?
0 Kudos
Reply
Eanox
Canvas Initiate

Re: Nintex Forms Calculated Value not working

Jump to solution

here. thanks.

0 Kudos
Reply
SimonMuntz
Nintex Employee
Nintex Employee

Re: Nintex Forms Calculated Value not working

Jump to solution

Hi,

You posted in the SharePoint section but the form provided was an Nintex for O365 form so I have moved the post to the correct category.

The formula in the Proposed Spread Toatal has 1 to many closing brackets ')'

Fix this and see if it resolves your issue.

 

Not sure why you were not seeing any errors in the browser console. I imported and published the form, opened it and this error appeared and told me what the issue was.

Console.png

View solution in original post

0 Kudos
Reply
Eanox
Canvas Initiate

Re: Nintex Forms Calculated Value not working

Jump to solution

hi Simon,

I have issues even with a simple column1*column2 where when one works the other doesn't even appear. Also what can i do about the synthax error

0 Kudos
Reply
CarmScaffidi
Design Dabbler

Re: Nintex Forms Calculated Value not working

Jump to solution

Did you try what Simon suggested?

"The formula in the Proposed Spread Toatal has 1 to many closing brackets ')'"

Reply
Eanox
Canvas Initiate

Re: Nintex Forms Calculated Value not working

Jump to solution

Calculated value works now. thanks a mil

0 Kudos
Reply
Eanox
Canvas Initiate

Re: Nintex Forms Calculated Value not working

Jump to solution

i finished the form and published it and calculated value stops working. any ideas? TIA

0 Kudos
Reply