That would be part of the 'filter' conditions in your trigger to make sure that when you're moving through these they move in the sequence you want. So in the case of your example, lets say someone enters all 3 dates - the logical sequence is that you don't want it to go to status 1 when it should be status 3 because that date is also filled out.
So in your trigger for status 1 let's say - you would add a condition that Date 2 and 3 must also be empty.
For status 2 - Date 3 must be empty.
This way - if someone edits all 3 dates - It will skip over changing the status to 1 and 2 because the condition of date 3 being empty isn't met.
Think of the logic similar to how you would a formula with a little more detail -
if Date 1 is filled in and date 2 / 3 are empty - let it be status 1
if Date 2 is filled in and date 3 is empty - let it be status 3
If date 3 is filled in, make it 3
Does that provide detail for what you're asking?
Chayce Duncan | Technical Lead
(720) 739-1406 |
chayceduncan@quandarycg.com Quandary Knowledge Base