How can i see all totals of tables on one screen area?

[Ed Morgan]

Just trying the demo.
I loaded in data and need to be able to take numbers and display different money amounts from different tables on a main sheet or something.
To see all totals from all products, Broke down into each product kind, Then by date and year.

Thanks

• This topic was modified 1 year, 11 months ago by Ed Morgan.

[Brendan]

Hi Ed,

So are you looking for some sort of a dashboard or something?

You could do that with a Form Script that fetches totals from fields from different forms and then displays them in a form.

See the scripting topic here:

https://www.tapforms.com/help-mac/5.3/en/topic/scripts

To get a total of a field from a specific form, you can use code like this:

function populateFormTotals() {

   // get the form you want a total from
   var form1 = document.getFormNamed("Form 1");

   // get the field ID you want the total from
   var form1Field1Id = form1.getFieldNamed("Quantity").getId();

   // get the total for all records in form1 for the specified field.
   var totalOfForm1Field1 = form1.getTotalOfField(form1Field1);
   
   // put the total into a field on this form.
   var totalField1Id = form.getFieldNamed("Total Field 1").getId();
   record.setFieldValue(totalOfForm1Field1, totalField1Id);
   form.saveAllChanges();
}

populateFormTotals();

You would then want to populate all the fields in your form with the values obtained from the different forms and fields. But you have to decide what those would be.

Then whenever you want to see the overall totals, just run the form script again and the fields will update.

Thanks,

Brendan

• This reply was modified 1 year, 11 months ago by Brendan.

[Ed Morgan]

Really looking to have like a dashboard like many programs have for all the totals and info to come into one area to see at any time.
But i did a search and i see that was asked about before and no Dashboard is in Tab Forms,

[Author]

Posts