FieldValue() VS LookupValue() functions
In this workflow rule, it has a lot of LookupValue(), and in many cases I tend to use a lot of JoinFieldValue() functions.In understand the possible impact of using those functions very often.
Given this workflow rule:
[<IndexedPick1>]=LookupValue("OCC_INDEX_CUST_LOV_OPTY_1", "Asia Pacific") AND (JoinFieldValue('<User>',[<OwnerId>],'<PersonalCountry>')="Australia" OR JoinFieldValue('<User>',[<OwnerId>],'<PersonalCountry>')="New Zealand") AND [<plDivision_ITAG>]=LookupValue("OCC_CUST_LOV_OPTY_1", "Rosemount Measurement") AND [<OpportunityType>]=LookupValue("OCCAM_OPPTY_SALES_TYPE", "MRO") AND [<Status>]=LookupValue("OPTY_STATUS", "Confirm Need") AND [<plDivision_ITAG>]<>LookupValue("OCC_CUST_LOV_OPTY_1", "Process Systems & Solutions") AND [<plDivision_ITAG>]<>LookupValue("OCC_CUST_LOV_OPTY_1", "Remote Automation Solutions")
Given this workflow rule:
[<IndexedPick1>]=LookupValue("OCC_INDEX_CUST_LOV_OPTY_1", "Asia Pacific") AND (JoinFieldValue('<User>',[<OwnerId>],'<PersonalCountry>')="Australia" OR JoinFieldValue('<User>',[<OwnerId>],'<PersonalCountry>')="New Zealand") AND [<plDivision_ITAG>]=LookupValue("OCC_CUST_LOV_OPTY_1", "Rosemount Measurement") AND [<OpportunityType>]=LookupValue("OCCAM_OPPTY_SALES_TYPE", "MRO") AND [<Status>]=LookupValue("OPTY_STATUS", "Confirm Need") AND [<plDivision_ITAG>]<>LookupValue("OCC_CUST_LOV_OPTY_1", "Process Systems & Solutions") AND [<plDivision_ITAG>]<>LookupValue("OCC_CUST_LOV_OPTY_1", "Remote Automation Solutions")
0