We have numerous wpDataTables built off of data populated by Formidable Forms. If we add or delete a field in a form that a table is associated with, the columns IDs change in the DataTable. Not just the field that was added or deleted, but some other ones too. For example, we use the shortcode to sum a column. We edited the form by deleting a field no longer needed and it changed the ID# in the table of a totally unrelated field. So my shortcode of [wpdatatable_sum table_id=21 col_id=337 label=''] was no longer valid because the id# changed. Once I changed the id# in the shortcode it worked fine.
It also messes up any charts we have associated with the table.
Is there anyway we can keep the column IDs consistent? I don't understand why they would change in the first place. It seems like every time we add to a form, we need to rebuild all the tables and charts associated.
This is not coming from wpDataTables but from Formidable Forms. The add-on for Formidable Forms is generating a query in the back which JOINs and unserializes data coming from Formidable Forms' database tables.
Basically, with the add-on, you're getting a non-server-side MySQL query-based table that you can't alter, so if any data is changed, it's changed in the database tables of Formidable Forms. For example, the ID you've mentioned in the SUM calculation function - when the table was generated, that ID was 337, but after you deleted a field, the ID changed, although wpDataTables is still looking at the same ID this field used to have.
I don't know if our developers will be able to change this logic, but I will forward the ticket to them, and see if they have some advice or an idea of how this can be changed in the future.
We have numerous wpDataTables built off of data populated by Formidable Forms. If we add or delete a field in a form that a table is associated with, the columns IDs change in the DataTable. Not just the field that was added or deleted, but some other ones too. For example, we use the shortcode to sum a column. We edited the form by deleting a field no longer needed and it changed the ID# in the table of a totally unrelated field. So my shortcode of [wpdatatable_sum table_id=21 col_id=337 label=''] was no longer valid because the id# changed. Once I changed the id# in the shortcode it worked fine.
It also messes up any charts we have associated with the table.
Is there anyway we can keep the column IDs consistent? I don't understand why they would change in the first place. It seems like every time we add to a form, we need to rebuild all the tables and charts associated.
Hello Todd
This is not coming from wpDataTables but from Formidable Forms. The add-on for Formidable Forms is generating a query in the back which JOINs and unserializes data coming from Formidable Forms' database tables.
Basically, with the add-on, you're getting a non-server-side MySQL query-based table that you can't alter, so if any data is changed, it's changed in the database tables of Formidable Forms. For example, the ID you've mentioned in the SUM calculation function - when the table was generated, that ID was 337, but after you deleted a field, the ID changed, although wpDataTables is still looking at the same ID this field used to have.
I don't know if our developers will be able to change this logic, but I will forward the ticket to them, and see if they have some advice or an idea of how this can be changed in the future.
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
Hello again Todd
Unfortunately, our developers said there's no workaround for this, so without modifying the logic, it can't be done.
Sorry for the inconvenience.
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