Hello Emiel

Thank you for your interest in our plugin.

When you create a manual table, it is saved in the database in format: wp_wpdatatable_#, where "#" represents the table's ID in the database. You can see this ID when you go to the "Editing" tab above the table, and enable editing.

Then, you can do what you want with it through SQL Query based tables. You can pull the data into new wpDataTables like:

SELECT * FROM wp_wpdatatable_3

Or like:

SELECT column1, column2, column5 from wp_wpdatatable_3
WHERE columnID = %CURRENT_USER_ID%

if you wish to show the data of the table associated only to the currently logged in user.

Following the same logic, you can create 5 different tables for 5 days of the week:

SELECT column1, column3, column5 FROM wp_wpdatatable_3
WHERE column1 = 'Monday'

Unfortunately, using curdate() or anything similar goes for the date, not the day.