Forum Discussion
ChrisChris
9 years agoQrew Assistant Captain
Andreonna,
Are you certain the two dates will always match? Is it not possible that [Completion Date] may occur sooner than or later than [Scheduled Date] ?
- AndreonnaGarret9 years agoQrew Assistant CaptainThe field needs to be able to be edited in the case that they are not the same. 95% of the time they will be the same date.
- ChrisChris9 years agoQrew Assistant Captain
You would auto populate the [Completion Date] field much like Matthew said, except when [Status] = "Complete", change [Completion Date] to the current date in the form rule. You will still be able to edit the [Completion Date] field manually, the form rule allows you to populate the date field automatically upon a certain condition.
In the form rule, you may want to check the box that says, "change occurs when condition changes from false to true". This will keep the [Complete Date] from changing to the current date every time the record is edited subsequent to its completion.
- AndreonnaGarret9 years agoQrew Assistant CaptainChris, Can you please look at my comment on Matthews post as well regarding the URL button. This seems to be causing an issue.
Thanks!