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...
Forum Discussion
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
------------------------------
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
------------------------------
Hey Francesco-
How are the date fields separated? (with a semi-colon or comma or another delimiter?)
------------------------------
Kristoffer Keene
------------------------------
How are the date fields separated? (with a semi-colon or comma or another delimiter?)
------------------------------
Kristoffer Keene
------------------------------
- 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
------------------------------- If it's just a single date in 2 different fields, then I would just have 2 Create Record steps, 1 step for the first field and create a new record in Table A, and another step for the 2nd field and create a new record in Table B.
You could also have 2 different pipelines be triggered off the two different fields and then the next step creates a different record based on the respective date fields.
However, if you are looking to loop through a concatenated field and say the data is separated via a semi-colon, then 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.
Hope that helps,
Kris
------------------------------
Kristoffer Keene
------------------------------- I probably should have clarified earlier in my 1st message :( sorry...
I am trying to loop through those 2 dates and create new records for all the dates in between them.
Example: 8-23-2022, 8-27-2022
This will create 5 records in a new table (8/23,8/24,8/25,8/26,8/27)
How would you manage this use case via pipelines?
------------------------------
Francesco Spiga
------------------------------