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.
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).
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.
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.
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..
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.