I would like to convert the table shown on the URL above into a MySQL database that can be updated and regenterated on the fly. In addition I would like to be able to delete any records that are more then 6 weeks old. The DB manager should have a secure way to add records to the table. The users should be able to search or select within a date range. Is this possible using your Plugin?
You can import the data in your database, if it doesn't exist already.
Then you can create an SQL Query based wpDataTable to pull the data and display it with our plugin. The SQL query based tables can be editable, and the table is dynamic - if you change something in the database, it will be shown in wpDataTable on page refresh, and vice-versa.
Deleting the entries after a certain period of time expires, though, would have to be done manually - the plugin cannot delete them automatically. We also have an option to select which WP user roles will be able to edit the table.
I would like to convert the table shown on the URL above into a MySQL database that can be updated and regenterated on the fly. In addition I would like to be able to delete any records that are more then 6 weeks old. The DB manager should have a secure way to add records to the table. The users should be able to search or select within a date range. Is this possible using your Plugin?
Hello Rick.
Thank you for your interest in our plugin.
You can import the data in your database, if it doesn't exist already.
Then you can create an SQL Query based wpDataTable to pull the data and display it with our plugin. The SQL query based tables can be editable, and the table is dynamic - if you change something in the database, it will be shown in wpDataTable on page refresh, and vice-versa.
Deleting the entries after a certain period of time expires, though, would have to be done manually - the plugin cannot delete them automatically. We also have an option to select which WP user roles will be able to edit the table.
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