# Report for the User / admin

**URL:** https://community.glideapps.com/t/report-for-the-user-admin/6398
**Category:** Feature Requests
**Created:** [April 4, 2020, 12:52am UTC](https://community.glideapps.com/t/report-for-the-user-admin/6398 "2020-04-04T00:52:50Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![ske333000](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ske333000/32/5137_2.png) [@ske333000](https://community.glideapps.com/u/ske333000)
#### Post date: [April 4, 2020, 12:52am UTC](https://community.glideapps.com/t/report-for-the-user-admin/6398/1 "2020-04-04T00:52:50Z")

</div>

At the outset must compliment it is an amazing App builder.

I wish there was a report for the admin or a user which could give a pdf of values (of a particular column) is in negative.

This would be a very helpful tool for inventory management.

---

<div class="post-metadata">

### Author: ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [April 4, 2020, 3:19am UTC](https://community.glideapps.com/t/report-for-the-user-admin/6398/2 "2020-04-04T03:19:40Z")

</div>

Creating a PDF would be something that could be done in a Google script on the spreadsheet. You would have to write some code and possibly employ a library but it could be done. It is not something that you could do within Glide currently.

---

<div class="post-metadata">

### Author: ![ske333000](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ske333000/32/5137_2.png) [@ske333000](https://community.glideapps.com/u/ske333000)
#### Post date: [April 4, 2020, 3:27am UTC](https://community.glideapps.com/t/report-for-the-user-admin/6398/3 "2020-04-04T03:27:51Z")

</div>

Many thanks Mr. George for your suggestion. But I do not know how to write a code in google sheet or employ a library. I am a novice.

Is it possible to get an extract or summary of all the values where the value is Less than 0.

Thanks in advance.

---

<div class="post-metadata">

### Author: ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [April 4, 2020, 3:37am UTC](https://community.glideapps.com/t/report-for-the-user-admin/6398/4 "2020-04-04T03:37:11Z")

</div>

You could easily create a new tab in your app. Just create a new tab pointing to the sheet that has the data you want to show with the values of less than zero and apply a filter, in the Features tab. I created a sample app that shows you this. [xthqh.glideapp.io](http://xthqh.glideapp.io). Make a copy of it and play with it. The second tab only shows the items that have a qty that is below zero.

---

<div class="post-metadata">

### Author: ![ske333000](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ske333000/32/5137_2.png) [@ske333000](https://community.glideapps.com/u/ske333000)
#### Post date: [April 4, 2020, 8:36am UTC](https://community.glideapps.com/t/report-for-the-user-admin/6398/5 "2020-04-04T08:36:09Z")

</div>

Thank You Mr. George for your kind patience in helping me. I have 17 sheets in total & if one TAB could have a consolidated report of Values below 0 it would be of great help. I don’t if it is possible that way. Thanks a million.

---

<div class="post-metadata">

### Author: ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [April 4, 2020, 11:26am UTC](https://community.glideapps.com/t/report-for-the-user-admin/6398/6 "2020-04-04T11:26:48Z")

</div>

Actually that is rather easy to do in Google Sheets using the QUERY function: Take a look at Sheet4 cell A2 in the sheet: [https://docs.google.com/spreadsheets/d/1y3l0HLIVbTwfTkIqTGvYMytazHi9JtFwgi4XXglr3Jc/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1y3l0HLIVbTwfTkIqTGvYMytazHi9JtFwgi4XXglr3Jc/edit?usp=sharing)
