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 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. 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 Filter by Day / Time Slot / Division Users should be able to narrow available debaters or judges using simple on-screen filters (no extra forms). Two‐Step Selection Step 1: “Find a Debater” list filtered to Role = Debater. Step 2: “Find a Judge” list filtered to Role = Judge. 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!

[image] Custom Filtering with Data Editor logic Community Resources 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.

Multi-step filter form

Ask for Help

Jeff_Hager June 14, 2025, 7:28pm 2

Topic		Replies	Views
Filter or show content Ask for Help	5	518	March 2, 2021
Filter to use Per User email and "contains" operator Feature Requests	9	1311	January 17, 2020
Can I save the data entered in the form and use it as a filter in another component? Ask for Help	7	439	October 29, 2019
Send email to filtered users Ask for Help	14	326	December 1, 2022
How to filter row with multiple condition Ask for Help	8	2122	September 1, 2020

Multi-step filter form

Related topics