Getting Started

 View Only
  • 1.  Using multi select field in pipelines

    Posted 27 days ago

    Hi, I have a pipeline set up that takes a data( a name) from a look up field in one table and moves it to a multi select field on another table. However, each time the pipeline runs, the original name is replaced by the new name instead of added to the list in the multi select field. Does anyone know a way round this? I basically want to have the original AND new value in the same field.

    For various reasons I cant copy the data between tables through relationships, so need to do this through a pipeline.

    Many thanks,

    Laura



    ------------------------------
    Laura Taylor-McAllister
    ------------------------------


  • 2.  RE: Using multi select field in pipelines
    Best Answer

    Posted 27 days ago

    A Multi select field in QuickBase is actually stored as semicolon delimited string with spaces around the semicolons. I'm not honestly sure whether you need the spaces when you are creating new entries with the pipeline but let's assume you do.  

    So under the covers it looks like this.  Apples ; Peaches ; Pairs ; Plums

    So in order to add a new entry to that field you are going to have to append on the new entry by adding a space ; space then the new value. 

    so in he pipeline step you should just be able to do something like this

    {{a.mult_select_field}} ; {{b.new_value_field}}



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



  • 3.  RE: Using multi select field in pipelines

    Posted 27 days ago

    Thank you Mark for such a quick response! I will give it a go :)



    ------------------------------
    Laura Taylor-McAllister
    ------------------------------