Let’s begin with I know ZERO about scripts but it looks like a script would be the most effective way to do something I want to do. I have a database of sold houses, simple enough. I need to find a way to get the average price of a home from the “selling price” field in my database. Is a script the best bet or ???? Newbie, total Newbie and as I said, I know nothing about scripts.
Hi Scott,
A Script is not required for this.
Tap Forms will generate an average from a set of records for you.
If you’re using the Mac version, switch to the multi-column list view, then click the Sigma button ∑ to show the Calculations row. Then beneath your Selling Price field, click the popup button. Choose Average and you’ll be able to always display the average of the selling prices for the properties.
There’s an equivalent way to do it on the iOS version too. Go to the Field Options screen when editing the field in your form template, then set the Calculation Summary option to Average.
If that’s not what you’re looking for, let me know.
Thanks!
Brendan
.
