You need to sign in to do that
Don't have an account?
Temurif
Getting Names of a Related object on a Text field of Parent
I have a custom object (Properties). Properties are owning another custom object (Property Unit).
Property Units have lookup fields which are (Tenant) and (Landlord).
A property owns about 40 units on average. So we have 40 different tenants.
I want to display list of Tenants on a text field on Property upon each new update. Is there a way to do it?
Hi Temurif:
What you need is to roll up a text field (by concatenation) from child to parent object.
I know two options
1. If you want to invest effort on Apex development, you can write Apex Trigger.
2. If not, you can use an Appexchange App called "Rollup Helper" to achieve it.
Rollup Helper has a free community edition and paid enterprise edition. The only difference is that the paid edition performs the update in real time. The free edition can be either manually triggered or scheduled.
However, you have another major constraint with your scenario.
In order to put a text field into a Salesforce report, it can have max. 255 char. I guess that you will exceed this limit if the parent has 40 children.
In addition, even if you could put such long text in a report, it is not readable.
My recommendation is
1. Create a Rollup Summary field in the parent just to count the Child.
2. Provide a good display/reporting solution to show the parent with children (please check out Configero
Grid and MiniGrid App at Appexchange, which has funtion such as real time/inline filter (filter as you type) , group, total, mass edit, mass delete, inline edit. )
Cheers
Bing
I would just like to add some specifics about the capabilities that Rollup Helper will bring to the table with respect to text roll-ups.
1) If you have multiple, duplicate child values for the parent, Rollup Helper will de-dupe these values for you, shortening the amount of text required to be displayed on the parent object's field. In your example above, a landlord wouldn't be repeated for each property.
2) In the Enterprise Edition, Rollup Helper will allow you to schedule or run the roll-ups in real-time.
Rollup Helper is available on the AppExchange here.