Automatic adjustment of status (as in the Starter Solution "projects")
I have a database that is based on the standard template "projects". I built everything from the beginning.
I would like to see that records are automatically adjusted by date.
Today I created a task and, like in the template "projects". With a start date (today) and end date (tomorrow). My status then indicates "Expires." If it's a day later than it should be automatically changed to "Expired", because the date has passed.
If I reconfigure a record manually, the status will be updated. therefore provide scripts to run.
Again, I have built the database itself and some provide scripts and references copied and adjusted in terms of names.
(I come from the Netherlands, this description translated with Google translate)