Boards, sometimes known as Kanban Boards, are a great way to visualise the status of various items simultaneously.
By grouping items into rows and columns, you can quickly track an item through various stages and get a picture of the flow of work.
Boards display records as a card, where the cards can be divided up into columns. Optionally, these columns can then be further divided into rows.
Given Boards allow you to see an overall picture of a group of Records, they make a great choice of tool for visualising and managing your sales pipeline.
The sales team can get an at a glance view of all of their opportunities, allowing everyone to keep on top of who is working on what and where each opportunity is up to in the sales process. Cards can be quickly moved around the Board, ensuring that there is continous visiblity of the latest state of all items.
This tutorial will show you how to create a Sales Opportunity Tracker Board in Gridfox. The first step is to set up the required Tables and Fields so that you can store information about your opportunities.
In the model we will set up in this tutorial, opportunities will be linked to a company and there may be multiple opportunities for the same company. Start by creating a Table for Companies.
If you view the new Company Table in the Screen Builder, it should show as below:
If you would like to store additional information about the Companies in your Project, add in more Fields to the Table.
Now a Table can be created to store information about the Opportunities.
Add the following Fields to the Opportunities Table:
List Field called Stage with List Items ‘Lead’, ‘Engaged’, ‘Scoping’, ‘Quoting’ and ‘Closed Won’
You can adapt these stages to match your internal sales process
If you view your full Project model in the Table Builder, it should show as below:
Add any other Fields that you require to store additional information about the opportunities.
To allow you to assign Opportunities to your team members, they will need to be invited to the Project.
You can optionally assign a colour to each of your invited Users. This will show up on the Board once it is configured.
Add some records into both the Company and Opportunity Tables so that you Board can illustrate the data for you.
You are now ready to start configuring the Board.
You now have a brand new Board Screen. Before it can be saved, it needs to be configured.
Firstly we need to choose the data that will show on the Board. To give an overview of the state of all opportunities in your pipeline, we will want to show the opportunity records grouped by their status.
You will now have a configured Board showing all of your opportunity Records, grouped by their status.
To help understand the value of your pipeline, it may be useful to see the total value of all opportunities in a certain status. You can configure the Board to show the total value of a field on all Records in the column.
Now at the top of each of your Board columns, you can see the total value of all Records in that column.
A probability field was added to the opportunity Table. It may be useful to see at a glance which opportunities have a high probability of progressing. You can use the colour settings on the Board to achieve this.
Any opportunities which were marked as high probability will now be highlighted in your chosen colour on the Board.
When your Users are using the Sales Pipeline Board, as the volume of opportunities increases they may wish to filter the Records that are shown to them. As a Project Admin, you can specify which Fields on the Opportunity Table that they can filter by.
These fields will now show as options when a user opens the filter menu.
Now that you have setup and configured the Sales Pipeline Board, it is ready for your Users to use.
The status of an opportunity can be updated by dragging and dropping the card from one column to another.
To view the details of an existing opportunity, or to edit the details of an opportunity, click the card on the Board to be taken to the Record.
New cards can be created on the Board by clicking the plus icon in the appropriate status column.
To give your sales team quick access to view their opportunities, you can create a saved filter.
The filter will show up in the navigation bar for all of your team to use. It will show them all opportunities assigned to themselves.
Your Sales Pipeline Board is now configured and ready for you and your team to use. Continue to make any adjustments that are required, such as showing more information on cards or adjusting the stages that your opportunities work through.