What is Jinja? (for Quickbase Pipelines)

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 Quickbase 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!
㊙️ You can also 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!
Of course, you can do a whole lot more with Jinja! Here's an example with a more advanced use of Jinja:

RESOURCES:

Quickbase help resource on Jinja:

Official Jinja documentation:

Feeling like a Junkie? Subscribe Now!

LET'S CONNECT!

© Quick Base Junkie

Quick Base Junkie is unofficial and not affiliated with Quickbase Inc.