Build filtered presets to save as custom views
Hello, Tadabase Users! Today, we're excited to showcase a fantastic technique that allows you to create custom views or filtered presets for your database applications. With this functionality, you can build your own links that open up a specific, personalized view of your data table. Let's dive in and explore how to achieve this!
Goal: The goal is to enable users to create customized links that take them to predefined or custom views of a particular data table. Users can apply filters and generate URLs containing specific parameters to open filtered views of the table.
Features to Use:
1. Tadabase Search Component: This component allows you to apply filters to a data table. Unique to this feature is the ability to use URL parameters for filtering.
2. Dynamic Field: This lightweight and fast option helps you build links with URL parameters based on field values or record values.
1. Start by creating a main page to display your data. Add a table component to show the company data and a search component above it. Link the search component to the data table.
2. Configure the search component's fields for filtering. Include the date field twice (one for "is after" and another for "is before").
3. Define URL parameters for each filter you want to use. Keep them simple and descriptive.
4. Use URL parameters to filter the data on the page by adding them to the end of the page URL. For example, "turnover=low" or "profit=high."
5. Hide the search component, as users will interact with the data only through the URL parameters.
6. To enable users to create their own views, build a new data table with fields for view names, filter options, and user connections.
7. Utilize the dynamic field to create HTML links that contain the necessary URL parameters. These links will represent the custom views.
8. Add pages to allow users to add and edit their custom views.
9. Users can now create and save their custom views, and when they click the corresponding link, it will open a new tab with the filtered data.
This technique combines the power of the database search component, URL parameters, the new dynamic field, and page and data builders to create a seamless experience for building and utilizing custom views. Feel free to experiment with different views and explore the endless possibilities that Tadabase offers for enhancing your applications.
We hope you find this technique as exciting and useful as we do! Remember, there are always new features and combinations to discover, making your Tadabase apps even more amazing. Thank you for joining us in today's episode of Build It with Tim. Until next time, take care and happy building!