Note: Salesforce has a standard VLOOKUP function but has limited functionality, this approach helps overcome those without code.

Process Builder and Flows are recent automation engines provided by Salesforce, they have been around for a while but haven't been used widely i believe (probably developers tend to stick with Apex Triggers and Workflow rules as they are used to it)

The use case below shows you how you could use these two together to solve a simple scenario which as a developer we tend to solve with Apex Code.

Scenario:

Everytime a Product2 record is updated, i have to query if this product exists in a custom object (Exempted parts) and based on the result update a boolean field on Product2.

Solution:

STEP 1:

Create a Flow (Product2_Validate_Exemption)

STEP 2:

Create a Process and call the flow every time a product2 record is updated.

Using a standard lookup field on the user object, Salesforce does not allow you to lookup a user who is of the license type 'Chatter Free'.

Solution:

Although you cannot use a standard UI to update the user lookup field with a chatter free user, you can update the field through the API. This means that we could use a visualforce page to populate the lookup field.

Assumptions:
We will use a custom type ahead advanced search component.
We will use a custom field 'Chatter Free user lookup' on the account object.

Lightning Experience / Lightning UI:

A while back salesforce released this very cool next generation user interface called the Lightning Experience. In addition to the entire revamp of the look and feel, this also added additional features like the 'Opportunity Kanban', the 'Assistant' etc.

Lightning Experience can be turned ON at the profile level, or for individual users using permission sets.

Where to learn more?

Lightning Design System:

Lightning Design system is a front end framework for developing web applications. Using the Lightning Design system you could design visualforce pages or standalone web pages that look and feel the same way as the Lightning UI. A few pointers.

Lightning Design system could be though of as an equivalent to 'Twitter Bootstrap'.

Where to learn more?

Lightning App Builder:

The Lightning App builder is a drag and drop tool to build lightning pages. Salesforce offers a few components by default, including 'Recent Items', 'Assistant', 'List View' etc. In addition you can create your own custom components using the Lightning Design system, or use third party components supplied by AppExchange applications like SKuid

LIVE One-On-One Courses:

Aimed at providing a personal training experience, this webinar based training provides personalized training for your specific needs. Please fill the form below to know more about fees, class duration and topics covered.