Tuesday, May 03 2022
  3 Replies
  53 Visits
  Subscribe
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.
A
4 months ago
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,
B
4 months ago
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?
A
4 months ago
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.