I am new to wpdatatables and I have a couple of questions about the table editing capabilities:
1) I have managed to find a way to hide the ADD / DELETE options from a table however I am looking for a way to edit the modal box to hide the "Apply and Add New" Button. Can someone tell me how this can be achieved?
2) I would like to show the ID of the row being edited in the modal box but I do not want it to be editable. Is there a way to achieve this?
3) I have changed the display names of columns but when the update happens to that row i get an error telling me 'Unknown Column in field list" is there a way around this?
if the table have id table_1. You have to check throw Inspect element which id is generated. To hide this buttons you can add this CSS on Custom CSS field on wpDataTables settings page or directly on the page between <style></style> tags.
2. Id of the row is not recommended to change or modify because wpdatatables use it for operation like adding, edit or delete.
3. If your MySQL-query based wpDataTable doesn’t work correctly with server-side processing, probably this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (happens rarely, but does sometimes). To avoid this please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
Thanks for the reply. To focus now on the 2nd item.
When I allow a user edit a row they get a popup window. In that Window I would like them to see the row number that they are editing. I do not want them to edit the row number. Just see it. Is that possible?
I am new to wpdatatables and I have a couple of questions about the table editing capabilities:
1) I have managed to find a way to hide the ADD / DELETE options from a table however I am looking for a way to edit the modal box to hide the "Apply and Add New" Button. Can someone tell me how this can be achieved?
2) I would like to show the ID of the row being edited in the modal box but I do not want it to be editable. Is there a way to achieve this?
3) I have changed the display names of columns but when the update happens to that row i get an error telling me 'Unknown Column in field list" is there a way around this?
Many thanks in advance for any advice
I have answered question 3 myself....It appears that if you use column alias' in your query it breaks updates to the table. For example:
select name as Fullname.....
instead of:
select name (and then edit in the interface)
HI cianmaher,
Thank you for your purchase.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days and also support system that we are using was not functional.
1. Every button in editor modal have generated id based on table id. So for button "APPLY AND ADD NEW" you can use css rule:
button#table_1_apply_edit_dialog{ display: none !important; }if the table have id table_1. You have to check throw Inspect element which id is generated. To hide this buttons you can add this CSS on Custom CSS field on wpDataTables settings page or directly on the page between <style></style> tags.
2. Id of the row is not recommended to change or modify because wpdatatables use it for operation like adding, edit or delete.
3. If your MySQL-query based wpDataTable doesn’t work correctly with server-side processing, probably this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (happens rarely, but does sometimes). To avoid this please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
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
Hi Milan,
Thanks for the reply. To focus now on the 2nd item.
When I allow a user edit a row they get a popup window. In that Window I would like them to see the row number that they are editing. I do not want them to edit the row number. Just see it. Is that possible?
Regards,
Cian
Hi Cian,
You can take a look on this link how you can disable input field.
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