# Is there a way to gather all data from the user-specific columns **URL:** \ **Category:** Ask for Help\ **Created:** [April 10, 2023, 7:00pm UTC](https://community.glideapps.com/t/is-there-a-way-to-gather-all-data-from-the-user-specific-columns/60369 "2023-04-10T19:00:09Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)\ **Post date:** [April 10, 2023, 7:00pm UTC](https://community.glideapps.com/t/is-there-a-way-to-gather-all-data-from-the-user-specific-columns/60369/1 "2023-04-10T19:00:09Z")
Hi guys, I have an app for keeping stocks and all stocks are user-specific … is there a way to pull that data from that column for all users into another table ? ---
**Author:** ![Lucas\_Malguy1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_malguy1/32/54607_2.png) [@Lucas\_Malguy1](https://community.glideapps.com/u/Lucas_Malguy1)\ **Post date:** [April 10, 2023, 8:17pm UTC](https://community.glideapps.com/t/is-there-a-way-to-gather-all-data-from-the-user-specific-columns/60369/2 "2023-04-10T20:17:37Z")
Hi @Ovi Can you be a little more specific? How is your stocks table built? Do the stocks are already in the app and the users mark them to favorite, or do they add them and if so, are they owner of that row? ---
**Author:** ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)\ **Post date:** [April 10, 2023, 8:33pm UTC](https://community.glideapps.com/t/is-there-a-way-to-gather-all-data-from-the-user-specific-columns/60369/3 "2023-04-10T20:33:18Z")
@Lucas_Malguy1 I have 1 table with all the products and 1 column user-specific with the “In stock” marker for the products that are in stock for each user no row owners ---
**Author:** ![Lucas\_Malguy1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_malguy1/32/54607_2.png) [@Lucas\_Malguy1](https://community.glideapps.com/u/Lucas_Malguy1)\ **Post date:** [April 10, 2023, 8:37pm UTC](https://community.glideapps.com/t/is-there-a-way-to-gather-all-data-from-the-user-specific-columns/60369/4 "2023-04-10T20:37:36Z")
I thought we were talking about a stocks portfolio 😅 Hum I see… I don’t think it’s possible, at least not without some workaround. What is your objective here? ---
**Author:** ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)\ **Post date:** [April 10, 2023, 8:38pm UTC](https://community.glideapps.com/t/is-there-a-way-to-gather-all-data-from-the-user-specific-columns/60369/5 "2023-04-10T20:38:51Z")
To see all the products that are in stock from all locations ---
**Author:** ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)\ **Post date:** [April 10, 2023, 8:50pm UTC](https://community.glideapps.com/t/is-there-a-way-to-gather-all-data-from-the-user-specific-columns/60369/6 "2023-04-10T20:50:34Z")
If anyone knows, is there a way to create an action that will add those ID’s and some data on those rows, as new rows in another table ? ---
**Author:** ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)\ **Post date:** [April 10, 2023, 8:53pm UTC](https://community.glideapps.com/t/is-there-a-way-to-gather-all-data-from-the-user-specific-columns/60369/7 "2023-04-10T20:53:10Z")
Actually I tested this and it’s a solution, but does anyone know if I can add in bulk multiple rows for the same action ? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 10, 2023, 8:55pm UTC](https://community.glideapps.com/t/is-there-a-way-to-gather-all-data-from-the-user-specific-columns/60369/8 "2023-04-10T20:55:39Z")
> [@Ovi](#): > > add in bulk multiple rows for the same action ? The only way to do this is through some sort of automation, where you’re sending a payload to make, whereby it iterates upon the payload, and adds a row for each item in the array ---
**Author:** ![Lucas\_Malguy1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_malguy1/32/54607_2.png) [@Lucas\_Malguy1](https://community.glideapps.com/u/Lucas_Malguy1)\ **Post date:** [April 10, 2023, 9:04pm UTC](https://community.glideapps.com/t/is-there-a-way-to-gather-all-data-from-the-user-specific-columns/60369/9 "2023-04-10T21:04:19Z")
If you want to see the stock for product A in location 1,2,3 and 4, it need to be different rows. Especially if the number of location and product is variable. I don’t know how your app works but maybe this might a solution: - Create a “Main product” tab containing your catalog with the product details. Each product is identified by the RowID and is unique. - Create a second tab, “items”, which correspond to your stock. One item is stored in a location and is linked to a main product (main product rowid). - In your “main product” table, relate each product to the items linked to it. For example: **In your items table:** - Item 1 is TABLE stored in location 1 with 150 in stock linked to main product TABLE - Item 2 is TABLE stored in location 2 with 150 in stock linked to main product TABLE - Item 3 is TABLE stored in location 3 with 150 in stock linked to main product TABLE Thanks to relation in your Main product tab, you will have: - TABLE: 450 units in stock (150+150+150), stored in location 1,2,3 ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [April 10, 2023, 9:08pm UTC](https://community.glideapps.com/t/is-there-a-way-to-gather-all-data-from-the-user-specific-columns/60369/10 "2023-04-10T21:08:42Z")
How do you have stock in USC columns? Is this some temporary data? If not, then I don’t get the concept… ---
**Author:** ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)\ **Post date:** [April 10, 2023, 9:12pm UTC](https://community.glideapps.com/t/is-there-a-way-to-gather-all-data-from-the-user-specific-columns/60369/11 "2023-04-10T21:12:14Z")
I don’t know what an USC column is but is a concept that works for the app I’m building … Table 1: row 1… column “Stock” → “In stock” Simple … or you can have a boolean value to not write anything in it. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [April 10, 2023, 9:17pm UTC](https://community.glideapps.com/t/is-there-a-way-to-gather-all-data-from-the-user-specific-columns/60369/12 "2023-04-10T21:17:15Z")
USC… user-specific column, visible only to the user who writes to this column. Nobody else will see it… that’s why I wonder what kind of stock you are creating.