Data Source-Views (List)
  • 14 Minutes to read
  • Contributors

    Data Source-Views (List)


      Article summary

      A List View is a flexible and dynamic way to visualize data. It displays information from a Data source in a table-like format, resembling a grid report, and allows you to apply background colors to data columns for easier identification of patterns and trends. Additionally, it serves as an actionable report, enabling you to perform various tasks directly on individual records, such as printing, editing, or launching an app to advance a related workflow.

      USE CASE

      Example 1: Sales Pipeline Management

      Managing leads and opportunities efficiently is critical for businesses aiming to improve their sales performance. With the List View in Quixy, sales teams can organize and track pipeline data effectively, enabling:

      • Filtering leads based on stages (e.g., New, Contacted, Customer etc.)

      • Sorting by revenue potential or source to focus on high-priority opportunities.

      • Highlighting next steps with color-coded statuses to ensure timely follow-ups.

      This structured approach helps teams streamline their sales process, close deals faster, and maintain a clear overview of their pipeline.

      Example 2: Employee on-boarding Process

      For companies like Tech Solutions on-boarding new hires, ensuring timely completion of tasks is essential. The List View in Quixy provides HR teams with a centralized and interactive way to track:

      • Employee details such as names, departments, and roles.

      • Training progress and task completion.

      • Issued equipment and required documentation.

      By simplifying the on-boarding process, organizations can ensure new employees are fully prepared and ready to contribute from day one.  

      Configuring List view

      With Example 1 as our focus, let’s explore how the List View simplifies sales pipeline management. By leveraging its intuitive features, raw sales data can be transformed into meaningful insights, enabling smarter decisions and seamless sales operations. Here's how it works in practice:

      Pre-requisites:

      Before you begin to create a List View, ensure the following pre-requisites are ready:

      1. Data Table: Set up a data table with the necessary fields. For instance, in a sales pipeline scenario, fields might include:

        • Lead ID

        • Lead Name

        • Client POC Name

        • POC Email

        • POC Contact Number

        • Source (e.g., Referral, Event, Web Form)

        • Stage (e.g., New, Contacted, Customer)

        • Revenue Potential

      2. Data Source: Use the data table to create a Data Source that serves as the foundation for your List View. Save the data source after its creation.

      3. Add-ons: Add-ons are extended part of data sources that allow you to add smart columns (static column with static data), rules and actions. The rules within add-ons allow to logically manipulate data and present the data based on business requirements. Data actions in add-ons are primarily used in views like List View, Kanban View, and upcoming views such as Calendar and Map. When these add-ons with data actions are plugged into views, they act as an additional engine, extending the functionality of the views and turning them into actionable reports. Know more about Add-on.

      Creating a List View can be done in two different ways:

      • From the Data Source List Page

        • Navigate to the data source list page where you will find the list of data sources created.

        • Click on a Data Source to open the Actions panel on the right.

        • Click the "+" icon corresponding to the Views option in the Actions panel to start creating a new view.

      • From Admin Menu

        • Go to Admin Menu -> Reports -> Create View.

        • The platform opens a create view pop-up.

        • Select a data source from the dropdown.

        • Enter a name for the view and provide a suitable display name that will be visible for the end-users.

        • Choose or create an Add-on if required.

        • Select List View under Choose View Type and click Next.

      You will land on the List View configuring page, on this page you will notice three segments:

      • Title Bar: On the title bard towards the left side, you will see the List View name, the list version, the data source name, and options to plug-in Add-ons. Towards the right side, you will find the Refresh button, a dropdown to adjust the number of records displayed, the Save button to apply changes, and the Back button to navigate to the previous page.

      • Tool Bar: On the tool bar towards the left side, you will find Smart Columns, Rules, and Actions, which are in view-only mode and gets activated when the Add-on is plugged. You also have options like Access, Group, Filter, Sort, and Stack Headers. On the right side, you have options such as Hide Columns, Field Properties, Color, Freeze Columns, Row Height, and Additional Settings.

      • Data: Displays data from the associated data source.

      Now, let’s dive into how each option can work for you, making it easier to manage your List View and tailor it to your needs.

      • Imagine you're navigating through the list view, filled with multiple columns of information. You only need to see a few specific columns at the moment. With the Hide Columns option, you can quickly choose which columns to display and which ones to hide.

      • In the sales pipeline list view, we can visually highlight each lead’s value potential by applying colors to different revenue ranges. This helps us to easily spot high-value opportunities and prioritize them. There are two color coding options to choose from:

        • Row-Level Color: This option applies color to the entire row based on revenue criteria, making high-value leads stand out instantly in the List View.

        • Field-Level Color: This option applies color only to the revenue field, highlighting the individual value without affecting the whole row, allowing us to focus on specific revenue amounts.

      To assign colors, we create rules based on the lead’s Estimated Revenue:

      • If a lead’s Estimated Revenue exceeds $50,000, we assign green to highlight it as a high-value opportunity.

      • If a lead’s Estimated Revenue is between $20,000 and $50,000, we assign yellow to mark it as a moderate-value opportunity.

      • If a lead’s Estimated Revenue is below $20,000, we assign red to show it's a low-value opportunity.

      These color options help us to quickly assess and prioritize leads based on their revenue potential. For better understanding, refer to the video below.

      For business success, it’s essential to manage leads effectively, ensuring they progress smoothly through their journey and build valuable partnerships with the organization. To achieve this, various actions are needed to communicate with leads, and these actions can be carried out using Add-ons.

      Add-ons include Smart Columns, Rules, and Actions. Since the List View needs actions to support the lead’s progress, we configure them with Add-ons. Know more about how to configure Data Actions. Once the actions are set, we define rules based on the stages of the lead to ensure that each action appears in the appropriate List View column:

      • When the stage of the lead is Demo Scheduled or Detailed Meeting Scheduled, the Meeting Link action is used.

      • When the stage of the lead is New or Qualified, the Send Mail action is used.

      • When the stage of the lead is Customer, the Proposal action is used.

      Once these rules are configured, the actions below play a crucial role in managing leads effectively and driving progress through the sales pipeline.

      • Send Mail: When a new lead enters the pipeline, the Send Mail action is triggered to send an introductory email, establishing the first contact with the client.

      • Meeting Link: As the discussion progresses, the Meeting Link action is used to schedule and track meetings, allowing us to understand the client's needs and present a tailored solution.

      • Add New Client: This action enables to add new clients into the sales pipeline anytime, with easy access through a global button in the top-right corner of the List View.

      • Proposal: When the client is ready to move forward, the Proposal action is used to share a detailed proposal, marking the completion of the sales process.

      • Revenue Analysis: The Revenue Analysis is a chart report that shows the revenue generated by each lead, helping us prioritize high-value opportunities and make data-driven decisions. Know more about how to configure Chart reports.

      At each stage, these actions ensure the lead’s journey is seamless, engaging, and purpose-driven, ultimately guiding them toward a successful partnership.

      After setting up different Actions for the view, you can explore options like Freeze Columns, Filters, and Grouping to the List View:

      • When you’re working with a massive dataset, it can be tough to keep track of the most important columns. That’s where the Freeze Columns option steps in. It lets you lock the essential columns in place, so as you scroll through records, the key information stays in view. This makes it much easier to navigate through the data and stay focused on what matters.

      • Next, to prioritize the most relevant leads, use the Filter option to display only those that meet your chosen criteria. For example, you can filter leads by stages like New or Qualified, helping your team focus on the ones that need immediate action.

      • As you dive deeper into the pipeline, you begin monitoring how leads progress through different stages. With the Group option, you can easily organize records by their current stage, such as grouping leads into categories like Demo Scheduled or Customer. This gives you a clear overview of where each lead stands, allowing you to focus on those that require immediate attention.

      • The Row Height option helps make your data easier to read. You can select from three views—Compact for a more compressed look, Default for the standard layout, or Expanded for a spacious, detailed view.

      • When you want to focus on the leads with the highest revenue potential, the Sort option helps you organize them quickly. By sorting leads based on revenue potential, you can easily spot high-value opportunities and stay focused on the leads that matter most.

      • When you need to organize your data, the Stack Headers option helps group related fields together. For example, you can combine fields like POC Name and POC Email under a 'Point of Contact' section, or group Stage and Revenue Potential under 'Lead Details.' This makes your data easier to analyze and navigate, giving you a clearer view of important information.

      Field Properties

      In the Field properties you can personalize the UI of your List View for both desktop and mobile.

      Below is how you can tailor the List View for the desktop experience:

      Label Customization:

      • Text Wrap: Enables text to wrap within the container to stay visible.

      • Font Style: Choose font styles between bold, italic, or underline.

      • Alignment: Adjust horizontal and vertical alignments for Label.

      • Width: Set a fixed column width (e.g., 200px).

      • Border/Background Color: Choose the Labels background and border colors to enhance visual appeal.

      Data Customization:

      • Text Wrap: Enables data to wrap within the container to stay visible.

      • Font Style: Choose font styles between bold, italic, or underline.

      • Alignment: Adjust horizontal and vertical alignments for Data.

      • Width: Set a fixed column width (e.g., 200px).

      • Width: Adjust column width to fit the data.

      • Border/Background Color: Choose the data cells background and border colors to enhance visual appeal.

      • On-hover Effects: Change row background and text color when hovered.

      Here's how you can customize the Card Layout for List View to enhance the mobile experience:

      • Choose Card Layout: From the dropdown, select one of the following card layouts:

        • Layout 1 (6 Fields)

        • Layout 2 (6 Fields)

        • Layout 3 (5 Fields)

        • Custom Layout (up to 20 Fields)

          • Layouts 1, 2, and 3 come with a fixed structure, where you can add or remove fields, but you can't change the order or size of the fields. If you delete a column, simply replace it with another, keeping the original structure intact.

          • If you need more flexibility, select Custom Layout, which lets you add up to 20 fields. You can arrange and resize the columns to suit your needs.

      • Default Pagination: Define the number of records to display per page.

      Once you've selected the layout, click Update Fields button to open the customization panel and start making adjustments.

      The customization panel allows to adjust the appearance and behavior of the card layout:

      Field-Level Customization:

      For Labels:

      • Font Size: Choose from small, medium, or large.

      • Text Wrap: Turn on this option to make the label text wrap within the container, ensuring it's fully visible.

      • Font Style: Pick from bold, italic, or underline for a distinct look.

      • Horizontal Alignment: Align the label text to the left, center, or right.

      • Text Color: Pick a color to make the label stand out.

      • Show Label Toggle: Turn this on or off to display or hide the label in your list view.

      For Data:

      • Font Size: Choose the size of the text (small, medium, or large).

      • Text Wrap: Enable text wrapping for the data to stay visible within its box.

      • Font Style: Choose from bold, italic, or underline.

      • Horizontal Alignment: Align the data text to the left, center, or right.

      • Text Color: Pick a color for the data for better visibility.

      The UI of the entire card layout can also be customized by selecting the UI Preferences icon in the customization panel.

      UI Preferences: The UI preferences provide customization settings for Label and Data for the entire card layout. The properties include:

      • Font Size: Choose from small, medium, or large font sizes.

      • Text Wrap: Enables text to wrap within the container to stay visible.

      • Font Style: Choose font styles between bold, italic, or underline for labels and data.

      • Horizontal Alignment: Align text to the left, center, or right.

      • Text Color: Adjust the text color for both labels and data.

      • Background Color: Select a background color for the card layout.

      • Background Image: Add an image as the background for the card layout.

      • Show Label Toggle: Turn this on or off to show or hide column names in the list view.

      • Preview Toggle: Toggle on to preview how the Card Layout looks on a mobile device.

      The following two options allow you to customize the List Layout within the List View on the mobile app::

      • Choose Fields: Choose up to a maximum of 3 fields to display in the mobile list view.

      • Adjust Column Width: Adjust the width as per preferences.

      Access Control: Define access levels for users.

      To manage roles, select a workspace and click Add Access. Assign the appropriate role with the required permissions, then click Next to proceed.

      Next, you can control both column visibility and data access within the List View. Here's how:

      For Column Access, you manage which columns users can view and edit:

      • Hide: Prevent users from seeing the column.

      • Enable: Allow users to view and edit the column.

      • Disable: Give users view-only access.

      In the Data Access section, you control access to data rows:

      • Restrict: Limit access to specific rows of data.

      • No Restrict: Grant full access to all data rows.

      Once you've configured these settings, click Next.

      For Advanced Data Access, you can define permissions based on roles and user requirements, ensuring that only the right people can access the necessary data. Finally, click Save to apply the settings.

      This approach helps manage roles and access seamlessly, ensuring that the right people have the right level of access to your data.

      Additional Settings

      Once the List View is set up, it can be further customized using Additional Settings to make the List View more organized and easier to read.

      • Show Aggregate Title: Need to track totals? Turn on this option to display titles like 'Sum' or 'Average' for your summarized columns, helping you see the big picture at a glance.

      • Color Alternate Row: If you find it hard to differentiate between records, simply enable alternating row colors. It makes each record pop, so you can spot what you need right away.

      • Fit to Grid: Working with many columns? Use this option, and your columns will adjust automatically to fit perfectly in the grid, so everything looks neat without any extra effort.

      • Serial Number: Want an easy way to keep track of your records? Turn on serial numbering, and you’ll get a number assigned to each record, making it easier to reference them.

      • Hide Grid Header: If you prefer a cleaner view, turn off the column headers to declutter your screen. It’s all about keeping things simple.

      • Hide Aggregates Title When Exported: When you’re exporting data, sometimes you don’t need the summed-up titles like 'Sum' or 'Average.' This option hides those from your exported file, keeping it tidy.

      • Hide Column Name in Grouping: If you’re grouping your data, but don’t want column names to show up, you can hide them with this option to keep things clean and focused.

      • Hide Record Count in Grouping: When you're grouping records, this option helps reduce the clutter by hiding the count of records, so you can focus on the important details.

      • Hide Main Filters: Don’t want the filter icon in the List View? You can hide it to keep your screen less crowded, limiting filter access when needed.

      • Load View by Default: Want to always see the most relevant data when you open a view? Enable this option, and the system will load your data based on pre-set Quick Filters, so you’re ready to go without adjusting anything.

      • Generate Report with Quick Filters: When generating reports, this option keeps your data organized by hiding the column names used for grouping, so the focus stays on the key information.

      • Auto Refresh: Hate manually refreshing your view? Let this option automatically update your List View at set intervals, ensuring you always have the latest data without lifting a finger.

      • Search Columns: Looking for something specific? Speed up your search by selecting only the columns you want to search through, making it quicker to find exactly what you need.

      • Default Pagination per Record: Tired of scrolling through too many records? Set how many records show per page and make managing large datasets much more manageable.


      Was this article helpful?