Ask Search:
Joshua HricJoshua Hric 

Compiling a picklist value for multiple child to parent

Business Requirements: I am attempting to compile all states (existing picklist value where they select one state) from a series of child records, and then combining them into a single text line of states a record covers.  
Issues to resolve: 1) Finding a method to an extract non-numerical
                                value from multiple child records to a parent
                                record
I am fine to building out all formulas and automation methods needed.
 
Best Answer chosen by Joshua Hric
Mayank SrivastavaMayank Srivastava
Joshua, a Process and Flow should suffice for this requirement. Your Process would fire whenever a child record is created or edited and would then launch a Flow which would loop through all the child records related to the Parent, concatenate all state values from the children and dump them into a text field on the Parent.

The key here is to make sure that the Flow always loops through all child records and outputs a brand new string with the concatenated values. This is an interesting idea for a blog post ( since I have other similar questions ) and I would have it out sometime soon.

All Answers

Sunil SarillaSunil Sarilla
Hi Joshua,
the simplest thing to do would be be an Apex Trigger.
I am assuming you are looking for a declarative based solution, if you are open to using third party tools or apps.
I would recommend you to look into one of the below apps
Rollup Helper
Lookup Declrative rollup summaries tool
both tools will allow you to rollup the text fields from child records into a text field on the parent object.
I have used Rollup Helper to do the same, the free version will allow you to rollup 3 fields.

You could do try something with PB but it will break once you delete a child record or the city name n one of the child record is changed.
May be you could do something with PB and Flow (let me try this)
 
Mayank SrivastavaMayank Srivastava
Joshua, a Process and Flow should suffice for this requirement. Your Process would fire whenever a child record is created or edited and would then launch a Flow which would loop through all the child records related to the Parent, concatenate all state values from the children and dump them into a text field on the Parent.

The key here is to make sure that the Flow always loops through all child records and outputs a brand new string with the concatenated values. This is an interesting idea for a blog post ( since I have other similar questions ) and I would have it out sometime soon.
This was selected as the best answer
Joshua HricJoshua Hric
Thank you for the recommended tools Sunil.  I will take a look at them and see if they work within the solution I create. Mayank, that seems to work in theory. It will take time to create and perfect the loop, but it seems that it would be supported by the current funtionality of PB and Flow.