Due to migrating an old system (that was raw MySQL and PHP) into wpDataTables that is connected to many other systems, we have a field that was hidden/read-only and a combo of two editable fields. Right now, on edit we have to see this field and manually fill it in.
I'm not seeing a way to manipulate the save process to allow a A+" "+B save to field C. Any possibility?
Unfortunately, you can't combine two columns into one, but if you're using a MySQL query-based table, using the Concat function in the query might do this for you.
Please check out the video above and let me know what you think.
Thank you. Unfortunately, we need to concat the fname and lname fields into "fname lname" on saving of a new user. I didn't create the original database, so I can't say why it has all 3 fields, but it does and they are used in various other systems.
I was hoping you might have an "advanced" save option that might allow field mapping.
Our developers will be working on that, but I can't say for sure when it will be available in wpDataTables. I hope it will be included sooner rather than later, but our developers work on features based on the number of requests they receive, so you may want to cast your vote here.
The suggestions go directly to our lead developer, and he prioritizes them.
More of a "can we" than a support issue.
Due to migrating an old system (that was raw MySQL and PHP) into wpDataTables that is connected to many other systems, we have a field that was hidden/read-only and a combo of two editable fields. Right now, on edit we have to see this field and manually fill it in.
I'm not seeing a way to manipulate the save process to allow a A+" "+B save to field C. Any possibility?
Hello Frank
Unfortunately, you can't combine two columns into one, but if you're using a MySQL query-based table, using the Concat function in the query might do this for you.
Please check out the video above and let me know what you think.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Aleksandar,
Thank you. Unfortunately, we need to concat the fname and lname fields into "fname lname" on saving of a new user. I didn't create the original database, so I can't say why it has all 3 fields, but it does and they are used in various other systems.
I was hoping you might have an "advanced" save option that might allow field mapping.
That said, you can close this ticket.
Hi again Frank
Our developers will be working on that, but I can't say for sure when it will be available in wpDataTables. I hope it will be included sooner rather than later, but our developers work on features based on the number of requests they receive, so you may want to cast your vote here.
The suggestions go directly to our lead developer, and he prioritizes them.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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