🧐 Ability to Search/Query Glide Table by Specific Column Value

[cjwrights]

Feature

I am requesting a feature that allows users to search or query a Glide table by a specific column value directly within Glide.

Problem

Currently, to achieve this functionality, users must:

1. Create a data store in Make.com.
2. Save the records in the data store.
3. Search the data store for the record using the stored rowId from Glide.

This process is cumbersome and inefficient, requiring multiple steps and external tools.

Expected Functionality

• Search Functionality: Users should be able to restrict the search function to only search within a specific column of their choice.
• Query Capability: Users should be able to query a Glide table by specifying a column and a value to search for, returning the relevant records.

Importance

• Efficiency: Streamlines the process by eliminating the need for external data stores and multiple steps.
• User Experience: Enhances the user experience by providing a more intuitive and direct way to search and query data within Glide.
• Flexibility: Offers more flexibility in how data can be managed and retrieved within Glide applications.

Additional Details

• This feature would be particularly useful for scenarios where users need to search for specific part numbers, user IDs, or other unique identifiers within a table.
• It would save time and reduce the complexity of app development within Glide.

Please consider adding this feature to improve the overall functionality and user experience of Glide.

Related Topics

Restricted search - Feature Requests - Glide Community

Restricted search

Please add a feature that lets you restrict the search function to only search a column of choice. For example: The end user will be searching for a part number to obtain details about a specific part number. The part number column contains similar characters as other columns in the sheet. Currently when the user searches for a part number it returns to many results.

[Darren_Murphy]

Just to be clear, are you referring to being able to search/filter via the Glide API?

If yes, this is already possible with Glide Big tables, and I’m led to believe it will at some point in the future also be possible with regular Glide tables.

If you’re referring to querying within the Data Editor, then this is already possible with the Query column.

[Jeff_Hager]

Yeah, like @Darren_Murphy said, this is really easy to achieve in Glide already. Assuming you mean a search function within the app, all you need is a user specific text column, a text entry component that writes to that user specific column, and a query column to check if a certain column in any table includes that user specific search value. Even before the query column existed, it was still pretty easy using a single value column, an IF column, and a filter or relation.