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…
How can I build my database to display properly clothing sizes in each plumbers’s profile in the Layout ?
I’m not back-end dev, so I’m a bit lost
Best,
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.
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
I think I did the right thing
Do you have any idea to set size to each plumber for every model?
Plumbers’s info is in Users table
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.
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?
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?
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
Clothing table
Sizes table
Display in an user profile’s field
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 :
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
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?
Quantity means the number of clothing pieces that the user has on their possession
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.
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 :
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
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.
Thank you @ThinhDinh It works. You helped me understand more 
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
