Pipeline add 1 to blank

Question

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 the syntax to also have it work when the times_bol_sent_to_requesting_client is blank?

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

prashantmaheshw · Answer

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

Thx, worked perfectly.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Pipeline add 1 to blank