As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
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?