So I am a newbie. I do not even know if this is possible. Basically, I have all my board games on one table. Then on another table, I have the list of games with game mechanics on another table. Basically I want an app that I can mark different check boxes and get back games that match. Example I mark Family game and deck building. I want the results to come up with anything that has those two things. So can this be done in app sheet and can anyone direct me to any instructions on doing something like that.
Thank you!
Hi @Christine_Myers
Welcome to the community !
Yes it is possible.
You may want to start with a very basic app, such as “Simple Inventory”, in order to understand mechanism involved, then use a Slice.
Table required, in my opinion:
- Boards games, columns: key, name, category, mechanics
- Board games category, columns: key, name, check_YesNo
- Mechanics, columns:key, description, whateverYouWant
Slice:
- board games with condition:
[Category].[Check_YesNo]=yes
Columns key should have initial value expression UNIQUEID(), and show property OFF
Columns that have the name of another table, should be of type Ref and have the Source Table set as necessary.
For reference:
3 Likes
Yeah, this is definitely possible in AppSheet! You’ll just need to set up your board games and their mechanics in one table, and then use checkboxes (or enum lists) to filter based on mechanics like “Family Game” or “Deck Building.” AppSheet can handle that with slices and expressions — it’s actually a pretty cool setup once you get the hang of it.
I was messing around with something similar a while back (though mine was more app-focused — like for a Shadow Fight 2 APK project(URL Removed by Staff) , not board games). The idea of filtering based on selected traits is the same though.
If you’re new to AppSheet, their sample apps and YouTube tutorials are super helpful. Happy to share more if you get stuck.