1. in the Predefined default filter values, can i set it to showing this week for example, meaning every time someone is loading the table it will auto filter to the current week, is that possible?
2. can i add another column, to show the date name (Sunday Monday etc) based on other date column?
1. Unfortunately, no. You wouldn't be able to use the %LAST_WEEK% placeholder in there, as it would be considered as an actual value. You would only be able to do that through an SQL query, with DATEDIFF function, but you'd need to create a new SQL query based table from your original table, and filter the data through the query. Also, your customers wouldn't be able to change that filter.
2. If I understood you correctly, you'd like the plugin to automatically calculate which day of the week it is based on the date? That cannot be achieved, unfortunately.
Hello, i have two questions
1. in the Predefined default filter values, can i set it to showing this week for example, meaning every time someone is loading the table it will auto filter to the current week, is that possible?
2. can i add another column, to show the date name (Sunday Monday etc) based on other date column?
Thanks!
Hello Yaron
1. Unfortunately, no. You wouldn't be able to use the %LAST_WEEK% placeholder in there, as it would be considered as an actual value. You would only be able to do that through an SQL query, with DATEDIFF function, but you'd need to create a new SQL query based table from your original table, and filter the data through the query. Also, your customers wouldn't be able to change that filter.
2. If I understood you correctly, you'd like the plugin to automatically calculate which day of the week it is based on the date? That cannot be achieved, unfortunately.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables