ISBLANK(Close_Date__c) &&
(ISPICKVAL(Status__c , "Closed - Filled") ||
ISPICKVAL(Status__c , "Closed - Not Approved"))
- ISBLANK(Close_Date__c) returns True if the Close_Date__c is blank
- ISPICKVAL(Status__c , "Closed - Filled") returns True if the Value of the Status__c pick list is Closed - Filled
- TEXT(Status__c) = “Closed - Filled” {Same as above}, returns True if the Value of the Status__c pick list is Closed - Filled
- && means both values should be True then only True.
- || means either one of the value is True then only True.
New Batch#100 (10th Nov 2021) - Salesforce Admin + Dev Training (WhatsApp: +91 - 8087988044) :https://t.co/p4F3oeQagK
Tuesday 24 July 2012
Using ISBLANK and ISPICKVAL in Formula fileds of salesforce.com
Subscribe to:
Post Comments (Atom)
Labels
- 15 digit sfdc id (1)
- 18 digit sfdc id (1)
- 5 minutes (1)
- 50 million records (1)
- A logical segment of your organization's data (1)
- a new record has created in patient object (1)
- Access to object in a test class (1)
- account (1)
- actionfunction (1)
- actionregion (1)
- actionstatus (1)
- actionsupport (1)
- Adding a custom button to page layout in sfdc (1)
- adding additional fields apart from the standard field for the search layouts (1)
- Adding fields to Search Layouts in SFDC (1)
- After deleting a record in master object what will happen for the records of junction object in sfdc (1)
- after triggers (1)
- aggregate query (1)
- Ajax Partial Page Updates in visual force (1)
- annotations (2)
- Annotations in SFDC (1)
- apex (44)
- Apex Classes (2)
- Apex Data Loader (5)
- Apex Data Loader errors (1)
- Apex Programs (3)
- apex:component (1)
- assignTo (1)
- Based on picklist selection (1)
- batch apex (5)
- Batchable Apex (1)
- Before event in trigger (1)
- before triggers (2)
- Bot (IBM Watson) with Salesforce Research (1)
- bulk api (1)
- bulk triggers (1)
- call apex method using javascript (1)
- call by reference and call by value in apex (1)
- Callout from APEX Triggers (1)
- Callout Integration and Apex (1)
- CAMPAIGNS (1)
- CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY (1)
- Cascading Style Sheets (1)
- case (1)
- Cast Iron (2)
- Change Case Owner VF Page (1)
- Changing hyperlink from one color to another color (1)
- Clicking on a commandButton multiple times in a row results in action being fired multiple times (1)
- Cloud Computing Basics (1)
- Collections (3)
- configuration (3)
- Controlling Data with the Force.com Platform (1)
- Controlling Recursive Triggers (1)
- copy field values of one object to another object (1)
- Creating a Many-to-Many Relationship (1)
- CRM (1)
- Cross object update trigger test coverage failure (1)
- css (3)
- CSS for changing the color of a hyper link (1)
- custom login page (1)
- Custom settings (1)
- Data Loader batch size (1)
- Data Loader CLI (1)
- Database .Batchable (1)
- Database.Batchablecontext (1)
- Database.executeBatch (1)
- Database.Stateful (1)
- dataloader (1)
- date (3)
- Date Method to get day of the week (1)
- Define and Insert Queues in Apex Triggers and Test Classes? (1)
- Defining a Manual Sharing Rule (1)
- Delete a record in Aura Datatable (1)
- Difference between 15 digit Id and 18 digit Id in Salesforce (1)
- Difference between abstraction and abstract (1)
- Difference between Interface and Abstract Class (1)
- Difference between Sales Cloud and Service Cloud in sfdc (1)
- Difference between salesforce.com and force.com and developerforce.com (1)
- Difference between SOAP and Restful Webservice (1)
- differentiation (1)
- Disable command buttons on click in visualforce (1)
- Dispaly particular field based on the selection of the particular field (1)
- Display pageblocks based on the picklist selection (1)
- Displaying pop-up summaries on hover in visualforce (1)
- Displaying text in td cell in multiple lines Salesforce (1)
- Div and Span html tags difference (1)
- divisions in sfdc (1)
- dml (1)
- dml statements not required for before events in triggers (1)
- DML Validations (1)
- due to one record entire batch will fail (1)
- Dynamic Apex (1)
- Dynamic Visualforce Naming (1)
- Enhanced List in SFDC (1)
- enterprise wsdl (1)
- Entity deleted (1)
- Error (5)
- exchanging data between heterogenious environment (1)
- execute (1)
- external id (1)
- External Style sheet (1)
- Field sets (1)
- finish methods (1)
- fixed headers datatable (1)
- fixed horizontal and vertical headers in datatable (1)
- for others it should be hide (1)
- Force.com GUI (28)
- Formula (2)
- formula fields (1)
- Gantt Chart (1)
- Generate PDF with apex trigger (1)
- Governor Limits (3)
- Governor Limits for single apex class or entire organization (1)
- Hide/show a pageBlock depending upon the button selection (1)
- hierarchical relationship (1)
- how can I execute 200 records each time in Trigger? (1)
- how can we do it? (1)
- How many ways we can call Apex Classes? (1)
- how to access the encrypted field values (1)
- How to create a site using Apex Code (1)
- How to deactivate security token to be enter? (1)
- How to disable inputfield at particular day? (1)
- How to disable/enable all validation rules for data loading (1)
- how to display corresponding pageblock on VF page (1)
- How to disply custom client-side error messages on VF pge (1)
- How to give the Pagereference for the Save and New ? (1)
- how to lock a record? (1)
- How to publish sites using siteforce? (1)
- How to pull values of records modified 7 days ago? (1)
- how to remove a value from list without using its index (1)
- How to send the failure information in a email for the Batch process? (1)
- How to show visual force error? (1)
- I have 1000 records (1)
- I want to retrieve the records of the custom/standard object of the current user (1)
- if we click any button that country information should only display (1)
- If you click on button a text msg should display on vf page (1)
- Illegal assignment from Account List to Account List (1)
- Inline Style (1)
- Inser failed: inactive user (1)
- Integration between Cast Iron and Microsoft SQL Server 2005 (1)
- Internal Style Sheet: (1)
- Invoking Callouts Using Apex (2)
- Is it possible to refer static resources files in formula fields (1)
- Iterable (1)
- java (1)
- Javascript with Visualforce pages (1)
- Latest Versions in SFDC (1)
- Lead (1)
- lead management (1)
- lightning (1)
- List usage in Apex (1)
- List usage in Salesforce (1)
- list views (1)
- lock (1)
- lookup relationship (1)
- Managing the Heap in Salesforce.com (1)
- Manual Sharing Rule in SFDC (1)
- Manually entered Date value in Apex (1)
- many to many relationship (1)
- Map usage in Apex (1)
- Map usage in salesforce (1)
- Mater detail relationship (1)
- maximum trigger depth exceeded MyObject__c trigger (1)
- monthe (1)
- Moving data from sandbox to production (1)
- Moving data from sandbox to production in sfdc (1)
- Moving pick-list values up and down (reordering) in javaScript (Works only chrome (1)
- Multilevel Master-Detail Relationships (1)
- Multiplication pattern with Apex (1)
- not working for Firefox and IE) (1)
- order of execution of triggers (1)
- Organization Wide Defaults (1)
- Organization Wide Defaults.OWD (1)
- outputpanel (1)
- ownerid (1)
- partner wsdl (1)
- passing dynamic content to system.schedule (1)
- Passing parameters between visualforce pages (1)
- Permission Sets (1)
- Permission Sets in sfdc (1)
- PG) we should use manual sharing (1)
- Pick List in VF (1)
- Pick List in Visual Force (1)
- Process Visualizer in SFDC (1)
- Products (1)
- Querying All Contacts from One Account (1)
- Queues in SFDC (1)
- Radio-buttons simple code (1)
- Random Password Generator (1)
- Record level security (1)
- recursive triggers (1)
- regular expressions (1)
- relationships (1)
- Report should be available only to CEO (1)
- Reports (1)
- rest ful (1)
- restful api (1)
- Retrieving information from child to parent incase of standard objects using SOQL (1)
- retrieving month value from date field in apex class/Trigger (1)
- Review Points in SFDC (1)
- Role hierarchy (1)
- Roll Up Summary Fields using Trigger After events (1)
- rollup summary (2)
- rollup summary programatically (1)
- Rollup Summary using triggers (2)
- runas in Dashboard (1)
- salesforce (1)
- salesforce standard object lead (1)
- salesforce standard products (1)
- salesforce.com (1)
- Schedulable Apex (2)
- Schedulablecontext (1)
- Scheduling Batch Class after 6 minutes whenever a batch finish method executed in salesforce (1)
- Scheduling batch class for every 5 minutes using system.schedule method in salesforce (1)
- schema (1)
- security (3)
- security token (1)
- select list in VF (1)
- select list in Visual Force (1)
- self relationship (1)
- Set usage in Apex (1)
- Set usage in salesforce (1)
- sfdc (1)
- SFDC Governor Limits (2)
- sfdc id (1)
- sfdc products object (1)
- Sharing a Record Using Apex (1)
- Sharing Rules (1)
- Sharing Rules in SFDC (1)
- soap (1)
- soap api (1)
- soql (3)
- SOQL contacts (1)
- Spring '16 Important Features (1)
- srinusfdc (1)
- start (1)
- static variables (1)
- string (1)
- substring (1)
- Summer 15 Release Notes Saelsforce (1)
- system.queryException (1)
- system.schedule (2)
- Testing Apex (1)
- The default workflow user in SFDC (1)
- to create custom change owner functionality for the case record (1)
- To disable other checkboxes in a section if one is selected. (1)
- To display all the fields of sObject using Apex and VF (1)
- To make the Sharing Button visible (1)
- To pass the parameters between the VF pages which have different controllers: (1)
- To perform arithmetic operations (APEX) (1)
- To perform arithmetic operations (VF) (1)
- To return to a same page with empty fields in VF (1)
- To share a particular record to a particular user (1)
- Transient (1)
- Translation Workbench (1)
- trigger (6)
- trigger context variables (1)
- trigger on related object field (1)
- Trigger to update a field in parent record once a task is created (1)
- Triggers (11)
- Try to access info. form sObj for which don't have permissions for user using trigger (1)
- uddi (1)
- Understanding Entity Relationship Diagram (ERD) in SFDC (1)
- Upcoming Posts in SFDC (1)
- Update a record on which we are writing the trigger (1)
- Upsert (1)
- Upserting data from Cast Iron to Salesforce (1)
- Usability: Fields and Page Layouts (1)
- Using 'If' condition in formula field of SFDC (1)
- Using Batch Apex to Change the Account Owners (1)
- Using Batch Apex to Change the Account Owners and call it from trigger (1)
- Using case in formula fields of sfdc (1)
- Using Cross-Object Formula Fields and Hyperlinks in formula of SFDC (1)
- Using Data Loader from the command line (1)
- Using Hierarchy Custom Settings in Salesforce (1)
- Using ISBLANK and ISPICKVAL in Formula fileds of salesforce.com (1)
- Using Regular Expressions in SFDC (1)
- Using the Import Wizard in SFDC (1)
- Validation Rules (1)
- Validation Rules in SFDC (1)
- validations (1)
- Visual Force Basic code (1)
- Visual Force Important Points (1)
- visualforce (28)
- VisulaForceError-System.QueryException: List has no rows for assignment to SObject (1)
- vlookup (1)
- We have three country buttons (1)
- web services (6)
- web services integrations (1)
- Whenever Opportunity stagename fieldset to 'Closed Won' (1)
- Workflow and Trigger differences (1)
- Workflow Rules and Approvals (1)
- Workflows is sfdc (1)
- Wrapper Class (1)
- wsdl (1)
- xml (1)
No comments:
Post a Comment