Email attachment template expressions

[John_666]

I have spent a full day reading the docs and looking at sample apps to attempt to understand how to create a google docs template to report on a table.  I am desperate for some assistance to understand why I cannot achieve what I need to.  Here is the background and goal.

1. I have a single table called "Job Board" with a key column called [ID] which is a random Hex UNIQUE()

2. The table records truck movements and captures job data in columns such as [Client Name], [Pickup Location], [Pickup date], [Dropoff Date], [Truck Used], etc...

3. I need a report that groups the job rows by [Truck used] which is one of 5 unique text license plates representing the 5 trucks. [Truck Used] is an ENUM list and not a ref column to a seprate table.

4. I need to be able to create a report grouped by [Truck Used] with the other columns noted above underneath them.

5. Most of the examples I have read are focused on embedded related tables and it doesn't apply here.  

6. The <<Start: SELECT(Job Board[ID], TRUE)>> expression grabs everything and using any other filters in the Select fail the test.  I cannot figure out how to group the results by [Truck Used].

Thank you for your assistance in advance.

John

[AleksiAlkio]

Do you have a table for your trucks? That would make the job much easier.

[John_666]

I do have a table for the "Trucks" but I only use it for the ENUMLIST dropdown menu for "Job Board" [Trucks Used].  This is the SELECT statement in the [Trucks Used] suggested values formula. 

SELECT(
Trucks[Trucks],
[Trucks] <> ""
)

[John_666]

The key for the Trucks table is [ID]

[AleksiAlkio · Accepted solution]

If yes, then the template would be as simple as this..

[John_666]

Thanks Aleksi.  

I reworked my tables and set the Truck Used as a ref column for the Trucks table.  Seems to work now.

I now need to incorporate the ability to select rows based on the Pickup Date range, and also exclude certain rows based on Job Type.  

I don't want to upset what I have working now so I would appreciate any guidance you have on the expressions and their placement.

Cheers

John