I recently got asked to develop an intranet site for a business owner who wanted managers of his various outlets to be able to report their monthly & yearly results in an easy-to-use online website. The data entry part of this job wasn’t too difficult using WordPress and the Advanced Custom Fields plugin. I was able to construct tables that loaded into fields as default content whenever a new report is created, so that the user could easy punch-in the figures to each table.
I showed the client, and he was suitably impressed, however there was a bit more required to make this site really shine, and thats where a little jQuery magic was required.
My client wanted the figures in each of the tables to apply to various equations that would automatically fill in other blank fields. At first I thought this might be a fairly difficult task, but then I discovered jQuery Calx.
Calx is a library which allows equations to be applied to HTML fields, and will calculate and fill the required equations when the page loads in. Combining this library with pre-rendered equations in the table cells, I was able to create a solution that not only allows reports to be filled in and completed, but also does all of the averages, totals and differences itself, and fills them in for you.
If you’re looking for an on-site maths solution, please get in touch with me today!