Using multi select field in pipelines
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 nam...
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
------------------------------
