Discussions

 View Only
  • 1.  Pipeline add 1 to blank

    Posted 12-07-2022 17:35
    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
    ------------------------------


  • 2.  RE: Pipeline add 1 to blank

    Posted 12-07-2022 18:19
    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
    ------------------------------



  • 3.  RE: Pipeline add 1 to blank

    Posted 12-07-2022 18:23
    Thx, worked perfectly.

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