Hey :) For a customer I have to build a shop. And he wants an extra landing page with a dynamic fillable pie chart. With that I mean: As soon as a customer orders anything in the shop and pays for it, the pie chart on the other landing page should take this data and fill itself with that amount of money. The chart is supposed to be filled until we're at 8.000 Euro. Then the money will be donated.
Charts created with wpDataTables can't be filled in any other way other than by adding data in the table the chart is created from. Also, for them to be filterable, you will need to add the chart and the table on the same page, and enable "Follow table filtering".
Now, the plugin doesn't yet have an integration with any payment plugins (like WooCommerce, although we are working on that), so to create a table from an actual order, you will need to create a custom SQL Query based table, which will pull the needed data from your database. Doing that requires some knowledge of SQL, and we can't help you with it, because support doesn't include writing custom SQL queries.
You can try using our SQL query generator, but that's not an ultimate generator, and it should be treated as a helper for constructing queries.
Hey :) For a customer I have to build a shop. And he wants an extra landing page with a dynamic fillable pie chart. With that I mean: As soon as a customer orders anything in the shop and pays for it, the pie chart on the other landing page should take this data and fill itself with that amount of money. The chart is supposed to be filled until we're at 8.000 Euro. Then the money will be donated.
How could I solve this?
Warmest regards,
Lena
Hello Lena
Thank you for your interest in our plugin.
Charts created with wpDataTables can't be filled in any other way other than by adding data in the table the chart is created from. Also, for them to be filterable, you will need to add the chart and the table on the same page, and enable "Follow table filtering".
Now, the plugin doesn't yet have an integration with any payment plugins (like WooCommerce, although we are working on that), so to create a table from an actual order, you will need to create a custom SQL Query based table, which will pull the needed data from your database. Doing that requires some knowledge of SQL, and we can't help you with it, because support doesn't include writing custom SQL queries.
You can try using our SQL query generator, but that's not an ultimate generator, and it should be treated as a helper for constructing queries.
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