Smarter UX design

[pilotbrad1]

Hi. I have built a basic inventory app. The inventory stock has many of the same items. I would like to have only one item display on the primary view but when I click on the item it goes into the details about said items. Example: I have 10 trousers, 44 socks and 8 pythons in my inventory, and it loads correctly in the app but it has 10 different lines for trousers, 44 for socks etc. Would it be possible to have one for trousers, the user clicks on it which takes them to the full list of 10 trousers.

[Joseph_Seddik]

Welcome to the community!

Why do you have 10 lines of the same thing? Are they different in any way?

[pilotbrad1]

They may be but not necessarily. The company has 10 trousers that it has issued as uniform so they're the same except for size. Another item are mobile phones: there are 12 of them, each assigned to an employee with different IMEI numbers.

[Joseph_Seddik]

Thanks. You should create different tables to reflect the different categories in your data and build relationships accordingly. Please read the guides in @SkrOYC reply. 

[pilotbrad1]

Will do

[SkrOYC · Accepted solution]

Take a look at this info:

https://help.appsheet.com/en/articles/895267-data-the-essentials

https://help.appsheet.com/en/articles/961426-references-between-tables

https://help.appsheet.com/en/collections/377937-data

In general, you should learn about data normalization.

In summary, you just need three tables that can be called "items" for example, and then the amount will depend on "items bought" vs "items sold". This is just an example, but it's the idea you need to learn

[pilotbrad1]

Thank you, I'll have a look.

[pilotbrad1]

Thanks for the responses. I have been able to solve the issues and others besides.