Hi, 

I am trying to write a trigger to fetch all child account name on parent account. But my trigger is pulling only one child account on which we are making chages instead all child accounts. Please advise me on this.

trigger childaccount on Account (after update) {

map<id,Account> map1 = new map<id,Account>();

String str;

for (Account a : trigger.new)
{
if(a.parentId != null)
map1.put(a.parentId,a);
}

List<Account> lstanct = [Select name, ChildAccountName__c From Account where id in: map1.keyset()];

For (Account ac : lstanct){

str = str + ',' + map1.get(ac.id).name;
ac.ChildAccountName__c = str;
}

update lstanct;
}

Hello, 
I am currently having an issue with workflow and was hoping you can help me out. I need a way to make it stop triggering once those tasks have already been created once. 

I currently have a workflow set to trigger a set of tasks as follows:
created, and every time it’s edited
AND( 
ISPICKVAL( StageName , "Pilot Implementation Pending"), 
NOT( ISPICKVAL( PRIORVALUE(StageName) , "Pilot Passed Back For Assistance") ))&& ( Account.Owner.UserRole.Name = "Implementation Team")


Any help would be greatfully appreciated. 

Hi,

 

How can I use person account field PersonHasOptedOutOfFax in the report or use in the formula field also if it is possible.

 

Thanks...

Hi, I need to change the japanese wording for a standard field closedate in opportunity, iam not able to change the wording in translation work bench, i have selected japanese as language and in select component iam not able to find the option for standardfield , could anybody plese help me.......................

Someone asked for help on figuring out a formula to calculate what work week a date falls within, with work weeks starting on Mondays, and I thought I'd share.

 

 

((CloseDate - DATE(YEAR(CloseDate), 1, 1) + (CASE( MOD( DATE( YEAR( CloseDate ), 01, 01 ) - DATE(1900, 1, 7), 7),
0, - 0,
6, - 1,
2, + 2,
4, + 4,
5, + 5,
1, + 1,
+ 3))) / 7) + IF(MOD((CloseDate - DATE(YEAR(CloseDate), 1, 1) + (CASE( MOD( DATE( YEAR( CloseDate ), 01, 01 ) - DATE(1900, 1, 7), 7),
0, - 0,
6, - 1,
2, + 2,
4, + 4,
5, + 5,
1, + 1,
+ 3))), 7) = 0, 0, 1)

 

 Just change CloseDate to the date field in question.