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
PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
@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
      ------------------------------
      • FrancescoSpiga's avatar
        FrancescoSpiga
        Qrew Member
        3 years ago
        Thanks for your quick reply Kris. 

        Well, I have the two dates in 2 separate fields. 
        But I could concatenate them in a formula text field with either a comma or a semi-colon... doesn't really matter at this point. 
        But it seems that in order to use "Find All Matches to a Regex" I need to have a single string to work with, correct?

        Although, the real question is: How do I loop between those 2 values?

        Thanks again for your help. 

        ------------------------------
        Francesco Spiga
        ------------------------------