Forum Discussion

LauraTaylor-McA's avatar
LauraTaylor-McA
Qrew Member
2 years ago
Solved

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...
  • MarkShnier__You's avatar
    MarkShnier__You
    2 years 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
    ------------------------------
ShaneMiller's avatar
ShaneMiller
Qrew Member
2 years ago

I had the same issue, I was able to bypass this by adding jinja to the multi-select field in pipelines. In order to start the JINJA2 process for a multi-select field you must first drag and drop from the list of the table you desire a field into the multi select field. Once that happens, you can then create Jinja2 code. This was my code to fix the error you are speaking of:

B.Field is my multi-select field on Table B that will be receiving data
A.Text is my text field on Table A 

{% if B.Field == none %}
  {{ A.Text }}
{% elif B.Field != none %}
  {{ [A.Text, B.Field]|join(' ;') }}
{% endif %}

Hope this helps!



------------------------------
Shane Miller
------------------------------