New

Creating front end dashboards for users using WP Table Manager?

Pre-sale questions about WP Table Manager

Tuesday, May 03, 2022

3 Replies

361 Visits

Hi,
I currently use Formidable forms on my website to ask users about their exercise routine. I would like to import these results, and add custom formulas using Excel's functions (e.g. =IF statements). I would then like to create visual graphs based on these results and embed them on specific pages on my website to create a real-time dashboard for my users. The idea is that users fill in a form, and their graphs/dashboard changes to represent their answers.

Is this possible using Table Manager? In order for it to work, I would need to be able to create multiple tables and multiple graphs and choose where to embed them onto my website.

Assistance

3 years ago

#17785

Hi,

Thanks for contacting us here about this extension.

I currently use Formidable forms on my website to ask users about their exercise routine. I would like to import these results, and add custom formulas using Excel's functions (e.g. =IF statements). I would then like to create visual graphs based on these results and embed them on specific pages on my website to create a real-time dashboard for my users. The idea is that users fill in a form, and their graphs/dashboard changes to represent their answers.

Is this possible using Table Manager? In order for it to work, I would need to be able to create multiple tables and multiple graphs and choose where to embed them onto my website.

In your case, it's possible from step 3 in your attached image. Our plugin supports basic calculations: Sum, Multiply,.... not If.
If you want to use our plugin, you should customize one more column to store your calculation function.

Hope this helps!
Best Regards,

bencw

3 years ago

#17787

Hi, thank you for your response.

I understand your plugin offers synchronisation with Excel files -- therefore, would it be possible to use functions such as =IF to prepare data in Excel and then use your built-in HighCharts tool to show these calculated values? That would mean that when the Excel file changes, so do the front end graphs?

Assistance

3 years ago

#17789

Hi,

Thanks for getting back to me with more information.

I understand your plugin offers synchronisation with Excel files -- therefore, would it be possible to use functions such as =IF to prepare data in Excel and then use your built-in HighCharts tool to show these calculated values? That would mean that when the Excel file changes, so do the front end graphs?

The synchronization with Excel will have a delay time. I'm not sure but it would work depending on your IF function form.

Thanks a lot!
Best Regards,

Page :
1

There are no replies made for this post yet.