AnsweredAssumed Answered

Can I stop a note form a recalculation when opening from Sent or Draft?

Question asked by dougbrowning on Jul 1, 2019
Latest reply on Aug 13, 2019 by dougbrowning

I have a simple time on my form that tells the user how long they have been going while adding repeats. 

Calc is if(${SpeciesList},round(int(now() - ${StartedForm}) div (1000*60),1),round(int(now() - ${StartedForm}) div (1000*60),1))  


If I remember right I do the If so that it recalcs on each repeat add.


The issue is it also recalcs as soon as someone opens the form back up from sent.  This causes the time to go really high.


Is there a way I can get it to calc each repeat but not when reopening from Sent or Draft?  If they add more data I get it but even just looking at the old one changes the value.  


Maybe my if is if(opened from sent or drafts?, keep old val, else calc new val).


thanks for any ideas.