Forum Discussion

JennasonQuick_B's avatar
JennasonQuick_B
Qrew Trainee
4 years ago

Looping through field values in Pipeline

I have a record that contains a text field with multiple values separated by commas (which I can also turn into a multi select field if that makes things easier).     I want to loop through the values...
Pipelines
KristofferKeen1's avatar
KristofferKeen1
Quickbase Staff
You can use the Text channel to "Find All Matches to a Regex", and use the following Regex: ([^;]+) if you go with the multi-select option which separates values using a semi-colon.  Otherwise, you can change the semi-colon to a comma in the middle of the regular expression, since the comma is the delimiter in your use case: ([^,]+)

Then For each "match/Regex filtered group" (because it's split by a semi-colon or a comma in your case), you can then use each group to create a new record.

So in the subsequent create record step, map the regex step's Group 1 to the new table: {{b.group_1}}

See screenshots below for reference.

Enjoy!

------------------------------
Kristoffer Keene
------------------------------
PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
3 years ago
@Kristoffer Keene, I need to do something nearly identical, how could this be modified to iterate through each and search another table to create a bulk upsert?​

------------------------------
Paul Peterson
------------------------------
  • KristofferKeen1's avatar
    KristofferKeen1
    Quickbase Staff
    3 years ago
    Hey Paul, I hope the screenshot below helps direct you better:

    You could prepare the upsert as step b and have one final import/upsert at the very end of all records found, but in the example above, I showed how to prepare and upsert per split.

    I think your biggest question is around getting the search step to match the split field, so here's another screenshot setting the search query to match the Regex's group 1 response:


    Let me know if you have any additional questions :)


    ------------------------------
    Kristoffer Keene
    ------------------------------
    • PaulPeterson1's avatar
      PaulPeterson1
      Qrew Assistant Captain
      3 years ago

      Thank you!  This is creating the results I need.  It's painfully slow and that is a concern since this was run in a test instance of the app with about 10% of the data in the production app.  Fortunately, I have a meeting with an SA soon and will use this as the starting point and will share their suggestions.

      Thanks again for your help!!



      ------------------------------
      Paul Peterson
      ------------------------------
    • FrancescoSpiga's avatar
      FrancescoSpiga
      Qrew Member
      3 years ago
      Sorry to jump in this conversation, but that's the only one that seems close to my dilemma!

      I need to have the pipeline loop through 2 fields ( from the updated record). 
      The fields are 2 dates and I need to create a record for each date in an unrelated table. 

      Any suggestions?
      Thank you!


      ------------------------------
      Francesco Spiga
      ------------------------------
      • KristofferKeen1's avatar
        KristofferKeen1
        Quickbase Staff
        3 years ago
        Hey Francesco-
        How are the date fields separated? (with a semi-colon or comma or another delimiter?)

        ------------------------------
        Kristoffer Keene
        ------------------------------