Getting Started

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

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

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