I have a YouTube channel where I cover what I think of a bunch of gadgets. Each gadget serves a number of purposes so I assign a number of tags to them. Then I create some tests per tag. So for a usb battery a test might be how long does it take to charge. And for a travel router it might be how long does it take to connect to the hotel WiFi. So one device could need both tests done and another only needs one.
So I have a table of tags and what they mean. I have a table of gadgets. And one of tests per category.
Finally I want to creat a table that lists the gadgets and then each of the tags that apply to that gadget and for each tag show each of the relevant tests. And list it all even if I don’t have results. That way I can see which tasks need to be run for each gadget.
So this is a bunch of problems I can’t solve. I cant seem to create a group by of tags that only apply to that gadget. I think normally I could figure stuff out but I’m also taking care of a 7 week old infant so nothing complex makes sense.