I’m very new with AppSheet but have some prior programming experience with C languages.
I have two tables ProductCategories and Products.
The ProductCategory table has Category Id and Parent Category Id. If Parent Category Id is blank - means that’s one of the main Categories (root). If Parent Category is NOT blank (has another Category Id) means is a subcategory for another Category (Parent) which also can be subcategory for another category. I had it working in one of my other projects but don’t know how to achieve this on AppSheet. Especially navigation through the app by categories. Hope someone can help me