1. I have two columns in a table that I need to be editable.
2. The source table/data is DIFFERENT for each column.
Example:
Column1 => table1.column1
Column2 => table2.column2
It's easy enough to make one column editable. Making the second one editable is the challenge.
-----------------
What is the best way to solve this problem?
--------------------
I have researched the available actions and filters:
wpdatatables_after_frontent_edit_row: this happens after a save, but i would never get there because of the error that would be thrown on the save itself.
The filters i looked at were: wpdatatables_query_before_save_frontend, wpdatatables_filter_formdata_before_save. The latter one i could try to use, but i believe the intent is to modify data prior to a save - NOT perform additional saves inside this function. And again, I would still have an issue with the save action failing.
It almost seems like what i want to do is conditionally override the save table action (wp_ajax_wdt_save_table_frontend) in the plugin - but this is complicated, and very close to hacking the core source code. I'd like to avoid that.
I am also looking into Gravity Forms integration. But I'm unfamiliar with GravityForms, and not sure it can do what i want.
Hopefully, I was able to explain the issue. Any help would be greatly appreciated. Thanks!
Hello!
The problem I am trying to solve:
1. I have two columns in a table that I need to be editable.
2. The source table/data is DIFFERENT for each column.
Example:
Column1 => table1.column1
Column2 => table2.column2
It's easy enough to make one column editable. Making the second one editable is the challenge.
-----------------
What is the best way to solve this problem?
--------------------
Hopefully, I was able to explain the issue. Any help would be greatly appreciated. Thanks!
Hi Paul,
Thank you for your purchase.
If I understand you right you can use Foreign keys and check is that what you looking for. You can read more about this on this links in our docs.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables