We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
I need to be able to create an audit trail of who did the last update on a row in a MySql table.
Given MySql table with cols
id INT
Data TEXT
lastUserUpdt DATETIME
lastUserId INT
When a row from this table is inserted, or updated, can I configure wpDataTables to auto-update the last two fields with today's datetime, and userid? And can I hide the last two fields so they are not enterable by the user?
Hi Daniel,
Thank you for your inquire.
Best way to do this whould be with hooks. You will need to write little function which will be triggered whenever row is edited in frontend and write desirable data in fields which are not included in table.
List of all hooks can be found in our - Documentation and for this case I think that wpdatatables_after_frontent_edit_row would be most appropriate. This action fires after every frontend editing.
For columns that you need to prevent users for changing simply choose none for editor in the column settings
For testing purpose we have sandbox website where you can see and test all plugin functionalities
sandbox.wpdatatables.com
username: demo
password: demo
Can someone please explain this further? Where exactly can I call this hook?