# Can we get all the values of user specific columns in the data editor as an array? **URL:** \ **Category:** Ask for Help\ **Created:** [November 9, 2021, 8:12am UTC](https://community.glideapps.com/t/can-we-get-all-the-values-of-user-specific-columns-in-the-data-editor-as-an-array/34238 "2021-11-09T08:12:55Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\ **Post date:** [November 9, 2021, 8:12am UTC](https://community.glideapps.com/t/can-we-get-all-the-values-of-user-specific-columns-in-the-data-editor-as-an-array/34238/1 "2021-11-09T08:12:55Z")
Hi, Just an Idea… What I want is to see and perhaps have access to (maybe an array?) all the values of a specific user column in the builder data editor. I don’t always want to write the data in order to calculate and display. This might be tricky I understand that these values are stored locally, but does the app collects this data as well? we have the logins sheet so I suppose we can access data stored locally somehow. I really hope I was able to describe this correctly with my 3rd language 🙂 ---
**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:** [November 9, 2021, 8:18am UTC](https://community.glideapps.com/t/can-we-get-all-the-values-of-user-specific-columns-in-the-data-editor-as-an-array/34238/2 "2021-11-09T08:18:11Z")
You can get it for a single user, but not for all users at the same time. ---
**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\ **Post date:** [November 9, 2021, 8:25am UTC](https://community.glideapps.com/t/can-we-get-all-the-values-of-user-specific-columns-in-the-data-editor-as-an-array/34238/3 "2021-11-09T08:25:02Z")
Do you think this is something that can be done and be of any use to anyone other than me ? I mean like an admin user in the builder that can see all the other users. ---
**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:** [November 9, 2021, 8:31am UTC](https://community.glideapps.com/t/can-we-get-all-the-values-of-user-specific-columns-in-the-data-editor-as-an-array/34238/4 "2021-11-09T08:31:37Z")
Yes, I think it would be useful. And I think it has been requested. You could gather the data now, but it would be a bit cumbersome and would only give you a single snapshot of the data. For example, you could create a Lookup column on an entire user specific column, and then add a button that writes that lookup to a table somewhere. Then in the builder, preview as each of your users one by one and tap the button. Very tedious, and I’m not sure how useful that could be. But an option, if you desperately needed the data for some reason. This is probably the feature request that applies here: > [@Vote for User Specific Roll-Ups](https://community.glideapps.com/t/vote-for-user-specific-roll-ups/16517): > > Please vote for user specific roll ups. Seriously, everyone just go and vote right now/today lol. ---
**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\ **Post date:** [November 9, 2021, 9:15am UTC](https://community.glideapps.com/t/can-we-get-all-the-values-of-user-specific-columns-in-the-data-editor-as-an-array/34238/5 "2021-11-09T09:15:56Z")
Defiantly not that desperate 🙂 ---
**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\ **Post date:** [November 9, 2021, 9:30am UTC](https://community.glideapps.com/t/can-we-get-all-the-values-of-user-specific-columns-in-the-data-editor-as-an-array/34238/6 "2021-11-09T09:30:10Z")
I’ve done this in one of my apps: Use case - call center agents need to be trained on Covid rapid antigen tests - there is a table of tests - and a usc- Boolean istrained? - there is a roll up in the test kit table for number of kits trained on When the user clicks in or out of this tab (I use tabs rather than screens), I write ref value of their rup to a column in the user profiles sheet. And this can be played with in interesting ways afterwards. Hope this gives you some ideas 🙂