# Exporting and extracting user specific data

**URL:** <https://community.glideapps.com/t/exporting-and-extracting-user-specific-data/12423>\
**Category:** Report a Bug\
**Created:** [July 13, 2020, 8:01pm UTC](https://community.glideapps.com/t/exporting-and-extracting-user-specific-data/12423 "2020-07-13T20:01:07Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert\_Olsthoorn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_olsthoorn/32/445_2.png) [@Robert\_Olsthoorn](https://community.glideapps.com/u/Robert_Olsthoorn)\
**Post date:** [July 13, 2020, 8:01pm UTC](https://community.glideapps.com/t/exporting-and-extracting-user-specific-data/12423/1 "2020-07-13T20:01:07Z")

</div>

Our users have the ability to “favorite” available jobs. However, these favorites are stored in a user specific column.

Is there any way to export that data? We’re trying to understand which jobs are the most favorited (and other useful analytics), but can’t seem to find a way to either export to CSV or run a query over the data.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 13, 2020, 10:39pm UTC](https://community.glideapps.com/t/exporting-and-extracting-user-specific-data/12423/2 "2020-07-13T22:39:05Z")

</div>

As of now you can’t access that information via the methods you mentioned. You have to record them back to the Sheet via a form.

---

<div class="post-metadata">

**Author:** ![Robert\_Olsthoorn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_olsthoorn/32/445_2.png) [@Robert\_Olsthoorn](https://community.glideapps.com/u/Robert_Olsthoorn)\
**Post date:** [July 13, 2020, 11:02pm UTC](https://community.glideapps.com/t/exporting-and-extracting-user-specific-data/12423/3 "2020-07-13T23:02:04Z")

</div>

Ah thanks! Have you heard anything about when this feature will be supported (re: querying)?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 13, 2020, 11:11pm UTC](https://community.glideapps.com/t/exporting-and-extracting-user-specific-data/12423/4 "2020-07-13T23:11:34Z")

</div>

If you’re talking about rollups (as in calculations) over specific columns, we don’t have a timeline for that.

---

<div class="post-metadata">

**Author:** ![Robert\_Olsthoorn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_olsthoorn/32/445_2.png) [@Robert\_Olsthoorn](https://community.glideapps.com/u/Robert_Olsthoorn)\
**Post date:** [July 13, 2020, 11:24pm UTC](https://community.glideapps.com/t/exporting-and-extracting-user-specific-data/12423/5 "2020-07-13T23:24:45Z")

</div>

Okay thanks!

---

<div class="post-metadata">

**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\
**Post date:** [July 16, 2020, 9:53am UTC](https://community.glideapps.com/t/exporting-and-extracting-user-specific-data/12423/6 "2020-07-16T09:53:14Z")

</div>

Does it mean that all User Specific information in our app, that are useful for us to conduct analytics, should be entered by the user via a form?  
In some case, this implies reviewing the whole app (ex. when we want to monitor ‘to do’ lists), and downgrading the UX.  
Thanks

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 16, 2020, 10:11am UTC](https://community.glideapps.com/t/exporting-and-extracting-user-specific-data/12423/7 "2020-07-16T10:11:42Z")

</div>

Yeah, we don’t have rollups over user-specific columns now, so that’s the only way if we want to do anything with it.

---

<div class="post-metadata">

**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\
**Post date:** [November 7, 2022, 7:29pm UTC](https://community.glideapps.com/t/exporting-and-extracting-user-specific-data/12423/8 "2022-11-07T19:29:30Z")

</div>

Hi, I was thinking about an idea with regards to this topic.

Would it be possible to simulate an automatic form for users’ (USC) data?

Let’s assume Table-A hosts current (USC) columns

1. Create a Table-B which will collect these (USC) data
2. Create an action\* triggering an _automatic_ copy-paste of the (USC) of Table-A to the “visible” columns of Table-B  
(\* this could be automatically activated by a at each user logging or via a button to be clicked by the user for any reason to find app/app, ex. “say hello”)

Does it seem realistic?  
Thanks

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [November 7, 2022, 11:24pm UTC](https://community.glideapps.com/t/exporting-and-extracting-user-specific-data/12423/9 "2022-11-07T23:24:24Z")

</div>

If I understand you right, that will create a huge amount of rows, though?

---

<div class="post-metadata">

**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\
**Post date:** [November 8, 2022, 6:14pm UTC](https://community.glideapps.com/t/exporting-and-extracting-user-specific-data/12423/10 "2022-11-08T18:14:01Z")

</div>

Yes!  
But the idea is probably just for analysing → once created, it should be extracted to G-Sheet.

The objective for me would be to get back (USC) data, and be able to conduct analysis

- provide users with their data if need be …

Now, let’s to do it … another story…

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [November 8, 2022, 11:00pm UTC](https://community.glideapps.com/t/exporting-and-extracting-user-specific-data/12423/11 "2022-11-08T23:00:50Z")

</div>

If I understand it right, you would still have to digest that row count because you’re creating them from the app, unless you are writing them through an external service like Make/Zapier.
