If my data contains columns of numbers, how would I create a field which shows the total (sum) of those values?
Hi Craig,
You can tell Tap Forms to display the total of any field by setting the Summary Calculation option on each of the fields you want a total to display.
If you’re on the Mac version you can do that by viewing the Multi-column List View, enabling the Summary Calculation Row by clicking on the Sigma button at the bottom of the list of records there.
On the iOS version setting that value is done via the Field Options settings for each field.
You can set it to Total, Minimum, Maximum, or Average.
The results will display at the bottom of the records list view.
Hope that helps!
Brendan
Oh, also if you want a field that is also another column itself and displays the totals of other fields within the same record, then just add a Calculation field and create a formula which adds all the other number fields together.
For example:
[Number 1] + [Number 2] + [Number 3]
Thanks,
Brendan
.
