-
ChatterFeed
-
0Best Answers
-
0Likes Received
-
0Likes Given
-
7Questions
-
11Replies
How to make a field required based on a boolean field (checbox)?
Hi,
I thought this is a simple thing to just add the validation rule when "field1_c <> False" in the condition formula.
However, it's not working for me. It seems that it ignores the data that is already entered in that required field. The validation rules error keeps popping up.
I'd like to have the "currency" type field required when the "checkbox" field is enabled (True).
How do you set this in the validation rule?
Thanks,
Lia
- manlia
- July 14, 2010
- Like
- 0
- Continue reading or reply
Validation rules on picklist field depending on certain Stage
Hi All,
I'm trying to create a validation rules on a "picklist" field based when certain opportunity stage is selected.
I couldn't find anything similar to this issue.
For example:
I have a picklist field called "Primary Reason" that is required when an Opportunity Stage "Lost" or "Award" is selected (which is also a picklist field). I couldn't figure out the syntax since both of these are picklist fields.
Any help is appreciated.
Thanks!
manlia
- manlia
- April 13, 2010
- Like
- 0
- Continue reading or reply
Color formula
Hi,
Is there anyway to do a formula based on colors (not the traffic light image)?
I need to have more than 3 colors to show depending on the Rating Status, such as Gren, Yellow, Red, and Purple to show these colors when the rating is selected for each one.
Thanks,
Lia
- manlia
- March 29, 2010
- Like
- 0
- Continue reading or reply
How to use CASE and BEGINS for Picklist field
Hi,
How do you combine a CASE function with BEGINS for certain characters in a picklist field?
Below is the formula that is working now:
CASE( Industry_Size_Tier__c , "1_Tier 5", -1 , "2_Tier 4", 0, "3_Tier 1/3_Tier 2/3_Tier 3",1,0)
basicaly it returns:
If "1_Tier 5" selected, it will return number -1.
If "2_Tier 4" is selected, it will return number 0.
If "3_Tier 1/3_Tier 2/3_Tier 3", it will return number 1.
I'd like to simplify and possibly reduce the compile characters if I could just use the "BEGINS" function using the common characters which BEGINS with "3_" strings instead of spelling out all the "3_Tier 1/3_Tier 2/3_Tier 3"strings for the last expression above.
Please HELP.
Thanks,
Lia
- manlia
- March 08, 2010
- Like
- 0
- Continue reading or reply
External Attachment - Salesforce Labs
- manlia
- December 11, 2007
- Like
- 0
- Continue reading or reply
Project Management Apps
- manlia
- December 07, 2007
- Like
- 0
- Continue reading or reply
Project/Issues Management - Custom Objects
- manlia
- August 10, 2007
- Like
- 0
- Continue reading or reply
How to make a field required based on a boolean field (checbox)?
Hi,
I thought this is a simple thing to just add the validation rule when "field1_c <> False" in the condition formula.
However, it's not working for me. It seems that it ignores the data that is already entered in that required field. The validation rules error keeps popping up.
I'd like to have the "currency" type field required when the "checkbox" field is enabled (True).
How do you set this in the validation rule?
Thanks,
Lia
- manlia
- July 14, 2010
- Like
- 0
- Continue reading or reply
Validation rules on picklist field depending on certain Stage
Hi All,
I'm trying to create a validation rules on a "picklist" field based when certain opportunity stage is selected.
I couldn't find anything similar to this issue.
For example:
I have a picklist field called "Primary Reason" that is required when an Opportunity Stage "Lost" or "Award" is selected (which is also a picklist field). I couldn't figure out the syntax since both of these are picklist fields.
Any help is appreciated.
Thanks!
manlia
- manlia
- April 13, 2010
- Like
- 0
- Continue reading or reply
Color formula
Hi,
Is there anyway to do a formula based on colors (not the traffic light image)?
I need to have more than 3 colors to show depending on the Rating Status, such as Gren, Yellow, Red, and Purple to show these colors when the rating is selected for each one.
Thanks,
Lia
- manlia
- March 29, 2010
- Like
- 0
- Continue reading or reply
How to use CASE and BEGINS for Picklist field
Hi,
How do you combine a CASE function with BEGINS for certain characters in a picklist field?
Below is the formula that is working now:
CASE( Industry_Size_Tier__c , "1_Tier 5", -1 , "2_Tier 4", 0, "3_Tier 1/3_Tier 2/3_Tier 3",1,0)
basicaly it returns:
If "1_Tier 5" selected, it will return number -1.
If "2_Tier 4" is selected, it will return number 0.
If "3_Tier 1/3_Tier 2/3_Tier 3", it will return number 1.
I'd like to simplify and possibly reduce the compile characters if I could just use the "BEGINS" function using the common characters which BEGINS with "3_" strings instead of spelling out all the "3_Tier 1/3_Tier 2/3_Tier 3"strings for the last expression above.
Please HELP.
Thanks,
Lia
- manlia
- March 08, 2010
- Like
- 0
- Continue reading or reply
Salesforce.com Developer needed in Jakarta, Indonesia
- Personnel database, including payroll
- Daily field reporting system, for field supervisors to report their daily activities
- Equipment maintenance tracking
- Tracking of inventories at various locations worlwide
- Reporting in accordance with our Quality, Health, Safety and Environmental (QHSE) policies
- And various other functions
We are looking for a Developer who would be interested in working in Jakarta, Indonesia where our international office is located. We can provide an attractive tax-free salary and benefits. Please contact Diederik Zwager at Tel. +62-811-190248 or contact@airdrilling.com
- dzwager
- May 01, 2008
- Like
- 0
- Continue reading or reply
Project Management Apps
- manlia
- December 07, 2007
- Like
- 0
- Continue reading or reply