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.
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.