August 31, 200619 yr I have a calculation that tracks changes made to certain fields. I want to have a delay built into the calc that allows the person creating the record 5 minutes to complete the first version of the record. The calc see's any edit to these fields as changes, even the very first entry. So I would like to have an If statement that says: If ("Time In" + 5 minutes > Current Time; execute calc; otherwise leave the revision list blank). Any ideas?
September 1, 200619 yr Let's assume your Revision History field is called RevHistory. You also need a field CreationTimeStamp that autoenters the creation timestamp, and ModificationTimestamp that autoenters the modification timestamp. Then you can set up the RevHistory field as an autoenter -always evaluate- using a case function like so: Case(ModificationTimestamp - CreationTimestamp > 300; <>; RevHistory) Whenever a change is made to the record, it will execute, but if the modification timestamp is less than 300 seconds (5 minutes) after the record was created, then the result is just the current value of the RevHistory field, which is what you want.
Create an account or sign in to comment