Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
Is there a way to generate a table that, by default, shows the last month of available data, but allow people to filter this if they want to change the date range? Thank you. At the page I provided a link to above, you can see an example of what we are dealing with. I have hidden the table via CSS to just show the chart.
I found a solution that works for me. What I did was create a custom shortcode that uses PHP to calculate the right date range. The start date then gets fed to wpDataTables by returning do_shortcode[wpdatatable...] . In that shortcode I include the VAR1 placeholder, set to the start date I need to use. This then gets used in the SQL Query that collects the data. I don't care about the end date because my data are always past data so in the SQL I just need to filter for dates later than the start date. Ideally I'd have this start date show up in the filter form above the table but that's less important. But if you are collecting ideas for new features, it would be great if %VAR1% could be inserted as the default start date.