Forum Discussion

Qrew Legend

3 years ago

Pipeline add 1 to blank

I have a pipeline step which increments a field by 1 {{a.times_bol_sent_to_requesting_client + 1}} That works just fine unless the field is blank at the start. Is there a simple way to update t...

PrashantMaheshw

Qrew Captain

HI Mark,

null values are a pain indeed. Fortunately you can use the default filter to specify a value for all cases where value is not found (blank)

{{a.times_bol_sent_to_requesting_client|default(0,true) + 1}}

------------------------------
Prashant Maheshwari
------------------------------

MarkShnier__You

Qrew Legend

3 years ago

Thx, worked perfectly.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------