Which basically says “if this is the first item in this category, display a header”.
The tricky part is when using a subset of values in a table, like child values of the parent record you’re working with. Then for the second blue section, you’ll need to FILTER the whole table by a ref column, which requires the use of a _THISROW statement, and they work kind of funky inside START expressions in workflows. You’ll probably need to use _THISROW-1. Don’t really want to get into that here, but just didn’t feel like this Tip was complete without mentioning the issue.
Can we have the workflow template for the Report (file attached) for the data(file attached)!
i hv used
<<Start: ORDERBY(FILTER(“SLICE_D”, ([_ROWNUMBER] = MIN(SELECT(SLICE_D [_ROWNUMBER], ([_THISROW-1].[NAME] = [NAME])))))+FILTER("SLICE_C ", ([_ROWNUMBER] = MIN(SELECT(SLICE_C [_ROWNUMBER], ([_THISROW-1].[ ACCNT] = [ACCNT]))))), [NAME])>>
<<[ NAME]>>
for the header
and
<<Start: FILTER(SLICE_D, [NAME]=[_THISROW-1].[ NAME])+FILTER(SLICE_C, [ACCNT]=[_THISROW-1].[ NAME])>><<[UNIQUEID]>>
DATE<<[DATE]>>
PRT<<[PRT]>>
NAME_D <<IF(IN([_THISROW-1].[UNIQUEID],SELECT(SLICE_D[UNIQUEID],[ NAME]=[_THISROW-1].[ NAME]))=TRUE,[UNIQUEID].[ NAME_D
],””)>>
ACCNT_C <>
I have been using AppSheet for almost 3 years. I have read your expression like 12 times and still don´t understand it. I just can say you are a god. I was trying to make a grouped catalogue and it has being impossible until I arrived at your answer. Thank you for this.
Sorry for replying to this old post, but I’m actually need to do this group by and the code is not working so I need to understand what’s happening in here.
The screenshot has a table with 2 columns, category and value, however, the code seems to be using 3, category, value and key, is this table[key] supposed to be my own table and the key/ID column?
I actually tried that but it’s not working, I even use literally table[key] and nothing. Do I need to apply filter to the first orderby?
Any guidance or explanation will be appreciated since using the code as it is is not working, maybe I’m missing something.
I’m sorry Ragnaros but it seems that your knowledge of the platform is kinda weak. I suggest to read the docs from the basics so that you get a better idea before going into such an advance topic as this is
I’m really sorry that you found this ofensive. Maybe because english is not my main language I give it another meaning.
The way I started with AppSheet was by reading the docs, didn’t even bothered to ask for help until I knew the basics and a litle bit more, so I though that it would be helpful for you as it was for me to try read the docs first.
I gave a detailed explanation about the behaviour of headers in workflow templates in the post I mentioned above:
@SkrOYC I wanted to thank you for all your years of input into this community, especially taking the time to read, advise as well as translate many topics that have driven this platform forward with invaluable information.
I also salute you for humbly apologizing when small word discrepencies may translate wrong in eyes of readers although not even intended, there is not one ounce of offence in you from all your assistance and posts I have seen over the years.
Please do continue with your humble nature my good friend…
