Hello,
I need help making a status field update automatically when the day changes.
Example as follow
The Goal: I have an OGSP Expiry Date field and a calculated OGSP Status field that shows “Expired” or “Active”.
The Current Problem (Not Real-Time): I use a Linkage Rule (Workflow) to set the status based on comparing the [Expiry Date] to [Today].
- If the date was set to yesterday, the rule correctly sets the status to “Expired”.
- When midnight passes, the status should change to “Active” the next morning.
- The status does not change automatically. It only updates when I go in and manually edit and save the record.
The Technical Reason: I understand that Linkage Rules are only triggered by user actions (like saving or creating a record), not by the passage of time.
The Question: What is the recommended NocoBase method for achieving this real-time, time-based update?
Anyhow to set up a Daily Scheduled Task/Cron Job that runs once per day to check all records and force the status update?
Thank you for your help!
