Hello,

Can someone please help me with my criteria?

I am trying to create a workflow that will send an email only when the contact status = active and when the profile is not = to "non-us sales"

And company_level__c or general_access__c are changed.

However, when I test the formula as I have it listed below, it will fire even when the contact status is = to inactive but only when I make edits to the general_access__c text field.

Do I need to include an OR in between the 2 ISCHANGED commands?

IF (ISNULL($Profile.CreatedDate), false, true) &&
ISPICKVAL(Contact_Status__c , "Active") &&
NOT ($Profile.Name = "non-us sales") &&
ISCHANGED(Company_Level__c) ||
ISCHANGED (General_Access_Notes__c)

Your help is appreciated!

~Rox

This is my first trigger. I am not sure how to do the test class.

Any help would be greatly appreciated!

trigger setAccountOwnerName on Account (before insert, before update)

{       Map<Id,String> userMap = new Map<Id, String>();

        for (User u : [Select Id, Name From User]) {

                userMap.put(u.Id, u.Name);

        }

        for (Account a : Trigger.New) {

               a.Owner_Name__c = userMap.get(a.OwnerId);

        }

}

Hello,

I am trying to create a validation rule and I have not done very many. Please help.

IF Text_Field_A__c is not blank, THEN Picklist_Field_B__c OR Checkbox_Field_C__c can not be blank.

I am having trouble figuring out how to encompass the OR statement.

Is this even close?

And(
 Text_Field_A__c ,
NOT ISNULL (ISPICKVAL(Picklist_Field_B__c, "") ,
OR NOT ISNULL (Checkbox_Field_C__c)
)

Thank You!

Hello,

Can someone please help me with my criteria?

I am trying to create a workflow that will send an email only when the contact status = active and when the profile is not = to "non-us sales"

And company_level__c or general_access__c are changed.

However, when I test the formula as I have it listed below, it will fire even when the contact status is = to inactive but only when I make edits to the general_access__c text field.

Do I need to include an OR in between the 2 ISCHANGED commands?

IF (ISNULL($Profile.CreatedDate), false, true) &&
ISPICKVAL(Contact_Status__c , "Active") &&
NOT ($Profile.Name = "non-us sales") &&
ISCHANGED(Company_Level__c) ||
ISCHANGED (General_Access_Notes__c)

Your help is appreciated!

~Rox

This is my first trigger. I am not sure how to do the test class.

Any help would be greatly appreciated!

trigger setAccountOwnerName on Account (before insert, before update)

{       Map<Id,String> userMap = new Map<Id, String>();

        for (User u : [Select Id, Name From User]) {

                userMap.put(u.Id, u.Name);

        }

        for (Account a : Trigger.New) {

               a.Owner_Name__c = userMap.get(a.OwnerId);

        }

}

Hello,

I am trying to create a validation rule and I have not done very many. Please help.

IF Text_Field_A__c is not blank, THEN Picklist_Field_B__c OR Checkbox_Field_C__c can not be blank.

I am having trouble figuring out how to encompass the OR statement.

Is this even close?

And(
 Text_Field_A__c ,
NOT ISNULL (ISPICKVAL(Picklist_Field_B__c, "") ,
OR NOT ISNULL (Checkbox_Field_C__c)
)

Thank You!