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
4 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
------------------------------
Curtis_M's avatar
Curtis_M
Qrew Cadet
4 months ago

Thank you for this! It worked wonderfully!

I had a problem where I have Record A with children, and those children have children. I have record A pulling all the grandchildren they are related to into a summary field. I used your regex match solution to generate a table based on those values. This all ties into a rather complex cross-reference conditional selection workflow.

The only change I made was the order of where the Prepare Bulk Upsert step went:
A: Search Records in Table 1; Filter: [Multiselect field] IS SET
B: Prepare Bulk Upsert for Table 2
   Loop FOR EACH A:Search Record
      C: Match Regex to look at the multiselect field
         Loop FOR EACH C:Match Regex
            Create Upsert for Step B
D: Commit Upsert

This way I only have a single upsert action that happens outside the loops. This works very well for what I need to do since I'll want the table to reflect daily what the updated grandchild list for the Records A in Table 2.