Use Pipelines to email a .csv file in QuickbaseMar 02, 2020
Access the FREE step-by-step instructions
If you're not yet using Pipelines... you'll want to be after this video!
Quickbase recently launched a brand new automation functionality called Pipelines.
Watch as I demonstrate how to build & schedule a Quickbase pipeline workflow.
💥 Searches for filtered record data on a Quickbase table
💥 Populates the results of the search as rows in a .csv file
💥 Downloads the .csv file as a URL
💥 Stores the URL to the .csv file in a Quickbase table
💥 Emails a link to the .csv file for use outside of Quickbase
In this training, I walk you through the basic steps for creating this pipeline.
For the full Pipeline exercise, visit https://quickbasejunkie.com/pipelinescsv
Pipeline Exercise Overview:
- Obtain Access to Pipelines
- Download & Setup the App
- Build the Email CSV File Pipeline
- Test the Pipeline
- Add a Schedule Enjoy building some awesome Pipelines!
Want to get more from your Pipelines?
Allow me to introduce you to Jinja!
Jinja is the programming language of Pipelines that allows you to write some pretty awesome formulas directly in the pipeline. No more 'helper' fields needed.
Learning Jinja can be challenging.
After all, it is a programming language and the resources are often written for, well, programmers.
That's why I created the Intro to Jinja for Pipelines course, a self-paced, online course that breaks down what Jinja is, how to use it, and includes step-by-step demonstrations.
0:20 How to tell if you have access to Pipelines
0:27 Details on the App from the App Exchange
0:50 Overview of the step-by-step written instructions
1:22 How to create a Pipeline from the dashboard
1:41 How to Define a Bucket Table
3:45 How to Search (or Query) Quickbase Records
5:22 How to Add a Row to a Bucket Table
7:14 How to Download Bucket Table CSV file
7:47 First Test Run of the Pipeline
9:23 How to Create a Record in Quickbase with a Pipeline
11:40 How to set up a Notification for the .csv URL
12:17 Second Test Run of the Pipeline
12:58 Test Run Verification
14:02 How to Schedule a Pipeline
14:53 Schedule Trigger Verification
15:28 Grab the step-by-step written instructions
Feeling like a Junkie? Subscribe Now!