Assuming you did meet Google App Maker, you've got your data in your slick new App Maker solution and you've shared it with your colleagues but of course, you want more. You not only need to store, display and capture new information, but you need to operate on it. Now that doesn't mean you have to take out a dirty scalpel or a rusty saw and go to town on your precious data, like some mad doctor, but rather add, subtract and divide it up like an equally mad accountant. So, let's review Google App Maker cold calculations.
Let's say you're a purveyor of fine pies and you want to track the sales of your different tasty creations. Using a traditional spreadsheet app, you might create columns to capture the following information: products, quantity sold and unit price. Then you would probably add a column with a calculation multiplying the quantity sold by the unit price. Then you might even add a formula at the bottom of these calculations to summarize the results into a grand total. This is just some basic accounting that we've all likely done at one time or another in a spreadsheet. However, because App Maker is a dynamic, data-driven application as opposed to a static spreadsheet, this same process is accomplished slightly differently.
Let me lay out the process in a few steps:
1. First, we go to our Widgets palette and add a Label to the page. Instead of attaching the value property directly to a datasource, we'll place a calculation in it. This calculation is very similar to how we might create one in a spreadsheet. Here's the anatomy of the calculation:
I'm not going to explain the ins and outs of this function because most of it is already set up for you. But this is what you need to focus on when you apply it to your text boxes:
So though it's relatively easy to convert a Google Sheet to an app using App Maker, performing other functions like formatting and calculations are very different. Watch as I create a calculation and format the results.
Join our mailing list to keep up with the latest news and information about custom app development tools. And if you're ready to improve your workflows with your own custom Google App Maker app, we can help.