This content has been marked as final. Show 4 replies
Are all the workflow steps to be created at the time that the new product is entered?
Or is a new step only added after the last one is completed?
Thanks, Scott. The workflow steps are to be created at the time that the new product is entered (or soon thereafter).
I recommend to keep the information in different records forming a tree of process steps. But what you can't do is simply a calc field startTime = max( preSteps::endTime ) where everything is unstored. FileMaker will not find the optimized order to calculate through the whole tree and recalculate already calculated results over and over.
You have to 'guide' FileMaker to find the correct order by script. The script sets startTimes only for nodes where all pre::startTime's are well known.
Thank you, Jen. I will give this a try.