I have a Receipts form with the following fields:
Date
Check Number
Amount Received
I would like to add a field for Total Received— that is a sum of all entries from the Amount Received field.
Possible? If so, how?
Many thanks,
Don Simmons
Hi Don,
On your Amount Received field, set the Calculation Type field option to “Total”. Then you’ll see the total appear beneath the Total Amount Received column in multi-column list view mode on the Mac version. In single-column list view, it would be displayed at the bottom of the records list view.
On iOS you can set that field option too. But there’s only the single-column list view, so it should display at the bottom of your records list view.
Thanks!
Brendan
Thanks for such a prompt reply. Wow!
Alas, it did not seem to work for me. It is obvious that I am doing something wrong as I get no total.
I am certain it is a silly little thing — some box not checked, etc. But I am not having success with this.
Many Thanks.
Don Simmons
Never mind! I found it … way down the bottom in the gray border. I just didn’t look there before.
Thank you!
Don Simmons
No worries. Glad you found it.
Thanks!
Brendan
I can only find the sum option on the Multi-column list view. I would like to display a running total for a given field for all records in the layout.
Hi Doug,
Tap Forms 5.2 has a group totals function that lets you display totals per section. It’s available only on the multi-column list view. To view it, click on the little menu button at the top-right of the multi-column list view where you can enable and disable section headers. Choose the Show Group Summaries option.
For the Single-Column List view to see the totals in a popup button set the Calculation Type and Calculation Field on the form itself. You’ll see a popup button that displays the totals for every field you’ve set a Summary Calculation Type on.
There’s no specific running total function though, just the regular total function.
.
