Jinja If else statement syntax
In case anyone else is looking for a solution to entering a conditional statement into a Pipeline as an out put value, here is what I learned today.
Below is the syntax entered into the place where...
Forum Discussion
I couldn't find anything either, but somehow have this in my notes, which basically echoes what you have. I can't remember where I got this, but I am pretty sure I found it on Quickbase Junkies page, so give her the credit! Unless it's wrong, then it probably wasn't her :)
//Below is general if/else in Pipelines with jinja. can do this for setting specific fields
{% if some_condition %} {{do something }}
{% elif some_other_condition %} {{do something }}
{% else %} {{do something }}
{% endif %}
I also have these notes about mapping null fields:
When updating a record and mapping some fields to others, if the source field is null, Pipelines will not map that field, it skips it. However, if the goal is to map exactly, even a blank field, then use the following (using field date as an example):
{% if a.date is none %}
{{ CLEAR }}
{% else %}
{{a.date}}
{% endif %}
Could also be written in the condensed format as (I use this, simple and quick):
{{ CLEAR if a.date is none else a.date }}
------------------------------
Mike Tamoush
------------------------------