Hi all — I’m building a 3-level hierarchy form in AppSheet and need help making the Level 3 (“Variety”) logic work smoothly.
To make this easier to explain, I’ll use fruit as an example.
🟠 Here’s the structure:
Level 1 = Fruit Category
→ Citrus, Berries, Tropical
Level 2 = Fruit Type
→ Orange, Lemon, Strawberry, Mango
Level 3 = Variety (Detail)
→ Navel, Valencia, Honey Mango
🎯 What I want:
✅ User selects Fruit Category →
✅ Then selects Fruit Type →
✅ Then picks a Variety (Level 3) from dropdown
If it’s missing/new fruit, they click + New, and:
A form pops up with Fruit Category and Fruit Type already filled
They type the new variety: “Carabao Mango”
The system auto-generates:
LEVEL 3 CODE: next number per Fruit Type
LEVEL 3 ID: format like tropical.mango.c03
The entry saves to my “Varieties” table
It’s immediately available in the form dropdown
User | Count |
---|---|
18 | |
11 | |
7 | |
3 | |
2 |