Templates: Subtotals

[Arjen_Ruitenbee]

Hi, I'm looking for a solution to create a pdf with subtotals.

Tables :
Training
Players
Attendance

I would like to create a automatic email with attachment Per month to see the attendance by player.
The same as the subtotal() option in excel.

someone an idea how to create this type of template?

[WillowMobileSys]

You can create a report very close to what you are looking for using templates created from either Google or Word documents.

The key is inserting a series of <<START: --expression-->>...<<END>> blocks to order your data properly AND using document tables in the templates to aid in the formatting of the data.  There is a sizable learning curve to achieve this kind of report.

To get started, I would recommend looking at one of these articles for more details:

Using Google templates

Using Microsoft Word templates

NOTE:  If you have a choice, Google templates are more thoroughly supported.  AppSheet began by using them (long before Google even considered taking over AppSheet)

[DanielGT]

Can you provide an example on how to achieve this, cause I'm been trying to make it work, but always get an "unmatched <<Start>>", I'm using google sheets, but moving the <<End>> in every possible cell, doesn't do the trick.

[1minManager]

So you can do this more or less like you ask, but it depends on how many different regions and sport you have as to wether you do this using a couple of nested <<START functions.  Or you simply hard code each cell with its onw formula.

https://support.google.com/appsheet/answer/11541779?hl=en

Simon@1minManager.com

[WillowMobileSys]

---

@DanielGT wrote:

Can you provide an example on how to achieve this, cause I'm been trying to make it work, but always get an "unmatched <<Start>>", I'm using google sheets, but moving the <<End>> in every possible cell, doesn't do the trick.

---

It would be best to show your template implementation.  There are many ways to use the <<START>><<END>> blocks and you could be facing other issues as well that are not reported explicitly as an error but are preventing proper parsing of the template.

[jaichith]

https://www.youtube.com/watch?v=7un-W1wNwuQ

there are several videos like this in youtube. you can learn by seeing this.

[DanielGT]

@jaichith 

I've found this video from multitechvisions.com, here he gives a really nice explanation on how to apply the <<start>> <<end>> and how the structure could work for subtotals, I hope this would help

Daniel

https://youtu.be/syc8TgbqZKM?si=srGlKWDUfUNcfNvc