I have probably a simple question. I have queried it in here and I don’t THINK I am repeating a question. I apologize if I am.
I have created an app for quality inspectors. They have 3 types of roles: scrap items, sort through suspected scrap, and perform quality testing. The first question asks them what role they are performing today.
When they are done, they can review their work. That is where the “Today’s Work” slice is supposed to come in. The only expression I use is [Date]=Today() and my source data sheet is my main sheet. My results: I get “Scrap”, “Sort”, “Testing” appear in a table. Perfect. But, when I click on them, I would like to see the data associated with each type of role.
For instance, if you choose Scrap. It next asks for Machine Number, Part Number, and more.
If you choose Sort, you get Part Number and types of defects.
If you chose Testing, you choose the Part Number and the tests results you need to make.
My Today’s Work results in a list of Scrap, Sort, Testing, but no further information attached to each. I click Scrap and get the word “Scrap” at the top of my screen. I want to see Machine number and/or part number.
Essentially, I want my inspector to be able to quickly look at what they did and make sure they covered all their bases.
Any help would be great.
Thank you.
LinkedIn
Twitter
