Hi,
I have already read some previous questions in the community, but I can’t find a solution.
I have a “reservations” table: [Id], [client], [date], [time]
in another table I created a search row by date.
so, as a search column (result) I will have:
Select (reservations [id], [date] = [_ thisrow]. [search date])
I would like to create a template that groups the client by time.
ex.
date: << [search date] >>
<< start: [result] >>
time: x
[client] of x
[client] of x
[client] of x
time: y
[client] by y
[client] by y
[client] by y
Thanks in advance
Single category headers in workflow templates for multiple records of same category Tips & Tricks ?
Say you have data like this: [image] With “Group by” selection in a Table view, you can easily display this in the app like so: [image] But what if you want to do so in a PDF file generated via a START expression in a workflow? Use the following general model: [image] 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 seco…
1 Like
can’t use [_thisrow-1]. the workflow starts from a not referring table
Ex:
<<Start: ORDERBY(FILTER(“reserv”, ([_ROWNUMBER] = MIN(SELECT(reserv [_ROWNUMBER], ([_THISROW-1].? = ?)))))…
Your response indicates that you failed to grasp the concept in the post. The concept presented, either in my post, or Steve’s first reply, is a “loop within a loop”, so the speak. The “outer” loop presents the data that is meant for the headers, and the “inner” loop presents the rest of the data, from the records filtered by each individual header. The outer loop doesn’t have to reference anything, and the inner loop need only reference the outer, if that matches your situation. Take another look at it.
2 Likes