I am preparing a field worker / QField project an would like to visualize green spaces based on the days that have elapsed since the last field worker has visited that site.
I am testing with a very basic data set with a field beeing automatically updated with the current date by
now() on insert and update. The elapsed days since the last visit are beeing calculated via
Now I would like to update the days elapsed since the last visit on a daily basis or on every QGIS/QField startup. Do you have any idea, how to trigger the above calculation automatically when starting the QGIS project?