I have a table with lot of entries and their status as A, B, C, D
I am trying to get report daily based on the status of records such as
Status: A
<record 1>
<record 2>
<record 3>
Status: B
<record 4>
<record 5>
<record 6>
โฆ etc
Can anyone help me out with the select and filters statement which is required in report template.
Thanks,
You could instead create a table view grouped by Status and ordered by Record number
Otherwise if it has to be a report, read this first then come back with any more specific questions - https://help.appsheet.com/en/articles/961746-template-start-expressions
We do not currently support โgroup byโ in Reports.
One alternative is to include a series to Start expressions where each Start expression and its related table displays value for one status code value. For example, if you have four status code values, you would specify four Start expressions.
Can you give me example of 1 start statement because i am not able to figure out how to write it out.
So this is the start and select statements I am usingโฆ
<<Start:SELECT(ProductionSheet[Design Status], [Design Status]=โAAAโ)>>
Design Name: <>
<>
The error I am getting is:
Workflow rule โDesign Statusโ action โAction 1โ Body template. Start expression โSELECT(ProductionSheet[Design Status][Design], [Design Status]=โDye Program Not Givenโ)โ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the โKeyโ column of the referenced table.
What part of that error message donโt you understand?
You should use FILTER() rather than SELECT() in your <<Start>>
expression.
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |