Home Consulting Training Blog FREE Tips & Tools Login

What is Jinja? (for Quickbase Pipelines)

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) }}

 

Did you know Quick Base Junkie has online training programs?
Topics include Relationships, Formulas, HTML, Jinja, APIs, and MORE!

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

Quickbase help resource on Jinja

Official Jinja documentation

 

Feeling like a Junkie? Subscribe Now!

Don't miss the latest:

Tips, shortcuts, checklists, reviews, tutorials, and courses from Quick Base Junkie!

Subscribe now to stay in touch

Don't worry, your information will not be shared.

Subscribe

Already subscribed?

Take your Quick Base skills to the next level with Premium Courses.

Explore Courses Now
Close

Don't miss the latest:

Tips, shortcuts, reviews, tutorials, and courses from Quick Base Junkie!

Sign up now to stay in touch

(unsubscribe anytime)