Hi all,
how to use start: expression for both rows and columns in appsheet , for example to calculate items sold per month in columns and items in rows, the columns should be added only if items sold exist in that month.
cheers
You are probably wondering about how to use virtual columns?
Here is the documentation you are looking for:
Hi not really 
What i am asking is about <start:whatever_row> <>
and <start:whatever_column> <>
how can you combine both to put in a pdf , so that the column is dynamically created like the row in pdf.
As an example:
SUM <start:items> <> (row)
months where items were sold:
<start:month> <> (column)
btw I asked chatGPT and (it) said that itâs possible 
cheers
Forget about ChatGPT, too much noise about that at the moment hahaha
Here is the documentation for help:
Use Start expressions in templates - AppSheet Help
Use If expressions in templates - AppSheet Help
About this part:
this is not possible.
2 Likes
Hmmm
Probably your did not understood my question, any way , i donât need the documentation as I already build many apps to generate pdfâs with start expression.
cheers
You can only generate rows with start expressionsâŚcanât generate columns.
1 Like
This is your question:
[quote=âea_9000â]
What i am asking is about <
This is my answer:
This is @scott192 's answer:
Two of us did not understand your question in this case.
BTW, thank you @scott192 for confirming my answer and understanding.
About this:
Good for you, hence you know this is not possible.
However:
A workaround would be to create as many tables with as different numbers of columns, as you wish, and wrap these in IF expressions. Iâm just afraid that would come tedious. Hence, my answer, which is kind of a shortcut, is: not possible.
If you still think we donât get your question, please feel free to explain further so that we can help you, or tick one answer as a solution to your question.
Cheers
1 Like
I wouldnât be so hard on this considering that HTML and XML are options for templates.
I can generate PDFs and Worksheets with as much info as I want.
Just saying FWIW
Then Iâm about to learn something today!!! 
How would you do that? Can you share a snipet?
This is a basic HTML to show the way it should be implemented:
Show More
| Header |
| - |
| Value |
Result:
If you want to change the amount of columns:
Show More
<<Start:SomeExpressionOrRefListColumn>>
<<End>>
<<Start:SomeExpressionOrRefListColumn>>
<<End>>
| Header |
| - |
| Value |
If you just want to change the amount of rows:
Show More
<<Start:SomeExpressionOrRefListColumn>>
<<End>>
| Header |
| - |
| Value |
If you want both:
Show More
<<Start:SomeExpressionOrRefListColumn>>
<<End>>
<<Start:SomeExpressionOrRefListColumn>>
<<Start:SomeExpressionOrRefListColumn>>
<<End>>
<<End>>
| Header |
| - |
| Value |
Itâs important to understand exactly what you want to achive. Multiple columns could be very cumbersome. Also you should think about the styling when there will be an undefined number of columns. If the number is whitin a known range, you could also use expressions inside the style tag
2 Likes
Greaaaaat job @SkrOYC ! Thanks for sharing 
Agreed 
1 Like