I just bought wpDataTables to use with Formidable Forms but figured out that I would have to use a mySQL query to my forms as I need to display only the data for the logged in user. In addition, the data unfortunately is also in a row (from many form fields) so I would need to transpose the data into 2 columns to work with your plugin. My problem is that I cannot find the entries in Formidable Forms, I have been using phpMyAdmin to conduct various searches but so far unsuccessful. Since you guys have done an integration with Formidable can you advise where the entries for a form are found? Ultimately I want to display answers to a questionnaire in a spider chart. This all works fine in your plugin by exporting the Formidable data to excel, transposing the data to 2 columns and importing into your plugin! What I really need to be able to do is achieve this automatically by retrieving a users entries into a table when they log in that will then display in a spidergram chart!
If you want to pull data from formidable Forms the best place for that is Formidable forms support, or their Knowledge base. You can sue hooks to get data
Thanks, neither of the Formidable links are helpful. In case others are interested I have now found the data in table wp_frm_items_metas, column 'meta_value' and written a mySQL script that works perfectly in myPhpAdmin and also works in your plugin. The data doesn't need rotating fortunately and I have combined it with data from another table to allow the creation of the spiderweb, that also works well.
I saw that you managed to solve it using an SQL script that combined data with data from another table (_frm_forms, _frm_items, _frm_item_metas, _frm_fields). I try to create one even but without success, I would love if you could share with me how you solved it?
I just bought wpDataTables to use with Formidable Forms but figured out that I would have to use a mySQL query to my forms as I need to display only the data for the logged in user. In addition, the data unfortunately is also in a row (from many form fields) so I would need to transpose the data into 2 columns to work with your plugin. My problem is that I cannot find the entries in Formidable Forms, I have been using phpMyAdmin to conduct various searches but so far unsuccessful. Since you guys have done an integration with Formidable can you advise where the entries for a form are found? Ultimately I want to display answers to a questionnaire in a spider chart. This all works fine in your plugin by exporting the Formidable data to excel, transposing the data to 2 columns and importing into your plugin! What I really need to be able to do is achieve this automatically by retrieving a users entries into a table when they log in that will then display in a spidergram chart!
Hi jeremypeckhamfraser2116,
Thank you for your purchase.
If you want to pull data from formidable Forms the best place for that is Formidable forms support, or their Knowledge base. You can sue hooks to get data
https://formidableforms.com/knowledgebase/formidable-hooks/
And also here you can find their database schema.
https://formidableforms.com/knowledgebase/database-schema/
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
Thanks, neither of the Formidable links are helpful. In case others are interested I have now found the data in table wp_frm_items_metas, column 'meta_value' and written a mySQL script that works perfectly in myPhpAdmin and also works in your plugin. The data doesn't need rotating fortunately and I have combined it with data from another table to allow the creation of the spiderweb, that also works well.
Thanks
Thanks for letting us know, jeremypeckhamfraser2116
We're glad to hear you were able to work around the issue.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Best regards.
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 jeremypeckham,
I saw that you managed to solve it using an SQL script that combined data with data from another table (_frm_forms, _frm_items, _frm_item_metas, _frm_fields). I try to create one even but without success, I would love if you could share with me how you solved it?
Many thanks in advance.