I have an editable data table, using a MySQL data source. The table
has server-side processing enabled as is required for editable tables
has columns
1 concatenated string column, not editable
3 editable columns with table relationship to show a string and store ID
Two of the editable columns (Area and Type) display fine in the add/edit screens.
One of the editable columns (Category) does not.
They appear to have the exact same settings. I've even removed the column from the query, saved, made sure the column was gone, re-added it to the query and redid all its settings. No change.
Screenshots attached. Can you see where I went wrong?
[edited to add] EGADS I found it right after I clicked submit. I had the table itself set to use the Category ID value as the ID column for editing. I set that to the proper ID column of the whole table and voila, success. Please close this ticket! :0)
I have an editable data table, using a MySQL data source. The table
Two of the editable columns (Area and Type) display fine in the add/edit screens.
One of the editable columns (Category) does not.
They appear to have the exact same settings. I've even removed the column from the query, saved, made sure the column was gone, re-added it to the query and redid all its settings. No change.
Screenshots attached. Can you see where I went wrong?
[edited to add] EGADS I found it right after I clicked submit. I had the table itself set to use the Category ID value as the ID column for editing. I set that to the proper ID column of the whole table and voila, success. Please close this ticket! :0)
Hi, Becca
Sorry for the delay
-
I am very happy to see that you eventually found the root of the issue, and you have resolved it.
Thank you for letting us know. Anything else that we could assist with, please don't hesitate to create new tickets.
Have a great day!
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