Multi-step filter form

[Emmanuel_Makinde]

Hi everyone,

I’m trying to build a simple web app with Glide that lets my debate team schedule practice rounds based on Google Form availability. Here’s what I’ve got so far and where I need help:

---

What I Have

1. Google Form & Sheet

• Judges and debaters submit their name, role, division, partner info, and select availability (morning/afternoon/evening) for each day of the week in a checkbox grid.
• A Google Apps Script normalizes that grid into one row per person/day/time slot, including their division, email, and partner email.

2. Glide Data

• NormalizedAvailability sheet: rows of (ID, Name, Role, Day, Time Slot, Division, Email, PartnerEmail).
• Requests sheet: blank table where the app will log each booking (Debater, Judge, Day, Time, Division, emails).

---

What I Want the App to Do

1. Filter by Day / Time Slot / Division

• Users should be able to narrow available debaters or judges using simple on-screen filters (no extra forms).

2. Two‐Step Selection

• Step 1: “Find a Debater” list filtered to Role = Debater.
• Step 2: “Find a Judge” list filtered to Role = Judge.

3. Send Request Form

• After picking one debater and one judge, a form auto-fills Day, Time Slot, Division, DebaterEmail, JudgeEmail, and PartnerEmail.
• Submitting that form writes to the Requests sheet and triggers an email to both parties (and CC to the partner).

---

Where I’m Stuck

• Implementing on-screen filters in Glide so users can filter the list by Day / Time Slot / Division without building extra tables.
• Wiring up the Send Request form to pull in both selected records’ emails and partner email automatically.
• Ensuring the email action only fires once the request is created.

---

Questions:

• Has anyone built something similar in Glide—two filtered lists leading to a combined request form?
• What’s the simplest way in Glide to add built-in filters for multiple columns on a list?
• How do I set up relations/lookups so that selecting a debater and a judge populates the email fields automatically before submission?

Any pointers, example screenshots, or step-by-step tips would be hugely appreciated. Thanks in advance!

[Jeff_Hager]

Custom Filtering with Data Editor logic

A year or so ago I created a video to demonstrate some techniques for filtering collections and charts using pure data editor logic. The video is available on Youtube: [Custom Filters using Data Editor logic] Somebody recently asked if it would be possible to access the App that was used in the above video, so I have now made it available as a copyable private template.