Template
Custom reports
Reports that users can customize
Industry:
n/a
This app allows you to select rows according to color and size, and then sends an email report to the provided email address.
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
To do this, we've got two tables: Data and Report Requests. We created a form view of the Report Requests table, which is what users will fill out to get an email sent to them.
We added a virtual column called Matching Items to the Report Requests table with the following formula:
SELECT(Data[Name], AND(IN([Size], [_THISROW].[Size Choice]), IN([Color], [_THISROW].[Color Choice])))
That returns a list of rows in Data that has a given size and color.
Then, we added a workflow rule for the Report Requests table. The template for the workflow rule looks like this:
Found <<COUNT([Matching Items])>> row(s):
<<Start:[Matching Items]>>
<<[Name]>> (<<[Color]>>, <<[Size]>>)
<<End>>
That will print a line for each item in the Matching Items virtual column.
This is a preview of the data sets used in the app.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...