Group Start Expression

[RayMR]

Hello All,

Sorry if this has been asked before.

I have an app for projects scope of work. The tables are Items for the different items with a [Category] column. For example, Electrical, Plumbing, etc are the different categories.

Then I have a Scope of Work table that is for the different customer projects.

And finally I have a Scope of Work Detail table where I select the different Items from the Items table for each project.

I have been able to create a PDF report for each project scope of work, but I am trying to create a PDF where each category is grouped. I was able to find a start expression that did this but it printed all of the items in the Items table for every project scope of work.

This is the outer start expression

<<Start: ORDERBY(FILTER(“Scope of Work Detail”, ([_ROWNUMBER] = MIN(SELECT(Scope of Work Detail[_ROWNUMBER], ([_THISROW-1].[Category] = [Category]))))), [Category])>>

This is the inner expression inside the table

<<Start: FILTER(“Scope of Work Detail”, ([_THISROW-1].[Category] = [Category]))>><<[Delivery]>>

I cannot figure out how to specify the unique project - the Bot is set to the Scope of Work table

I attached a screen shot of what I am looking for - in this you can see 2 dumpster items that are from different Scope of Work rows.

Thanks, Ray

[AleksiAlkio]

Hi, please check a sample app from appsheet.com/portfolio/531778. App name is “Template Grouping”. The formula the app is using..

<<Start: ORDERBY(SELECT(Data[ID],[ID]=INDEX([GROUP],1)),[NAME],FALSE)>><<UPPER([NAME])>>

<<Start: ORDERBY([GROUP],[_ROWNUMBER],FALSE)>><<[LOG]>>

<>

<>

[RayMR]

Thank you I will check it out.

[AleksiAlkio]

You’re welcome

[RayMR]

I read through - I don’t think it applies to my situation. I am trying to group the report by Scope of Work Detail [Category] for the current Scope of Work [Project].

I can run a report from the Scope of Work table and in a table use

<<Start: Orderby([Related Scope of Work Details],[Category],FALSE,[ItemID])>><<[Category]>>

And get the report I want for each Scope of Work [Project] but I can’t get the grouping I am looking for.

I get this output

Which is acceptable but I prefer this output

I am a newb to this so any help is appreciated

[AleksiAlkio]

With this template, it should give you the correct behavior..

[RayMR]

Hi, I get the formatting correctly with this reply, but cannot separate out different scopes of work.

I created the VC in the Scope of Work Detail table

Every project is listed in the same report. IE - a dumpster is supplied to different projects but every uniqueid of a dumpster is in every report.

Scope of Work Table has different [ScopeID] projects.

Scope of Work Detail has the [Category] and [Items] for each project from a separate Items table

I think I need some kind of AND expression to filter only the current project I am creating report from.

[RayMR]

What I am trying to produce is the Scope of Work Detail - inline view that is grouped by category like the images show. These are 2 different projects, but when I run the PDF the projects are getting combined.

[AleksiAlkio]

Yes, you can filter the SELECT() with the AND().

[RayMR]

Can you show the expression? Is it in the outer start or inner start?

Thanks!

[AleksiAlkio]

It has to be with the outer.

[RayMR]

Sorry I just can’t figure out how to replicate the Inline view I can create by grouping the Categories for the Projects in the app. Should be an easy thing to do. Create a PDF to match the app view.

[AleksiAlkio]

Please take a printscreens from your tables and their column structure that are related and I will create a public sample app how to do it.

[RayMR]

Thank you! I choose a project from the ProjectsforSOW table for the Scope of Work table. Then I add items to the scope of work detail that references the project in the scope of work table.

[Arthurgcruz23]

HELLO, I’m looking for the same result. Did you manage to solve it?

[RayMR]

I am still stuck

Trying to group by [Location] in a child table for only the current project from the main table.

In plain language - select thisrows [project] in the main table and group [items] from the child table by [location]

Main table - [Project]

Child table [ChildID], [Project], [Item], [Location]

[Project] is a ref column from child to main

The action button that starts the Bot is on the main table - The bot runs from the main table

[Steve]

Please post a screenshot of the bot’s event configuration.

[RayMR]

An action button on the Project table updates the selectiontrigger field to now()

[RayMR]

This is the full expression for the condition from the action button

[RayMR]

This is the child table