How to let users add new Level 3 item (like Fruit Variety) based on selected Category + Type?

[Thelady]

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