hi, i need a mysql query to build a wpdatatables table that then i'll use as base for radar chart engine (wpdatatables engine [login to view URL]).
My logged user submit a formidable form with:
- three numerical field: NameField1, NameField2, NameField3, NameField4. Each of them can have a range value from 0 to 100.
- an hide text field that save the current logged user id
- a data field with the date of submit.
I need that the query (and then the table) dinamically display values only for the logged user. Moreover the radar chart to work need that the table must be like this:
LabelsForNameFields, ValueFields2018, ValueFields2019, .... (based on entries)
NameField1, 99, 87, ...
NameField2, 98,55, ...
NameField3, 37, 56, ...
NameField4, 14, 37, ...
Formidable form database schema Link: [login to view URL]
I tested this addon: Formidable Forms integration for wpDataTables but isn't useful because it creates only this type of table:
Data,NameField1, NameField2, NameField3, NameField4
Radar Chart can't work with this type of table.
6 freelancers are bidding on average €168 for this job
Hi I read your project about developing wp database queries. I can complete this project in less time. Looking forward to work and discuss more about this project with you. Thanks Shivam Kataria