Get Expert Help

Quick Base Junkie Blog

Short videos and posts to skyrocket your Quickbase skills!

Get tips in your inbox

Join the Quick Base Junkie Community email list!

What is Jinja? (for Quickbase Pipelines)

advanced formulas intermediate jinja pipelines quick base junkie courses quickbase builder Feb 24, 2021

Subscribe on YouTube

 Get the Intro to Jinja for Pipelines course + Jinja Library 

What is Jinja?

Jinja is a templating language for Python programming. And if you're already confused... that's okay. In the simplest terms, Jinja is the language we use to write some cool formulas inside of our Quick Base pipelines.

Why use Jinja in your Pipelines?

Jinja allows you to write formulas within your pipeline, transforming the data as needed between two sources. This means fewer 'helper' fields within your applications that would otherwise be necessary.

What can you do with Jinja?

  • Perform math by adding, subtracting, dividing, or multiplying values.
  • Manipulate text by extracting the part you need or combining it with other fields or text strings.
  • Modify text through the use of functions like replace, capitalize, and format.
  • Mimic Quickbase functions like "Case" and "If" to create conditionalized results.
  • Wrangle pesky date/time fields using time zone, time delta, and other time-based functions.
  • Aggregate values from a search/query step creating counts, sums, and lists. THIS IS A HUGE ADVANTAGE TO USING JINJA

But that's not all!

 

More stuff you can do with Jinja!

  • Set your own variables right in the Pipeline
  • Clear values in your fields
  • Add notes to your Pipeline steps
  • Set default values when results are null

What does Jinja look like?

If you've been using Pipelines, you've already seen Jinja in action. The double curly quotes placed around a field variable is a simple Jinja template... who knew!

{{ a.name }}

Of course, you can do a whole lot more with Jinja! Here's an example with a more advanced use of Jinja:

{{ a.name.split(' ')[0]|upper|trim|default('empty',true) }}

 

 


For more information on Jinja see the resources below, or skip right to the good stuff and get the Intro to Jinja for Pipelines course today!

 

RESOURCES:

Get the Quick Base Junkie Jinja Library referenced in this video

Ge the FREE Jinja Date & Time Cheat Sheet

Quickbase help resource on Jinja

Official Jinja documentation

 

Feeling like a Junkie?  Subscribe Now!