I have table rows to be displayed by wpDataTables of which only 1 is editable. In this one the user enters a score.
The other 2 read-only table entries along with the entered score combine to do a look up in a SQL table that returns a Rating value to be displayed in the 4th field. This rating is for display purposes only and is dependent on the score entered. It is in essence a 'calculated field' but based on a look up rather than a mathematical calculation.
eg:
Age Group Challenge Score Rating
Under 16 Freestyler 50 Silver
50 is entered and posted, and a sql lookup fills in Silver.
I have read through all the documentation and there is nothing like this functionality that I can see. I'm guessing a plugin would be required for this.
Can I have your thoughts on this and any suggestions about how to incorporate this functionality. I'm presuming you have some declared hooks that may be of assistance.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
Unfortunately that is not possible with built in features of plugin, that when you change entries in one column and then update or add new entries in second column.
You can take a look in our documentation about Front-end callbacks and also about Actions and Filters which are defined in wpDataTables plugin for customization's by developers.
As this requires a look up in the SQL database I don't think the Front End callbacks would be an option, although I suppose an AJAX call might be possible but I'm not well read up on that due to most of my development being at the server end.
I would have thought that this sort of feature would have crossed your mind for future inclusion perhaps as I've rarely worked on a project that did not require some fields being automatically filled in in a table in this way by means of a look up in another table.
Are you able to recommend which wpDataTables hooks I should be looking at to try and build this feature into the table myself? I'm supposing it needs to happen as soon ass that row in the table is updated.
Thank you for your suggestion.We carefully follow customers requirements and try to implement most of them if they appears in requests from time to time so we will add to our idea list and look into some possible solutions on plugin side for one of next versions.
You can try with filter wpdatatables_filter_formdata_before_save to change form data before save it in database. You can find it in file /wp-content/plugins/wpdatatables/controllers/wdt_ajax_actions.php around line 342. We have to update this filter in our documentation that is available.
I have table rows to be displayed by wpDataTables of which only 1 is editable. In this one the user enters a score.
The other 2 read-only table entries along with the entered score combine to do a look up in a SQL table that returns a Rating value to be displayed in the 4th field. This rating is for display purposes only and is dependent on the score entered. It is in essence a 'calculated field' but based on a look up rather than a mathematical calculation.
eg:
Age Group Challenge Score Rating
Under 16 Freestyler 50 Silver
50 is entered and posted, and a sql lookup fills in Silver.
I have read through all the documentation and there is nothing like this functionality that I can see. I'm guessing a plugin would be required for this.
Can I have your thoughts on this and any suggestions about how to incorporate this functionality. I'm presuming you have some declared hooks that may be of assistance.
Hi Alan,
Thank you for your purchase.
Sorry for late response.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
Unfortunately that is not possible with built in features of plugin, that when you change entries in one column and then update or add new entries in second column.
You can take a look in our documentation about Front-end callbacks and also about Actions and Filters which are defined in wpDataTables plugin for customization's by developers.
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
As this requires a look up in the SQL database I don't think the Front End callbacks would be an option, although I suppose an AJAX call might be possible but I'm not well read up on that due to most of my development being at the server end.
I would have thought that this sort of feature would have crossed your mind for future inclusion perhaps as I've rarely worked on a project that did not require some fields being automatically filled in in a table in this way by means of a look up in another table.
Are you able to recommend which wpDataTables hooks I should be looking at to try and build this feature into the table myself? I'm supposing it needs to happen as soon ass that row in the table is updated.
HI Alan,
Thank you for your suggestion.We carefully follow customers requirements and try to implement most of them if they appears in requests from time to time so we will add to our idea list and look into some possible solutions on plugin side for one of next versions.
You can try with filter wpdatatables_filter_formdata_before_save to change form data before save it in database. You can find it in file /wp-content/plugins/wpdatatables/controllers/wdt_ajax_actions.php around line 342. We have to update this filter in our documentation that is available.
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