If I have an auction taking place, and as such, a user sees a list of all the auctions taking place. How do I make my platform automatically change the field “status” of these jobs from ‘live’ to ‘complete’ once the deadline date has been reached?
I tried to do a workflow on one page which was when a condition was met, but it doesn’t seem to let me do a search which ends up with a list, whereas I need it to search the list and change any who’s deadline date matches or is less than the current date, and change it’s status. It also feels like I want this to just be happening in the database and not really tied to a specific page’s workflow?
I hope that makes sense? Any ideas would be greatly appreciated