-
Goal: I have a table that is a list of books. I would like to have a Search bar that will narrow down what is shown in the table by matching the search to the title of the book and I would also like to have a dropdown menu where I can limit what is shown to a list of publishers. I would like both of these things to narrow what is shown at the same time.
-
Steps: What I have done is in the "Search term" section of the table inspector I have placed:
{{ titleSearch.value }} {{ publisherFilter.value }} -
Details: This works in part. I can use the search bar but it will match the entire row instead of just the title column. If I use the publisher filter it filters more than it should ( I have not troubleshot this yet) I cannot use both however.
-
App json export: Check-in Replacement.json (60.4 KB)
HI there @John_Grotting and welcome to the forums!
Would you mind sharing a screenshot/sharing more background on how you set up your filters?
Here's a short basic tutorial I made that shows you how to implement basic filters:
Hi @MiguelOrtiz Thank you for this video, I have started watching it and it is answering a lot of my questions. I think this will solve the issues that I am running into and I will be back to let you know.
I also edited my post with more information about what I am working on ( I had it formatted incorrectly so most of it wasn't showing)
Ok amazing, I am now using the Default filters to do the search and publisher match and it is working well.
For the title I have: includes({{ titleSearch.value }})
For Publisher I have: =({{ publisherFilter.value }})
The dropdown list for the publisher is mapped to the data which is fine but it is not sorted in any way. Is there a way to sort it and/or limit which publishers are shown? I may end up making a manual list but we will see.
Thank you @MiguelOrtiz I will also be watching more of your tutorial videos.
Glad to hear the video helped!
I've actually been thinking on making a video on how to dynamically populate/filter a select component based on the value of another one. I'll try to make some time tomorrow and share it here as well.
Hi there John,
I posted this, let me know if this helps and it was what you were looking for!
That video is really cool, I don't need that specific functionality for my application but I can easily see a use for it in some future projects. Thank you again for making these!