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!
Q.1 : is it possible to create a "Current_Date" column that always filled with "Current Date" value?
Q2: i tested formula column to see if it could calculate difference between two "Date" data columns and the result is negative. Please reconfirm.
Q3: i would like to add a column of "Days Left" of my "Appointment Date" column, how could this be done by wpdatatables?
Hi Freddie
Thank you for reaching out to us.
1. You can add a predefined value to this column when it is being edited so it would enter the current date for you, but it cannot automatically add or modify existing values.
2. That is correct, formula columns cannot be used on string type columns.
3. This can only be achieved using MySQL query-based tables. If you're not that good with MySQL, you can try using our Query Constructor, but please note that this constructor is just a helper - it's not an ultimate query generator.
It constructs a suggestion of a query, that you often need to modify to get the data you need. Included support for the plugin doesn't cover writing custom queries, so we wouldn't be able to help you with that.