Forum Discussion

OanaWhalen's avatar
OanaWhalen
Qrew Cadet
3 days ago
Solved

Multi-Select Fields with Commas in Pipelines

I have a text field in one table that I need to use to populate a multi-select text field in another table via Pipelines. The text field contains a semi-colon-delimited list of people, including thei...
Pipelines
  • QuickBaseJunkie's avatar
    QuickBaseJunkie
    2 days ago

    This is definitely an issue. I thought I put in a case for it, but I could not locate it in my history.

    To work around the issue I used a Quickbase Make Request step to do an API_ImportFromCSV. In that payload I could put the value of the multi-select into a set of quotations so that it would not break it up when inputing it in the new record.

    In the code sample below, the field "core value" is what had the issue similar to yours.

    <qdbapi>
<usertoken>%user.token.xyz%</usertoken>
<apptoken>apptokenhere</apptoken>
<records_csv>
     <![CDATA[
"{{a.comment}}","{{a.core_value}}",{{a.cust_emp}},"{{a.emp_name}}",{{a.id}},{{a.dbid}},{{a.from}}
     ]]>
</records_csv>
<clist>7.9.6.8.11.13.10</clist>
</qdbapi>

    -Sharon

QuickBaseJunkie's avatar
QuickBaseJunkie
Qrew Commander
2 days ago

This is definitely an issue. I thought I put in a case for it, but I could not locate it in my history.

To work around the issue I used a Quickbase Make Request step to do an API_ImportFromCSV. In that payload I could put the value of the multi-select into a set of quotations so that it would not break it up when inputing it in the new record.

In the code sample below, the field "core value" is what had the issue similar to yours.

<qdbapi>
<usertoken>%user.token.xyz%</usertoken>
<apptoken>apptokenhere</apptoken>
<records_csv>
     <![CDATA[
"{{a.comment}}","{{a.core_value}}",{{a.cust_emp}},"{{a.emp_name}}",{{a.id}},{{a.dbid}},{{a.from}}
     ]]>
</records_csv>
<clist>7.9.6.8.11.13.10</clist>
</qdbapi>

-Sharon