Hi,
I added a form variable to calculate the difference between the current date and a due date. I set the variable to recalculate on view, new and edit. (See attached.)
Is there any way to force the recalculation without having to view or edit the record? By the way, it did not recalculate when I just "viewed" the form.
Hi Patti,
Can you not used a Calculated Value instead?
Hope it helps,
Christophe
Hello Patti.
If You don't need it recalculated immediately, You can write a Nintex WF to do it when you save the item, or You can have a Site Nintex Wf doing it periodically.
Kind Regards,
Sérgio
I don't understand recalculate in view mode. There isn't a Save Button!
Hi,
I suppose I could, but I really didn't think of that as an option. Could I use a calculated value to find the difference between two dates and then plug it into a list column? Does the workflow have to be running? I suppose it would. My issue is really part of a bigger workflow design problem that I have not described in this thread. I've been looking for information on my design issue in the community and haven't found anything yet. So, I may post another thread regarding it.
Actually, I'd like it to recalculate daily.
Hi,
There are times when you might just want to "view properties" rather than "edit" the list item. I can tell you, it does not recalculate on "view" regardless of whether you have it set to recalculate on view.
So, You can write a site WF and schedule it to run daily.
Regards.
Hi Sergio. What action do I put into the workflow to cause the field to recalculate? I have version control set on the list (but not check in - check out). I really don't want to have to do a "fake" edit to cause the recalculate. Thanks for responding.
Hello Patti. To do what I'm saying I think You'll need the Countdown Column itself as a calculated field in the list settings.
Regards.