tag:blogger.com,1999:blog-826409388179453463.post8616001900384705881..comments2023-05-26T06:55:27.425-07:00Comments on Salesforce Unlimited: Identify Ultimate Parent in an Account HierarchyAnonymoushttp://www.blogger.com/profile/06829141799899469516noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-826409388179453463.post-62799793965996142832021-02-25T07:26:36.315-08:002021-02-25T07:26:36.315-08:00Not sure how you it worked for 20 hierarchy levels...Not sure how you it worked for 20 hierarchy levels for you. When I ran the batch it populated only upto 7 levels :(Anonymoushttps://www.blogger.com/profile/06466277029598477018noreply@blogger.comtag:blogger.com,1999:blog-826409388179453463.post-50329507955124974232017-12-05T03:34:21.721-08:002017-12-05T03:34:21.721-08:00Hello Andrée-Anne,
IF(LEN(Parent.Name) < 1, Na...Hello Andrée-Anne,<br /><br />IF(LEN(Parent.Name) < 1, Name, <br />IF(LEN(Parent.Parent.Name) <1, Parent.Name, <br />IF(LEN(Parent.Parent.Parent.Name) < 1, Parent.Parent.Name, <br />IF(LEN(Parent.Parent.Parent.Parent.Name) < 1, Parent.Parent.Parent.Name,<br />IF(LEN(Parent.Parent.Parent.Parent.Parent.Name) < 1, Parent.Parent.Parent.Parent.Name,<br />IF(LEN(Parent.Parent.Parent.Parent.Parent.Parent.Name) < 1 , Parent.Parent.Parent.Parent.Parent.Name, <br />IF(LEN(Parent.Parent.Parent.Parent.Parent.Parent.Parent.Name) < 1 , Parent.Parent.Parent.Parent.Parent.Parent.Name,<br />IF(LEN(Parent.Parent.Parent.Parent.Parent.Parent.Parent.Parent.Name) < 1 , Parent.Parent.Parent.Parent.Parent.Parent.Parent.Name,<br />IF(LEN(Parent.Parent.Parent.Parent.Parent.Parent.Parent.Parent.Parent.Name) < 1 , Parent.Parent.Parent.Parent.Parent.Parent.Parent.Parent.Name,<br />IF(LEN(Parent.Parent.Parent.Parent.Parent.Parent.Parent.Parent.Parent.Parent.Name) < 1 , Parent.Parent.Parent.Parent.Parent.Parent.Parent.Parent.Parent.Name, "Ultimate Parent Beyond 10 Levels"))))))))))<br /><br /><br />This formula returns Parent name as text.<br /><br />Hope this will help<br />WShttps://www.blogger.com/profile/14116271758608639764noreply@blogger.comtag:blogger.com,1999:blog-826409388179453463.post-26015018385691562642017-11-27T13:27:27.415-08:002017-11-27T13:27:27.415-08:00Thanks for this article.
I used #1 formula on the ...Thanks for this article.<br />I used #1 formula on the account object.<br /><br />Then I wanted to have a validation rule that would compare the account name with Ultimate Parent Account.<br />It doesn't work because one is URL and the other text.<br /><br />I saw you noted that this formula could be updated to return text instead.<br /><br />Would you have an example of that by any chance? I can't seem to figure this out.<br /><br />Thanks a lot!<br />Andrée-AnneAnonymoushttps://www.blogger.com/profile/00651464239024319924noreply@blogger.comtag:blogger.com,1999:blog-826409388179453463.post-75132451656516808042017-04-11T16:04:19.802-07:002017-04-11T16:04:19.802-07:00Hello,
Yes, of course. New code to "push som...Hello,<br /><br />Yes, of course. New code to "push some of the field values of the ultimate parent account to all its children accounts" can be added. <br />Please Contact Us (you can use the form above), provide details and we will estimate the scope of work.<br />Looking forward to your response.<br /><br />Regards,<br />WebSolo Team<br />WShttps://www.blogger.com/profile/14116271758608639764noreply@blogger.comtag:blogger.com,1999:blog-826409388179453463.post-16149492106906802702017-04-11T15:34:33.874-07:002017-04-11T15:34:33.874-07:00Thanks!Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-826409388179453463.post-70997740000202666392017-04-11T14:26:12.698-07:002017-04-11T14:26:12.698-07:00Is there a way to add code to this scheduled job t...Is there a way to add code to this scheduled job to push some of the field values of the ultimate parent account to all its children accounts when this update is made?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-826409388179453463.post-31471114055281589472017-01-26T06:41:12.793-08:002017-01-26T06:41:12.793-08:00Hello Bob,
you can run batch using the Develope co...Hello Bob,<br />you can run batch using the Develope console:<br />execute follow code in execute anonymous window<br />Database.executeBatch(new NAME_OF_BATCH_CLASS(), INTEGER_SIZE_OF_BATCH);WShttps://www.blogger.com/profile/14116271758608639764noreply@blogger.comtag:blogger.com,1999:blog-826409388179453463.post-35870329125820199972017-01-25T10:05:03.872-08:002017-01-25T10:05:03.872-08:00Is there anyway to kick off the batch job manually...Is there anyway to kick off the batch job manually instead of scheduled? Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-826409388179453463.post-64035211985161552016-10-13T07:26:41.245-07:002016-10-13T07:26:41.245-07:00Thanks Kumar,
Solution #3 (Two components solutio...Thanks Kumar, <br />Solution #3 (Two components solution: synchronous APEX trigger and APEX batch) is pretty powerful and can handle up to 20 (tested) hierarchies. Just modify the code and add more IFs in Batchable Class. Good luck!WShttps://www.blogger.com/profile/14116271758608639764noreply@blogger.comtag:blogger.com,1999:blog-826409388179453463.post-28250854448858276362016-10-13T07:17:14.037-07:002016-10-13T07:17:14.037-07:00Hi, This article is helpful, I have a similar situ...Hi, This article is helpful, I have a similar situation, I have to deal with hierarchies where the maximum level of hierarchy could be any value. Is there a way that we can make this code recursive until we reach the ultimate parent?Anonymoushttps://www.blogger.com/profile/12502061210966030505noreply@blogger.com