Templates, Boots

[Auxiliar_Labora]

Hello,

very clear up to this point. However, if I want that after creating the rows of customers with ages over 21, I want to list in the following rows the customers with ages between 15 and 8 (just for example, it can be any other criteria) How could I do it?

In the PDF template it is very easy, but I can’t find how to make it work in the XLSX template.

[Marc_Dillon]

You can’t. Directly above the portion of the doc that you’ve already posted:

[Marc_Dillon]

Well, maybe you can, if you can combine both lists into one, and just order them a certain way. Something like this?

<<START:ORDERBY( FILTER( Customer , TRUE ) , [Age] <21 )>>

*Not tested*

The second argument of ORDERBY will either return TRUE or FALSE, F coming before T alphabetically.

[Auxiliar_Labora]

Certainly I could already enter several Start and several End, only that I must leave blank rows (as many as records generated by the select) between a start and another.
I would like to find a way to avoid leaving blank rows. Your example is not very clear to me, I would appreciate if you could detail it better, taking into account that it is about applying different selects to the same table that would generate the same number of groups of records according to the criteria (or column).

[Marc_Dillon]

Just to make absolutely clear, you’re trying to do complex stuff with a system that is only setup to handle very simple things. It may not be possible to achieve exactly what you want here.

Auxiliar_Laboratory:

Certainly I could already enter several Start and several End, only that I must leave blank rows (as many as records generated by the select) between a start and another.

I’m curious what exactly you mean by this. Can you provide a screenshot?

Auxiliar_Laboratory:

I would like to find a way to avoid leaving blank rows. Your example is not very clear to me, I would appreciate if you could detail it better

Maybe forget about my previous suggestion for now, here’s a possibly better solution, with some List Addition. Again, not tested.

<<START: FILTER( Customer , [Age] >= 21) + FILTER( Customer , AND( [Age] < 15 , [Age]>8 ) )>>

[Auxiliar_Labora]

Marc_Dillon:

<<START: FILTER( Customer , [Age] >= 21) + FILTER( Customer , AND( [Age] < 15 , [Age]>8 ) )>>

its really better, may be it works.

---

The above only worked for the last select that had blank rows to fill in, so I inserted blank rows between each select and it works, however, I would like to not have to leave blank cells, as each operation may have different number of rows as a result.

[WillowMobileSys]

Auxiliar_Laboratory:

It looks like you are trying to create a template using Excel on the Google Drive?

Excel based templates are much more limited in what they can do.

If, indeed, you are on Google Drive, then use a Google sheet. In Sheets you can place list tables inside of other list tables plus use the Sheets tables to control formatting and placement in general. You can get much better looking documents from templates in Sheets.

[Rafael_ANEIC-PY]

WillowMobileSystems:

If, indeed, you are on Google Drive, then use a Google sheet. In Sheets you can place list tables inside of other list tables plus use the Sheets tables to control formatting and placement in general. You can get much better looking documents from templates in Sheets.

Indeed, you can go HAM on the templates, there’s almost no performance limitations since those are calculated on appsheet’s servers.

Like my little monster over here:

[Auxiliar_Labora]

I am using a template generated by the boot (XLS) and I edit it.

where can I find more information about what you are talking about? Its not very clear to me when you say “In Sheets you can place list tables inside of other list tables”.

I have three instructions to generate 3 list tables. The first instruction generates about 30 rows, and so each one (a number that can vary with each query). If there are no blank rows between one instruction (<> <>) and another, the list is not generated. The first instruction only occupies the row 1, where instruction 1 is, and in row 2 it generates what is indicated by instruction 2, and the third one as if it has blank rows below, it generates the complete list. I understand then that you know how to solve it. Please help me.

[WillowMobileSys]

First, so sorry, I meant to refer to Google Docs not Google Sheets. Templates on Google are created in the Docs app and you can insert tables to control formatting. It may be its not needed in your case but I have feeling it might before you are done.

I don’t think you can list multiple <<START>> blocks like you have done in your Excel template. It’s likely possible you can combine them into a single one and use <<IF>> conditions to report values.

At any rate, if you are not locked into using Excel as a template, I would strongly recommend to spend some time familiarizing yourself with creating templates in Google Docs and using those in your automation. It will give you more value in your app in the long run.

Auxiliar_Laboratory:

a template generated by the boot (XLS) and I edit it.

I am not sure what “boot” is referring to here. Could you mean Bot? I’ve never relied on automatically generated templates so I’m a little unfamiliar with the process.

As for your reference to (XLS), I assume you are referring to the HTTP Content type setting of the generated document (see image below with XLSX set). This is the content type of the FINAL document - not the template itself. The template can be created either with Google Doc or Excel but Excel is not as flexible.

Auxiliar_Laboratory:

Its not very clear to me when you say “In Sheets you can place list tables inside of other list tables”.

In Google Docs you can do something like in the sample template below. You cannot create the same in an Excel template. Note that a <<START>> block is inside of another <<START>> block allowing me to report on each Ordered Kit and under each Kit item from the first START list show a table of the Products ordered in that Kit - another START list.