Data store: filtering/searching/refreshing records in the browse window
Portuguese With Carla
Having a simple way to search inside a data store. At the moment, I have to manually skim through hundreds of records loading them 20 at a time.
Keywords: Data store, Filters, Search
View: View specific columns
Photo Viewer
View photos in a modal
Log In
Autopilot
Merged in a post:
Allow searching, filtering and sorting on DataStore browsing page
François-Xavier Lepoutre
We start using DataStore massively due to its tight intgration within the Make ecosystem, and having more and more records in them (hundred of thousands).
Built-in DataStore browsing page allows direct edit of Data Store entries, which is awesome when you need to edit a specifc entry manually.
However, finding the right entry to edit is a mess. You need to scroll through the thousands of records to find the one that you need, even if you know its key or data that it contains.
It would be very useful to have :
- a search bar on the top, where you can enter any text, and the browsing page would filter only records containing that text.
- filters on each field, with terms depending on the type of field in the record
- a direct link to a specifi record, if we know its key. For example : https://eu1.make.com/975147/data-stores/browse/92859?key=124567890
Workaround is to create a quick screnario with a DataStore Search module holding the filters, and a DataStore Update module for the edit, but that's not very practical for single edits.
Iain Mace
Yes this functionality would save a lot of hassle.
Striven - Traralgon H Hardware
Yes love to have those functionalities (Search, Filter). Also if its possible to do clone of Data Store for (debugging/back and etc purposes).
Michal Máša
What about the existing "Data store > Search records" module - would it fit your needs?
Portuguese With Carla
Michal Máša: Hi Michal, not really. What I tend to do is browse through the records to find a particular one. Some times to remove it or modify it, but mostly to just see what's going on with a particular user. It's not something that I would create an automation for, it's just that I need to sometime see what's going on. A simple search inside the window that pops-up when you click on a particular data store would suffice.
Does that make sense?
Michal Máša
Portuguese With Carla: Ah, yes, understood :)