# Multi-step filter form

**URL:** <https://community.glideapps.com/t/multi-step-filter-form/82484>\
**Category:** Ask for Help\
**Created:** [June 14, 2025, 4:42pm UTC](https://community.glideapps.com/t/multi-step-filter-form/82484 "2025-06-14T16:42:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Emmanuel\_Makinde](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emmanuel_makinde/32/89279_2.png) [@Emmanuel\_Makinde](https://community.glideapps.com/u/Emmanuel_Makinde)\
**Post date:** [June 14, 2025, 4:42pm UTC](https://community.glideapps.com/t/multi-step-filter-form/82484/1 "2025-06-14T16:42:21Z")

</div>

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.

1. **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).

1. **Two‐Step Selection**

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

1. **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!

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [June 14, 2025, 7:28pm UTC](https://community.glideapps.com/t/multi-step-filter-form/82484/2 "2025-06-14T19:28:35Z")

</div>

> [@Custom Filtering with Data Editor logic](https://community.glideapps.com/t/custom-filtering-with-data-editor-logic/82271):
>
> 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] ](https://www.youtube.com/watch?v=jgMb5HsENEM) 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.