Hi all,
I’m looking to filter a dropdown based on a selection in another dropdown on the same form. I know that AppSheet has built in filtered dropdown functionality but I’m struggling to implement it in my app.
Courses Table column: Course Name
Course Details columns: Course (ref to Courses table), Hole, Par, Distance
Scorecards columns: Course (ref to Courses table), Hole (ref to Course Details table), Par (lookup), Distance (lookup), Strokes
When adding a new record to the Scorecard table via the system generated Scorecard_Form, I would like the Hole dropdown to be filtered based on my Course selection and have it display the Par and Distance based on Hole selection.
Any suggestions? Thanks!