Blank dates to update fields in Pipeline?
I have a formula date field that is sometimes null and sometimes not. Lets call this [Date]. I have a pipeline that attempts to update a field [Second Date]. The pipeline simply says, update [Seco...
Forum Discussion
I feel this!
In my opinion, this is a 'FAIL' in the way Pipeliens currently functions.
Here is the solution (and the same one support will suggest).
------------------------------
Quick Base Junkie
------------------------------
In my opinion, this is a 'FAIL' in the way Pipeliens currently functions.
Here is the solution (and the same one support will suggest).
{% if a.date is none %}
{{ CLEAR }}
{% else %}
{{a.date}}
{% endif %}
Could also be written in the condensed format as:
{{ CLEAR if a.date is none else a.date }}
If you're interested in learning more about Jinja check out this Intro to Jinja for Pipelines course.
Could also be written in the condensed format as:
{{ CLEAR if a.date is none else a.date }}
If you're interested in learning more about Jinja check out this Intro to Jinja for Pipelines course.
------------------------------
Quick Base Junkie
------------------------------
- Thanks! Can I simply put that entire thing in the condition? Meaning, where I would normally say, set [Seond Date] to {{a.date}}, I replace {{a.date}} with the entire if jinja?
------------------------------
Mike Tamoush
------------------------------- Exactly
------------------------------
Quick Base Junkie
------------------------------- @Quick Base Junkie
Is it the same for a checkbox? Or is there different jinga like {{FALSE if a.checkbox​ is false else TRUE}}
------------------------------
Mike Tamoush
------------------------------
