Unable to figure out select statement for Reports

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 :slight_smile:

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

Simon@1minManager.com

2 Likes

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.

1 Like

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.