Blank dates to update fields in Pipeline?

Question

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 [Second Date] with [Date].

The problem I am having, is if [Date] is null, it does not update. It only updates if [Date] is NOT null, otherwise it skips it. I can't use {{CLEAR}} because I want the two date fields to match, so I don't ALWAYS want it to clear.

Does anyone know if this is a bug or by design, or have a work around?

------------------------------
Mike Tamoush
------------------------------

quickbasejunkie · Answer

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).
{% 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 }}&nbsp;If you're interested in learning more about Jinja check out this&nbsp;Intro to Jinja for Pipelines&nbsp;course.------------------------------Quick Base Junkie------------------------------

miketamoush · Answer

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

quickbasejunkie · Answer

Exactly
------------------------------Quick Base Junkie------------------------------

miketamoush · Answer

@Quick Base JunkieIs it the same for a checkbox? Or is there different jinga like {{FALSE if a.checkbox​ is false else TRUE}}------------------------------Mike Tamoush------------------------------

miketamoush · Answer

Actually, scratch that question. I just tested and Pipelines will always update&nbsp; checkbox. It doesn't consider a blank checkbox as null.------------------------------Mike Tamoush------------------------------

Forum Discussion

Blank dates to update fields in Pipeline?

6 Replies