# What is the better way to create "User Specific" GS\\XLS report

**URL:** https://community.glideapps.com/t/what-is-the-better-way-to-create-user-specific-gs-xls-report/39177
**Category:** Ask for Help
**Created:** [March 3, 2022, 7:01am UTC](https://community.glideapps.com/t/what-is-the-better-way-to-create-user-specific-gs-xls-report/39177 "2022-03-03T07:01:17Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![ALEKSEI\_BARANOV](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aleksei_baranov/32/33948_2.png) [@ALEKSEI\_BARANOV](https://community.glideapps.com/u/ALEKSEI_BARANOV)
#### Post date: [March 3, 2022, 7:01am UTC](https://community.glideapps.com/t/what-is-the-better-way-to-create-user-specific-gs-xls-report/39177/1 "2022-03-03T07:01:17Z")

</div>

Hey glidermans!

I need to create user reports calculating data by rollup columns from main operations sheet. This report **must be** XLSX or GS.  
I made **Report sheet\tab** in my App GS as a Report Template and fill it by calculating user data,  
then **use Open link Action to export this Sheet to XLS**.

But seems it could be troubles when many users will use this approach because they share the native GS Report Sheet, so reporting data could be mixed from different users. Of course I use User Specific Columns for user filtering to catch exact data which the user want to see in the report. But to have possibility to export this Sheet i need to fill the native GS Columns. It is not easy to fill the Template Report sheet staying on the 1st row - i use many Relations Columns to the same Sheet to use Set Column Action by this Relation to fill the data in different rows of Template.

What can i do to prevent the situation when different users making reports will fill the same native GS columns in the same time? My thoughts are following.

- One way could be to make “user specific” sheet or tab. Is it possible\better?
- Another way could be using API maybe instead of Exporting?
- Or the better way is another?  
Does somebody solved such issue?

Thank you in advance.

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 3, 2022, 7:08am UTC](https://community.glideapps.com/t/what-is-the-better-way-to-create-user-specific-gs-xls-report/39177/2 "2022-03-03T07:08:19Z")

</div>

> [@How To: CSV Export and send as email](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618):
>
> Below is a short tutorial that demonstrates how to generate a CSV export from Glide, and send it as an email attachment using Integromat. This uses the joined list technique that was originally described by @Purvang_Joshi [here](https://community.glideapps.com/t/export-glide-table-google-sheet-data-to-csv-using-joined-list-apps-script/27467). I hope others find it useful slight_smile

If you use the technique described in the above, you eliminate the problem of users overwriting each other’s data. Also, because the export comes directly from Glide, you can include computed columns easily.

---

<div class="post-metadata">

### Author: ![ALEKSEI\_BARANOV](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aleksei_baranov/32/33948_2.png) [@ALEKSEI\_BARANOV](https://community.glideapps.com/u/ALEKSEI_BARANOV)
#### Post date: [March 3, 2022, 7:51am UTC](https://community.glideapps.com/t/what-is-the-better-way-to-create-user-specific-gs-xls-report/39177/3 "2022-03-03T07:51:32Z")

</div>

🙏 Thank you very much, Darren, am going to watch…
