Hello everyone, I’m developing a small app cataloging all Catalan plant names found in Catalonia. The database contains 22,800 different names, which I’ve consolidated into a single table rather than separating scientific and Catalan names to stay within Glide’s 25,000-record limit for Google Sheet…

Name: Custom Filters using Data Editor logic
Uploaded: 2024-11-10T00:54:36Z
Description: Here is a video that demonstrates my usual approach to custom filtering: [Custom Filters using Data Editor logic]

Thank you everyone for your fantastic help! I’ve implemented the custom search solution in two ways - a simple version for casual users and a more detailed interface for students and researchers. It’s working great with no performance issues, just as Darren suggested. Jeff, I look forward to testi…

[image] Joan_Simon: Is there a way to configure the Collection component to: Search within a specific column only Match text from the beginning of words rather than any position? I think the only way to do that would be with a custom search. I shouldn’t imagine it would slow the App down. O…

Darren, How would you handle the “starts with” requirement (#2)? In a query? I don’t think you can do this with a filter in the component. Thanks Matt

A simple javascript snippet can do it to get a boolean value that you can use with a filter. function partialMatch(searchString, text) { // Convert both strings to lowercase for case-insensitive comparison const lowerSearchString = searchString.toLowerCase(); const lowerText = text.toLo…

[image] Darren_Murphy: I think the only way to do that would be with a custom search. A custom search uses a text entry instead of the standard way using ‘show search bar’. I think these are the steps you need to take: Create a ‘user specific column’ of type Text in your Plant table (to be …

Here is a video that demonstrates my usual approach to custom filtering: [Custom Filters using Data Editor logic]

[image] MattLB: How would you handle the “starts with” requirement (#2)? In a query? I wouldn’t use a query. I’d use a Single Value column to apply the search term to all rows, then this to check for matches.

Thank you so much, Darren! Your video tutorial was incredibly helpful and eye-opening. I’m particularly intrigued by the top menu implementation you showed - that’s exactly the kind of navigation I’ve been trying to figure out. Until now, I’ve been using Caspio for similar projects (e.g., https://w…

[image] Joan_Simon: I’ll be away traveling for the next two weeks, but I’m excited to try implementing these solutions when I return. If you don’t mind, I might reach out again if I encounter any challenges while setting it up. Sure. If you have follow up questions just post them here in the …

[image] Darren_Murphy: Custom Filters using Data Editor logic Hi Darren, Quick follow-up question: Is it possible to implement the “Custom Filters using Data Editor logic” in a public app without user tables and sign-in requirements? Sorry for my curiosity - I’m trying to understand if this …

Yes, that’s possible. You would just need to move all those User Specific columns and associated logic to the Helper table.

Collection Component: How to Limit Search to Single Column and Word Beginnings?

Ask for Help

Darren_Murphy November 10, 2024, 12:54am 8

Here is a video that demonstrates my usual approach to custom filtering:

Topic		Replies	Views
Limit searches from the collection components to a specific column? Ask for Help	9	312	April 29, 2026
Alternative Search Bar Approach Ask for Help	22	1192	March 18, 2022
🆕💥 Search columns in filtering and visibility conditions Ask for Help	8	543	July 2, 2021
Splitting large data entries into multiple single value columns Ask for Help actions	10	834	October 28, 2023
Collection Search Filtering Ask for Help	2	96	March 11, 2024

Collection Component: How to Limit Search to Single Column and Word Beginnings?

Related topics