Add a Pipeline to Your App

In this article, you can learn an example workflow of how to add a pipeline to your app where a contact can go through three stages.

This article covers the following topics:

Use Case
Requirements
Steps
- Create a Contacts Table
- Add a Status Field
- Create a Leads Page and Grid
- Add A Link to Move the Contact to the Next Stage
- Repeat the Steps for the Next Stage
Your Results
Extend This Workflow

Use Case

You would like to add a pipeline to your app. This pipeline will have a defined progression from a common start point to a common endpoint.

This way, each record starts at the beginning and goes through a series of actions to progress through the pipeline.

A common example is a sales or customer pipeline. The potential customer may begin as a “lead” and follow a specific path on the way to becoming a "customer."

Requirements

If this is your first time creating an app, you'll need to know some basics about adding tables, fields, pages, and views. You can start by reading our Builder Basics section.

Other good resources can be found in our About Your Database and Working With Pages sections of the knowledge base.

Steps

In this example, you will be creating a sales pipeline where contacts can go through three stages:

Lead
Proposal
Customer/Won

1. Create a Contacts Table

In the Data section of the Builder, create a table to store your contacts.

For this tutorial, you'll need at least one field for the contact's name, but you can feel free to include any other fields you'd like:

2. Add a Status Field

In the Contacts table, add a multiple choice field called "Status". This field will track which stage a contact is in.

Include the following options:

Lead
Proposal
Customer/Won

3. Create a Leads Page and Grid

In the Pages section of the Builder, add a new page using the Contacts table. You'll choose a grid view and name the page "Leads".

Once the page and grid are created, select the pen icon on the grid view to open the editor. Then, go to the Source section and add a filter rule to your data that says to display only the contacts whose status is "Lead":

4. Add a Link to Move the Contact to the Next Stage

First, select the pen icon on the grid to open the view editor. Then, in the "Add Columns" section, go to the "Actions" tab.

Next, select the "Trigger an action" option to add it as a new column to the grid. This creates a link that will trigger an action directly from the view.

Now, hover over the new column and click on the pen edit icon to edit the new action link. Update the column header to say "Next" and change the link text to say "Update to Proposal".

Then, update the action criteria to update the Status field to "Proposal":