I’ve inherited a wix site, and my client doesn’t want to use bands in town any more for his gigs - (this is not up for discussion!)… so I’ve created a simple database and a repeater on the site, which works OK - basic functionality of listing gig dates and locations, etc.
There is one issue - I want to only display dates in the future by default, and I’m not sure of the best way to approach this. The filter for the dataset (under Manage Dataset in the editor) doesn’t offer the ability to filter by date; At the moment I’ve created a boolean column in the database that I’m setting manually, and then any ‘past_gig’ entries don’t get displayed.
I’d like to automate this process; usually I’d use a cron job or similar, and I’m a Python programmer, but not a JS one. I’ve found the following hook before a Get - I’m wondering if this is the right place to do this - i.e. check the entries’ datetime and if it’s in the past then mark the past_gig column, but I’m not sure of the approach to this; any help or pointers in the right direction would be appreciated.
export function MJEvents_beforeGet(itemId, context) {
//TODO: write your code here…
}