To script or not to script

Viewing 1 reply thread
  • Author
    Posts
  • September 13, 2019 at 10:57 PM #36742

    Scott MacLennan
    Participant

    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.

    September 14, 2019 at 3:40 AM #36747

    Brendan
    Keymaster

    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

Viewing 1 reply thread

You must be logged in to reply to this topic.