Saving Calculated Control results to SharePoint columns?

On many of my forms, Calculated Controls are used to display informative messages to the end user. For example, once a form has been approved, I might display the following snippet:




The Calculated Control formula for the "Approved by ..." message is as follows:


Approval Outcome + " by <strong>" + userProfileLookup(ApprovedBy, "PreferredName") + "</strong> (" + userProfileLookup(ApprovedBy, "WorkEmail") + ") on " + formatDate(ApprovedOn, "dd/MM/yyyy hh:mm tt")


Every time this form opens, the Calculated Control has to... well... calculate, and this involves two userProfileLookup() calls, and a formatDate() call. Once this form has been approved and the Calculated Control is evaluated for the first time, it would be nice to not have it re-calculate every time the form is subsequently opened.


Which brings me to my question: is there a better way?


By "better" I mean in terms of performance by eliminating the need for repeated calculations. Can the output of this Calculated Control be saved to a SharePoint column (single or multiple lines of rich text) on the form? Or should this kind of calculation, which is essentially building a string, be moved to the workflow?


If you've had any experiences with this kind of issue, or have a suggestion, then I'd like to hear them!

0 Kudos
1 Reply
Nintex How-To Center Expert
Nintex How-To Center Expert

Re: Saving Calculated Control results to SharePoint columns?


The calculated Value control has three options to control re-calculation.
Configure the control to only recalculate for new mode so that subsequent edits do not case a re-calculation.
0 Kudos