I have a date field in a database, and I want to change an other field when the date is equal to today's date.
I used an hook Before Query to trigger the event on every refresh of the database, so when the date will be on today, I'll update a field for example a boolean "EventIsPassed"
The problem is, I can't manage to get all the items of my base in the hook event, to select the value I need next...
I didn't find someone who had the same problem I have.
If someone knows what could help me, it would be really appreciated.
Thank you in advance.