How To Build An Interactive Calculator in WordPress

[@ffmadscientist]

Is there a way to set this up so it pulls numerical data from a pre made spreadsheet? Say if I wanted to be able to type in NFL player 1 vs Player 2 to analyze which one has more value? Basically a trade analyzer

[@yourthemeco]

Yes you can pull CSV data from a Looper, which any spreadsheet software is going to have that as an output format. From there you can upload your CSV or paste the CSV content directly into a Looper. You can also use the External API to dynamically grab CSV data. theme.co/docs/loopers#csv-looper. We also have a video coming out tomorrow on how to integrate CSVs into Cornerstone Charts so be sure to check that out as well!

[@ThiagoPolati]

Thanks a lot for this video! Is helping me build an ROI calculator for IoT projects! I have a question, how can I get the values from one form and present them in another? Thanks a lot!

[@yourthemeco]

We'll assume you are using Gravity Forms like in our video, but it would differ depending on the form plugin. In Gravity Forms you'll need to go into the "Advanced" section of any form input and give it a parameter name that you could then dynamically populate. From there you could use a query string, shortcode, or WordPress block to then populate the form. See this guide: docs.gravityforms.com/using-dynamic-population/. We would also be happy to set this up for you through our One service (theme.co/one).

[@ThiagoPolati]

I am and using gravity perks as well. I did manage to send the values to other forms bulding the respose query. I did it in a separate window on notepad++ though, otherwise it would be super confusing! hahaha

[@BlackMetalAlchemy]

Is the cornerstone charts plugin free or included for Pro users?

[@yourthemeco]

No, It is a premium plugin and can be purchased here: theme.co/cornerstone-charts/#pricing. You can buy the plugin individually or subscribe to Max for access to all premium products.