# Clothing inventory depending on size, model and teammate **URL:** \ **Category:** Ask for Help\ **Tags:** data-editor\ **Created:** [September 30, 2024, 4:36pm UTC](https://community.glideapps.com/t/clothing-inventory-depending-on-size-model-and-teammate/76714 "2024-09-30T16:36:48Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![GarryVa](https://avatars.discourse-cdn.com/v4/letter/g/c67d28/32.png) [@GarryVa](https://community.glideapps.com/u/GarryVa)\ **Post date:** [September 30, 2024, 4:36pm UTC](https://community.glideapps.com/t/clothing-inventory-depending-on-size-model-and-teammate/76714/1 "2024-09-30T16:36:48Z")
Hello Gliders, I’m building a plumber craft app. In the app, I’d like to display each sizes of my plumber depending on clothing model (craft pants, craft shirt, craft shoes…). The difficulty is that size units are obviously not the same depending on top vs. bottom vs. shoes. I’m stuck… ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/3/e3e55579aed503864c8ce69b510680465b3d2001.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/c/2cad5a21149a8390a41a201ed9141c294baae1f5.png) How can I build my database to display properly clothing sizes in each plumbers’s profile in the Layout ? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/a/8a55f192c3c17dcf7724e2ae678e23b3945b8171.jpeg) I’m not back-end dev, so I’m a bit lost Best, ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [September 30, 2024, 4:46pm UTC](https://community.glideapps.com/t/clothing-inventory-depending-on-size-model-and-teammate/76714/2 "2024-09-30T16:46:12Z")
I recommend restructuring the data in your Sizes table so you only have two columns. A Type column (pants, shirt, shoes), and a Size column (XL, 28, 37.5). Create a Type column in your clothing table, then build a relation linking Type to the Type in the Sizes table. Then add a Lookup, or Joined List or whatever else you need , which refers to the relation. ---
**Author:** ![GarryVa](https://avatars.discourse-cdn.com/v4/letter/g/c67d28/32.png) [@GarryVa](https://community.glideapps.com/u/GarryVa)\ **Post date:** [September 30, 2024, 5:16pm UTC](https://community.glideapps.com/t/clothing-inventory-depending-on-size-model-and-teammate/76714/3 "2024-09-30T17:16:13Z")
Ok @Jeff_Hager I’ll try this. But then, will I be able to display sizes depending on clothing model in each plumber’s profile with this? I feel like it misses something ---
**Author:** ![GarryVa](https://avatars.discourse-cdn.com/v4/letter/g/c67d28/32.png) [@GarryVa](https://community.glideapps.com/u/GarryVa)\ **Post date:** [September 30, 2024, 8:38pm UTC](https://community.glideapps.com/t/clothing-inventory-depending-on-size-model-and-teammate/76714/4 "2024-09-30T20:38:48Z")
I think I did the right thing ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/3/f3de70cfd8c23302ba1fd89b143d2957509f83e9.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/3/036a6574140fc71bedf78d0aab10cd5fe3792f64.jpeg) Do you have any idea to set size to each plumber for every model? Plumbers’s info is in Users table ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/a/bae0855390bc6969945235db2ce6ba4987698bf5.jpeg) ---
**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:** [September 30, 2024, 11:52pm UTC](https://community.glideapps.com/t/clothing-inventory-depending-on-size-model-and-teammate/76714/5 "2024-09-30T23:52:07Z")
So you want a place to store each plumber’s top size, bottom size and shoe size? If that’s the case, you can add 3 columns and point 3 choice components to them. ---
**Author:** ![GarryVa](https://avatars.discourse-cdn.com/v4/letter/g/c67d28/32.png) [@GarryVa](https://community.glideapps.com/u/GarryVa)\ **Post date:** [October 1, 2024, 5:51am UTC](https://community.glideapps.com/t/clothing-inventory-depending-on-size-model-and-teammate/76714/6 "2024-10-01T05:51:27Z")
I can do that. I dont understand what type 3 columns should be ? _\_to go further_ Ideally, how to store each plumber’s clothing model? It might be possible that a plumber wants L size for sweat but M size for t-shirt And ideally, I would like plumbers change sizes in their own profile on their own? ---
**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:** [October 1, 2024, 11:05pm UTC](https://community.glideapps.com/t/clothing-inventory-depending-on-size-model-and-teammate/76714/7 "2024-10-01T23:05:08Z")
If I understand you right, you just need three basic text columns to store each plumber’s top, bottom and shoe sizes, or do I miss something here? ---
**Author:** ![GarryVa](https://avatars.discourse-cdn.com/v4/letter/g/c67d28/32.png) [@GarryVa](https://community.glideapps.com/u/GarryVa)\ **Post date:** [October 2, 2024, 12:43pm UTC](https://community.glideapps.com/t/clothing-inventory-depending-on-size-model-and-teammate/76714/8 "2024-10-02T12:43:24Z")
Without reply so far, I made something that quite works but it’s pretty bad and not exactly what I want. Here in this message what I made, and then in a second message, what I want : **Users table** ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/f/cf547a3c848c467f2b5c7b86da282ef43fb6de5b.png) **Clothing table** ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/e/ae1f7853394c125213706ad54444c44f573b3463.png) **Sizes table** ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/e/3ef11de9c2379c54fa5ee8bb80886137afa28cbf.png) **Display in an user profile’s field** ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/a/da1f2c43369d4d40bb0daada6c22ea1d515d9383.jpeg) ---
**Author:** ![GarryVa](https://avatars.discourse-cdn.com/v4/letter/g/c67d28/32.png) [@GarryVa](https://community.glideapps.com/u/GarryVa)\ **Post date:** [October 2, 2024, 12:50pm UTC](https://community.glideapps.com/t/clothing-inventory-depending-on-size-model-and-teammate/76714/9 "2024-10-02T12:50:56Z")
Actually, what I want seems quite simple. I would like to display a Collection into user profile that show user’s size and quantity depending on clothing model, like in this screenshot : ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/0/80852423b5b049b24c0075115cffb77c15c62986.jpeg) I will read _[Here I want user profile’s size]_ as Description and _[Here I want user profile’s quantity]_ as Meta. Thank you @ThinhDinh ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 2, 2024, 1:53pm UTC](https://community.glideapps.com/t/clothing-inventory-depending-on-size-model-and-teammate/76714/10 "2024-10-02T13:53:36Z")
Does quantity mean inventory? Meaning the number you have in stock for each clothing name, type and size? Or does quantity mean the number of clothing pieces that the user has on their possession? ---
**Author:** ![GarryVa](https://avatars.discourse-cdn.com/v4/letter/g/c67d28/32.png) [@GarryVa](https://community.glideapps.com/u/GarryVa)\ **Post date:** [October 2, 2024, 2:07pm UTC](https://community.glideapps.com/t/clothing-inventory-depending-on-size-model-and-teammate/76714/11 "2024-10-02T14:07:19Z")
Quantity means the number of clothing pieces that the user has on their possession ---
**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:** [October 2, 2024, 11:29pm UTC](https://community.glideapps.com/t/clothing-inventory-depending-on-size-model-and-teammate/76714/12 "2024-10-02T23:29:16Z")
And do you want to show that only for each user at once when they view their profile? Or do you want to view multiple users’ possession at once? If it’s just for each user, you can add user-specific columns in your Clothing table and let them fill the numbers there to display. ---
**Author:** ![GarryVa](https://avatars.discourse-cdn.com/v4/letter/g/c67d28/32.png) [@GarryVa](https://community.glideapps.com/u/GarryVa)\ **Post date:** [October 3, 2024, 4:58am UTC](https://community.glideapps.com/t/clothing-inventory-depending-on-size-model-and-teammate/76714/13 "2024-10-03T04:58:28Z")
No specific user column. Collection should show clothing collection with size and quantity for the user profil you are in, and everyone can see. In other words, I’m User A. I go to User B profile and I see User B’s clothing collection. Then, I go to User C profile and I see User C’s clothing collection. I want exactly this : ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/0/80852423b5b049b24c0075115cffb77c15c62986.jpeg) I have a fuzzy idea how to do : maybe an unique Row ID somewhere, maybe creating relation between clothing model and user… but I dont know how to execute ---
**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:** [October 4, 2024, 12:51am UTC](https://community.glideapps.com/t/clothing-inventory-depending-on-size-model-and-teammate/76714/14 "2024-10-04T00:51:55Z")
Does it matter if you don’t see items where the user doesn’t have a quantity? I think you should just have a new table of “Clothing Possession”: | User ID | Item ID | Quantity | | --- | --- | --- | | U001 | I001 | 1 | | U001 | I002 | 1 | And then display that in each user’s profile. ---
**Author:** ![GarryVa](https://avatars.discourse-cdn.com/v4/letter/g/c67d28/32.png) [@GarryVa](https://community.glideapps.com/u/GarryVa)\ **Post date:** [October 4, 2024, 3:47pm UTC](https://community.glideapps.com/t/clothing-inventory-depending-on-size-model-and-teammate/76714/15 "2024-10-04T15:47:03Z")
Thank you @ThinhDinh It works. You helped me understand more 👍 ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [October 11, 2024, 3:47pm UTC](https://community.glideapps.com/t/clothing-inventory-depending-on-size-model-and-teammate/76714/16 "2024-10-11T15:47:38Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.