Pipelines | unique | list
Hello,
I have a parent table and a child table I am working with.
The parent table has a field called [CList Master (Pipeline generated)]
The child table has a field called [Clist current page...
Forum Discussion
If it were me - I would make a Pipeline that instead of trying to combine the clists into the parent record via PIpeline, I would instead make a Pipeline or webhook that would break the clist in your child into a different child table to break out each field into it's components. So if you child record has a Clist of 1.5.17.34 - I would make a child table under it and create 4 records with a single field of FID and each record having the value:
Record 1: FID 1
Record 2: FID 5
Record 3: FID 17
Record 4: FID 34
Your other option could be instead of entering the clist as a string - just enter the clist into a grid edit and enter each field as it's own row.
The reason I say that - is you can then relate these records directly back to the original parent and use the summary combined text to summarize all of those FID records.
------------------------------
Chayce Duncan
------------------------------
That's an interesting thought. Makes sense since the summary field wouldn't duplicate values on the parent table. My brain is having a hard time figuring out how it would take the [Clist current page] and parse out the values to capture 1.5.17.34 on all separate records. Or would this have to be jinja2 saying if this field is not null, then FieldID
------------------------------
Shane Miller
------------------------------
You could do a Jinja loop in Pipelines and split the clist in your record by the decimal and create a record for each in the loop. Are you the one configuring these clist entries or do you have individual users doing it? If it's just you, I would just scrap the Pipeline and put an embedded grid edit on the form when you're filling it out and just itemize the fields you want yourself directly into Grid Edit. You can then summarize the items into your child to show the clist instead of typing it in.
------------------------------
Chayce Duncan
------------------------------Unfortunately this would have to be a dynamic process and not a manual one, if I understand your question correctly.
I'll look into some jinja documentation and figure out how to use the split func to create separate records.
Thank you for your time
------------------------------
Shane Miller
------------------------------After a deep dive into Jinja2 and Pipelines, I finally figured it out. phew.
Hopefully this helps someone down the road.
Please see attached:
------------------------------
Shane Miller
------------------------------