Forum Discussion

MikeBrady's avatar
MikeBrady
Qrew Trainee
16 hours ago

PIpeline - split multiselect and create records from it

I can't seem to wrap my head around this.  I have a record with a multiselect field. When conditions are met, I want a pipeline to take data from the record and create a new record in another table, creating one record for every value in a multi-select field.  I can't seem to figur eout where I would put the jinja to split those values and then loop through them.  Googling came up with the following for the Jinja:

{% set selected_values = a.your_multi_select_field | split(';') %}

But where would I put this? Seems like I need a step after my trigger to do this, but there isn't a "jinja" channel.  

1 Reply

  • This thread has the answer, but don't use my first response there as the correct answer follows mine!

     

    https://community.quickbase.com/discussions/quickbase-discussions/looping-through-field-values-in-pipeline/50677