cancel
Showing results for 
Search instead for 
Did you mean: 
bsieloff
Nintex Newbie

Connected calculated fields do not save to the SharePoint list

Hello,

I have a few calculated fields and I connected them to a list column.  I saved / published the form and ran a test.  The form ran correctly but the calculated fields did not save their values to the associated connected column.  When I go back into the form to view it, the calculated fields are empty.

any ideas?

Tags (1)
Reply
14 Replies
abdullahfahmi91
Nintex Newbie

Re: Connected calculated fields do not save to the SharePoint list

Do you really need to pass the value from Calculated Value field to EligibleTotal100?

If you just enable Recalculate Formula in View Mode to Yes, the Calculated Value field will show the value in View mode.

The connected to in Calculated Value actually refers to the input for Calculated Value.

You can see this if you manually insert value for EligibleTotal100 to something else.

In View Mode, you can see Calculated Value is taking that input instead of the formula (if you didn't enable Recalculate Formula in View Mode).

0 Kudos
Reply
bsieloff
Nintex Newbie

Re: Connected calculated fields do not save to the SharePoint list

Hi Abdullah,

Clicking the checkbox to show the calculations on view fixed my viewing issue.  Thank you.

It does not seem that I need to connect my SharePoint list column data "EligibleTotal100" to the calculated value as the value will be derived from the other inputs on the form.  What I do need is to be able to save the calculated value back to the SharePoint list field "EligibleTotal100".  Perhaps there is a way to calculate the value directly on the form using the list column but I did not see a way to do any calculations for a list column.

0 Kudos
Reply
greenawayr
Nintex Newbie

Re: Connected calculated fields do not save to the SharePoint list

This should work anyway. What is the data type of your column?

0 Kudos
Reply
bsieloff
Nintex Newbie

Re: Connected calculated fields do not save to the SharePoint list

Currency.  Could that be the issue?  currency on the sharepoint list column and currency on the calculated value

0 Kudos
Reply
abdullahfahmi91
Nintex Newbie

Re: Connected calculated fields do not save to the SharePoint list

Probably you can go to Save button control settings.

In Advanced tab > Connected to, choose EligibleTotal100.

Use same formula in Calculated Value in Value returned.

Set Data type returned as Currency.

Please let me know your result.

0 Kudos
Reply
bsieloff
Nintex Newbie

Re: Connected calculated fields do not save to the SharePoint list

Hi Abdullah, 

I gave that a try but it did not work.

0 Kudos
Reply
TomaszPoszytek
Nintex Newbie

Re: Connected calculated fields do not save to the SharePoint list

Is the field set as disabled? I am facing issues when fields are disabled or.hidden as data from them is not being saved...

I am, instead of disabling, adding a CSS, transparent overlay to cover the field..

Regards,

Tomasz

Reply
TomaszPoszytek
Nintex Newbie

Re: Connected calculated fields do not save to the SharePoint list

‌ did you manage to work out the solution? 

Regards,

Tomasz

0 Kudos
Reply
Highlighted
bsieloff
Nintex Newbie

Re: Connected calculated fields do not save to the SharePoint list

Hi Tomasz,

I did not get forms to save to the list the way I wanted to.  I ended up creating calculated fields in the list and using the input from the other fields to do the calculations in the SharePoint list.  I have a lot of forms to do.. so I'm sure to find the correct answer soon.  I'll post it here when I get it resolved.

0 Kudos
Reply