Discussions
- General Development
- Schema Development
- Apex Code Development
- Visualforce Development
- Formulas & Validation Rules
- Security
- Mobile
- Force.com Sites & Site.com
- Chatter Development
- Java Development
- .NET Development
- Perl, PHP, Python & Ruby
- Desktop Integration
- APIs and Integrations
- Visual Workflow
- Apple, Mac and OS X
- VB and Office Development
- AppExchange Directory & Packaging
- Salesforce Labs & Open Source Projects
- Other Salesforce Applications
- Jobs Board
- Force.com Discussion Boards
- :
- Developer Boards for Force.com and Database.com
- :
- Formulas & Validation Rules Discussion
- :
- Re: need validation rule
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
need validation rule
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
11-09-2012 02:39 AM
hi all
i need a validation rule for a picklist
i have a picklist with A,B,C,D ,,
i need to the make rule say if A,B are picked then a field is then required
this is what i was trying
1
AND ( (TEXT( Board_1__c ) ='A'), (TEXT( Board_1_Finish__c ) = null) )
This work only for A ,But i cant B in
2
AND
(ISPICKVAL(Board_1__c, "A"),
OR
(ISPICKVAL(Board_1__c , "B"),
(TEXT
(Board_1_Finish__c ) = null) ))
any help would be great
thanks
joe
Solved! Go to Solution.
Re: need validation rule
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
11-09-2012 04:03 AM
AND(OR(text(Board_1__c )="A",text( Board_1__c )="B"),text(Board_1_Finish__c )=NULL)
This should solve your query .
/*If this post answers your query mark it as resolved*/
Re: need validation rule
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
11-09-2012 04:23 AM
fair play to you that worked perfect
thanks
joe
need validation rule
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
12-07-2012 01:41 AM
how to write validation rule for this:
Make the Reverse Bingo fields required on closing a case if:
(1) Account_Authorization__c contains RASP
(2) Account.Type = SI, System Integrator, Service Provider
(3) Type <> Support Site Admin, License request
((1) OR (2)) AND (3)

