Searching and Working with Data Grids in FZM

17 October 1, 2024

Learn about the power of fzm  data grids. Including setting up custom “views” and setting back to default.

(4 mins)

Customizing Data Grids in franchizemanager

Users may need to customize their data in a way that’s easy to navigate.

In this guide, we will explore how to effectively work with data and records within the fzm system. The fzm platform provides customizable data grids that allow users to personalize their data view, filter results, and save these configurations for efficient repeated use. This guide covers essential features and tips for managing your data records effectively.

What You Can Do With Your Data Grids

In fzm, data grids come with sort and filter features to help you locate records quickly. You can:

  • Add filters: To find relevant records, you only need to type part of a name or value. You can also use filters to search for records within specific date ranges or perform advanced query operations.
  • Customize columns: Additional columns can be added to enhance your view.
  • Reorder columns: You can drag and drop columns to arrange them in any order that suits your workflow.
  • Save custom layouts: Each time you log in and access this particular grid, it will appear just as you configured it.
  • Sort columns: You can organize information like “created by” to determine the latest records.

Manage and Sort Columns

In fzm, you have full control over the layout of any data grid in the system.

Add and Remove Columns

  1. Go to the data grid that you want to customize.
  2. At the top right of any column, click  More > Columns.
  3. Find the column that you want to add or remove.
  4. On the left of the column, click the box.
    • The column that you selected will instantly appear in your data grid.
  5. If you want to rearrange your columns, you can drag and drop the column to any position in the data grid.
  6. To make this your default view of your data grid, click Save.

Important: The customized views of your data grid are user-specific. The changes you make do not affect other users in the system.

Use Filters in Your Data Grid

Sorting your data is simple. This feature is useful for identifying recent records, sorting by “created by,” or any other available field. You can filter your data using the:

Search Filter:

  1. At the top of the data grid, click the text box. 
  2. Enter the search keyword that you want to look for. 
    • The search filter works with a “contains” logic. You only need to enter part of the text to get a match. 
  3. Press Enter. The data grid will show the results based on the search keyword that you entered.

Sort Filter:

  1. At the top of the data grid, click on the column’s name.
  2. If you want to sort in ascending order, an  Up icon will show next to the column’s name.
  3. If you want to sort in descending order, a Down icon will show next to the column’s name.

Tip: You can also sort the data by clicking on More Sort by Ascending or Sort by Descending.

Advanced Filter:

  1. At the top right of any column, click More Filter.
  2. Click on the advanced filter that you want to use. For example, if you want the data grid to only show data that contains certain keywords, you can choose “Contains.”
  3. If you want to add another keyword, click And or Or.
  4. Click on the advanced filter that you want to use for the second keyword.
  5. Click Filter.

Tip: You can use the advanced filter on all of the columns. For specific dates, you can choose a specific range that you want using the advanced filter.

Reset to Defaults

If you encounter issues, such as missing fields or incorrect data views, resetting your view to default often resolves these problems, as system updates might not reflect in a customized view. Sometimes, the fzm support team might also ask you to reset your grid settings.This helps ensure that any recent coding changes made by the support team take effect.

  1. At the top right of the data grid, click  Reset to Default.
  2. A screen will pop up that says, “Settings of the component will be restored next time the component is displayed.”
  3. Click Ok.
  4. Refresh the page to display the changes.

Important: If a specific column isn’t available, reach out to the support team, and they will add it to your list of selectable fields.

Conclusion

fzm’s data grids provide a powerful and flexible way to manage your records efficiently. By customizing columns, applying various filters, and saving personalized views, you can create a streamlined workflow tailored to your specific needs. These features help you easily access, sort, and manage the information that matters most to you. Leveraging these features effectively will not only boost your productivity but also make your data management tasks smoother and more intuitive.

Take full advantage of these tools to optimize your daily operations, and don’t hesitate to reach out to support if you need assistance configuring your view for maximum efficiency.