Evaluating Calculations Fields
I am creating a Daily Task tracking system. Tasks are viewed on the individual profile of each employee via portal. Each task has a "Complete" Field that needs to be set from Complete to "Not Done" each day (or sometimes every other day, depending on the frequency). I have written a calculation into Complete that uses Get(CurrentDate) and compares it to the Last Day Completed field for each task. When This evaluates to false, the field is set to not done.
The problem I'm experiencing is that the Complete field only evaluates when corresponding data from one of the other fields is changed. I need the fields to update automatically to not done when the solution is opened, which does not happen.
I can't set the fields to "unstored" or they will no longer appear in the portal in which they are regularly viewed.
What is the best way to get the fields to recalculate?