I am truly sorry to disappoint you, but at the moment, we don't have a working solution to accomplish this.
For example, we have options to create a data table linked to an existing data source via SQL Query;
which would achieve updating the entries in both the current wpDataTable we are editing, as well as the source table that the QUery pulls the data from;
but we don't have a way to delete it from the plugin as soon as it is entered;
but to keep the data in the source table.
-
The only feature we have that is the closest possible, is the Users See and Edit only their Own Data, which you can see here.
is a hook that gets triggered after the edit on the front page,
but what you need here is, unfortunately, beyond the scope of what our support can achieve at this time.
Perhaps the developers can work out a solution in the future, but i can't say an ETA on it, sadly.
-
If you need a solution for it now, maybe it can be done with a high level of custom work, but I am not sure, to be honest. Our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in the near future.
We can recommend reaching out to someone who does custom solutions, such as WP Kraken, but we can't advise on their pricing.
thank for checking I was able to achieve this by creating an "After Update Trigger" on the table at the database level. i am still working on using the same method for the delete, maybe i can use a stored procedure to do this. i appreciate your help.
I want to trigger a process after a user updates a record on a table in wpDatatables
1. i will like the record copied to another mysql table
2, Delete the record from the current table.
is there an easy way to do this? i thought i could integrate zapier. but I do not see any webhooks for wpdatatables. please help
Hi, Daniel
Sorry for the delay
I will have to check with our developers, i believe there might be a hook or two that might help you achieve this.
In the meantime, if you can check all the available hooks we have here, please.
Please note that using hooks requires certain level of programming skills and included support refers only to advice.
As soon as the devs advise me about this, i will come back with more information.
Thank you for your patience
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Hi, Daniel
The developers advised me.
I am truly sorry to disappoint you, but at the moment, we don't have a working solution to accomplish this.
For example, we have options to create a data table linked to an existing data source via SQL Query;
which would achieve updating the entries in both the current wpDataTable we are editing, as well as the source table that the QUery pulls the data from;
but we don't have a way to delete it from the plugin as soon as it is entered;
but to keep the data in the source table.
-
The only feature we have that is the closest possible, is the Users See and Edit only their Own Data, which you can see here.
wpdatatables_after_frontent_edit_row( $formdata, $rowId, $tableId )
is a hook that gets triggered after the edit on the front page,
but what you need here is, unfortunately, beyond the scope of what our support can achieve at this time.
Perhaps the developers can work out a solution in the future, but i can't say an ETA on it, sadly.
-
If you need a solution for it now, maybe it can be done with a high level of custom work, but I am not sure, to be honest.
Our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in the near future.
We can recommend reaching out to someone who does custom solutions, such as WP Kraken,
but we can't advise on their pricing.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
thank for checking I was able to achieve this by creating an "After Update Trigger" on the table at the database level. i am still working on using the same method for the delete, maybe i can use a stored procedure to do this. i appreciate your help.
Hi, Daniel
Sorry for the delay
-
No problem, i am happy to try and help as much as i can from my end;
with my limited knowledge of hooks
But the developers advised from their end, and of course, i am happy to see that you found the right solution.
For the "delete" , unfortunately, we don't have a working example that i could show you,
but i certainly hope that you will find a workaround to achieve this as well.
Our devs will do their best to add more documentation with examples in the future, for situations like this.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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