How do I auto-enter a date field incremented by a week on new record creation
I would like to set an auto entry script that will put a date in the date field that is one week later than the date in the last record.
I would appreciate any help in creating this. The calculation below will not work because it does not know to draw from the latest date extant in the date field FLR_Date;
Date ( Month ( FLR_Date ) ; Day ( FLR_Date ) + 7 ; Year ( FLR_Date ) )
if your last record is ALWAYS present into the current found set AND the found set is sorted ascendent by that date, this calculation is what you need:
GetNthRecord ( FLR_Date ; Get ( RecordNumber) - 1 ) + 7
If the above conditions aren't always verified, you'll need a self-relationship and a different calculation.