Searching Large Tables

Hey everyone! Dan here from the Tulip team.

I wanted to show off a neat trick I learned recently.


Sometimes, you end up working with Tulip Tables which have thousands of records. This makes it very hard to find one or two specific records based on some search criteria. You can’t use Ctrl + F because the data only shows 50 records per page. You could create a Tulip App to filter and view the table, but this can be a hassle if you are in a pinch.

Enter… a “Search” Query. You can use the Tulip Table Queries functionality to quickly search through your table, just like you would in Excel. This functionality was designed for using data inside of apps, but can also be used in the table. By creating a Query with filters set to App Input, you can use the test button to quickly input values and see the filtered view. Lets see an example.


Say we have a table for materials which need to be used for an order by a certain time

We can create a search query with an App Input filter such as

When we save this query, we will be able to hit the “Test” button to manually enter the filter values we would like to see. And voila!

image

You can add filters on additional columns to create more custom searches:

Happy Tulip-ing!

4 Likes

Really useful Dan! Thanks for sharing