Lookup Vs. Master-Detail: The Real Difference

I have a confession:

For a long time, I never really understood the difference between a “Lookup” field and the “Master-Detail” lookup field. Whenever I needed to create a field that referenced another object, I would read over the Salesforce explanation and then randomly chose one field.

Lookup...or...Master-Detail
Lookup…or…Master-Detail

Over time I discovered various nuances, but the real “Aha!” moment was when I really, really got it.

Simply put, a Lookup field connects 2 objects to each other. For example, a customer can be linked to a store they frequently shop at. This relationship, while helpful to know, does not intricately bind the customer and store to each other. If the store closes down, the customer will still be around and shopping – but in another store. The relationship ends with no affect on either end.

Let’s use a Parent-Child analogy to explain the Master-Detail relationship:

Parent & Child
Parent & Child Relationship

MasterDetail is like a human parent child relationship. Just like a child can not exist without a parent, a Detail (child) record MUST have a Master (parent) record. This strong relationship makes the relationship field required on all records. As well, the child record inherits the same ownership and security (think DNA) as the parent record. Should the Master record be deleted, all the Detail records will be deleted with it (think of going back in a time machine – before the parent was born = no parent, no children).

Similarly, going back to our store, the inventory can have a MasterDetail relationship to the store. If the store closes down, the inventory has no use and and can be deleted. You might chose to send the merchandise to another store which would be called Reparenting in Salesforce (sorry, not detailing that here!).

Hope this helps you navigate object relationships in Salesforce!

Wishing you a wonderful, relaxing, long weekend,
Rachel

LastPass: Making Magic of Passwords

Magic!
Magic!

If you’re anything like me, or even nothing like me at all, you are probably logging into multiple sites each day – several times a day!

On any given day, I can be logging into 4 Gmail accounts and 5 Salesforce instances. Remembering all those usernames and passwords can be quite a task.

Enter LastPass*, a simple application that sits quietly in your browser until you need it. And then the magic happens!

With LastPass, you can save usernames and passwords to just about any website.You can store them in folders and give the saved logins names for easy identification. When you reach a login page, you simply chose the correct login match and login. On a new website or using a new login? No problem – you can save the information on the fly! Also, you LastPass account can work across all your devices. Once installed, you have the same saved logins wherever you are.

While there are other browser extensions that retain passwords (especially for Salesforce), I chose this one not just because it was recommended by a friend*, but also because it can save all types of passwords.

Happy Passwording!

*As of 2014, 84% of consumers say they either completely or somewhat trust recommendations from family and friends about products – making these recommendations the information source ranked highest for trustworthiness.

Disclaimer: I am not advertising or receiving any kickback for this post.

#StruckByLightning – The Lightning Experience

Homescreen of the New Salesforce
Home-screen of the New Salesforce

As the Salesforce community celebrated Adam Seligman’s 16th birthday, thousands of users gathered at 100 locations across the world (with many more viewing it live) to experience the introduction to the Lightning Experience.

I happened to be in New York, so this was my 2nd Salesforce event that I got to attend.  The ambiance, décor and excitement really set the tone for what was to be an incredible announcement. And so it was.

Lightning Experience is more than just a revamped interface. It is a revamp of the entire user experience, setup and the way end users will use the platform. It comes with a sleek, modern feel and real time updates – 2015 here we come!

Here are some of my favorite takeaways:

  • To say it again; the sleek, modern interface is drool-worthy! The tab bar has been replaced with a sidebar and icons for each object, the crisp design is efficiency driven and will really put users ahead of the game.
  •  I love the real time capabilities! Searching for a list view is no longer a struggle – start typing in the name and results will appear! Need to edit a contact? No problem. A pop-up will appear, make the changes and press save. The list will automatically update with the new values. Entering addresses is now powered by Google and will populate as you type.
  • List views retain their awesome capabilities but are more data and results driven! The chart button on the right immediately displays the list view data in various chart formats. And check out the new functionality for opportunities! You can display opportunities in a board which align them according to stage, total the amounts and alert you if there are no related tasks or overdue tasks. More than that, you can create the task right from that page and even more than that….you can drag and drop opportunities as they move through the sales process! Totals will update in real time and totally keep you on the ball.
New Salesforce Opportunity Record
New Salesforce Opportunity Record
  • This Lightning Experience release really focuses on the sales cloud and that is why we are seeing so many incredible changes to the standard sales object. On a general level, each object record has its own layout and design, based on it’s use. The opportunity object was glorified with a highlights panel that indicates the stage, and can be customized to give you relevant tips to guide you through the next steps.
New Salesforce Dashboards
New Salesforce Dashboards
  • Reports & Dashboards are extra snazyy and can leave your head spinning with all the great changes. While creating a report is fairly the same, running it leaves you no doubt that you are experiencing the Lightning Experience. As to dashboards, with the feel of Wave, dashboards components can now be resized and arranged in more than 3 columns! This definitely got a great cheer!
  • The setup/backend is also part of the New Salesforce. Items are now grouped according to their functionality and as always have a quick find search box. No more separation of custom & standard objects

What does this mean to me?

As with any Salesforce release, it is a good idea to prepare and familiarize yourself with the changes to come. While Salesforce Classic (as we knew it until now) will still be supported, you will surely want to migrate your users to a better experience. Thankfully, Salesforce has been preparing for this and already has extensive documentation in place.

Here are some great resources to get you started:

Watch the release

Lightning Experience FAQ

Trailhead – there are 4 trails to blaze!

Sign up for a pre-release org – Currently not available

And of course, get social. Join the discussion. Come to Dreamforce!

A Piece of Heaven: Marshmallow Cream Cake

Cake Photo
Need I say more?

I know this is not Salesforce related, and not even technology related (other than oven usage), but it definitely falls into the more category and it’s part of my playground and so delish, I couldn’t resist sharing!

I discovered this recipe at a relative’s home and instantly loved the variety of flavor and the ease of make yet decorative appearance. Baking it myself reinforced my feelings towards it and made it a instant hit in my home.

Ingredients:

4 Eggs
1 1/2 C. Sugar
2 T. Vanilla Sugar
1 C. Oil
4 T. Cocoa
1 1/2 C. Flour
1 t. Baking Powder

Topping:

16 Oz. Marshmallow Cream
12 Oz. Baking Chocolate
1 1/2 C. Crunch Peanut Butter
3 1/2 C Rice Krispies

Directions:

Beat eggs with sugars. Add remaining ingredients and mix well. Pour into lined cookie sheet and bake at 350 for 25-30 minutes. Let cool.

Spread thin layer of marshmallow cream onto cake and then refrigerate for 1 hour. In double broiler, melt chocolate and peanut butter. Remove from heat and add rice krispies, mixing until completely coated. Spread topping over cake. Chill. Cut into circles or squares.

**Personally, I am not exact on the measurements of the topping. I simply spread the marshmallow cream until there seems to be a sufficient amount. The rest of the topping has yet to fail me if I don’t measure it perfectly.**

THIS CAKE FREEZES AMAZINGLY WELL. I LIKE TO BAKE A FEW BATCHES OF IT, FREEZE IT FOR AN HOUR OR SO AND THEN CUT INTO (SMALL) PIECES. THEN, I PUT IT BACK IN THE FREEZER, READY TO TAKE OUT ON SHORT NOTICE. IT IS DEFINITELY IMPRESSIVE AND GREAT TO GIFT TO OTHERS.

Tasks: Create your Own Reminders (Using Process Builder and Flows)

This post is in collaboration with Gorav Seth who patiently led me step by step to mastering this magic! His blog post includes some screenshots (using the event object) of the steps involved. Thanks, Gorav!

***

Wouldn’t it be great to get a reminder when a task is due…Like, an email straight to your inbox alerting you, ” Hey you! This task is due in an hour!”…Unfortunately, this is not native for Salesforce and that’s when you need to wrap your head around alternative Salesforce capabilities to do what you want. Thankfully, I stumbled upon a thread where this exact issue what being discussed.

In this example, we will create a simple reminder for a task related to a contact.

What we want: An email reminder one hour before a task is due.

What we need to do: Use process builder to launch a flow that will send the email.*

HERE’S HOW

1. Create a flow – Go to Setup>Create>Workflow & Approvals>Flows> New Flow

2. Lookup Task – From the left palette, drag the “Fast Lookup” element onto your canvas (big screen area)

  • Name: Lookup Event
  • Unique Name: Autopopulates
  • Lookup: Task
  • Criteria: Field = Id, Operator = equals, Value = vaTaskId

The value vaTaskId is a new variable you will create to match up the task in question to work with this flow. We will later use it to reference the task in process builder.

  • Variable: sovTask

This time, you are creating an sObject Variable to store the results of the lookup. This is basically a representation of your task, in memory, which you can later reference for the email.

  • Fields: Select the fields that you would like to hold and later reference.
  • Click Ok

3. Lookup Contact – From the left palette, drag the “Fast Lookup” element onto your canvas (big screen area)

  • Name: Lookup Contact
  • Unique Name: Autopopulates
  • Lookup: Contact
  • Criteria: Field = Id, Operator = equals, Value = {!sovTask.WhoId}

Because we have “saved” the task, we can now refer to it’s field and match up the correct contact associated with that task.

  • Fields: Select the fields that you would like to hold and later reference (e.g. FirstName, LastName)
  • Click OK

**Option to have a lookup step to grab the task owner/assigned to info and use that to send the email. For now, we’ll skip it and just assign the email manually.**

4. Send email –  From the left palette, drag the “Send email” element onto your canvas (big screen area)

  • Name: Send Reminder Email
  • Unique Name: Autopopulates

For the body and subject, we will create text templates using variables from the task we previously referenced and held.

  • Add row > Select Email Addresses (comma-separated), and enter the email of the desired recipient (or reference the email of the owner if you have referenced it earlier)
  •  Click OK

5. Connect the screens– Going in order of the screens, click on the little node on the bottom and drag it to the next element. Then go to the first screen (fast task lookup) and click on the little green icon to set it as the first step.

6. Save – Save your flow and give it a name! Ensure that the type is set to auto-launched. Press OK. Close and then activate your flow

There! We have created the flow to send an email reminder….now we need to launch the flow!

7. Open Process Builder – Go to Setup>Create>Workflow & Approvals>Process Builder> New

  • Name: Activate Task Reminder
  • Api Name: Autopopulates
  • Click Save

8. Select the Task object – Click on the rectangle “Add Object” and select task in the right panel.

  • Save

9. Add Criteria – Click on the add criteria Shape. In my example, we want it to fire when the reminder field is checked off.

  • Name: Task Criteria
  • Criteria: Conditions are met
  • Conditions: field = reminder set, operator = equals, type = boolean, value = True
  • Save

10. Schedule the action – In the scheduled action rectangle, click on set schedule.

  • 1 hours before Reminder date/time
  • Save

11. Add the action – Click on add action (below scheduled actions)

  • Action: Select Flows
  • Action Name: Launch Flow Email
  • Flow: Select the flow you just created
  • Set Flow Variables by clicking add row: variable = vaTaskId, type = reference, value = Activity ID
  • Save

12. Activate your flow

That’s it it takes!

Enjoy the wonderful and magical fruits of your labor.

——

* In case you’re wondering why we don’t use Workflow rules, you can’t send email alerts as a workflow action.

—–

Resources:

http://goravseth.clarify-it.com/d/nhpcx4

Top Tip # 2

User Meme

So, you’re a new admin adding users to your organization. But what do all those fields really mean?

Create New user

You enter the first name, the last name, alias auto-populates and then you look at the next field.

Add New User

Email. Easy enough. Enter the new user’s email. Username. Re-enter the email? It might work and it might not. You see, email needs to be an actual existing email that the user can access to activate his account, receive notifications etc. Username, while in an email format, does not have the be a real email. It is a unique login for a user and can not be used in multiple accounts.

User Error

In this scenario, “Rachelnatik@gmail.com” has already been used for another org and is not able to be the username for this new user. We can replace it with unique text in email format and then press save. New user created!

user4

Salesforce Certification: My Journey

With 3 Salesforce Certifications under my belt (and one earned today!), I feel that it’s time for me to share my experiences and paths to this accomplishment. For many, the exam seems daunting and they shy away from it.  Please read on and check out the resources below to find your path to certification.

ADMINISTRATOR: About 9 months after being introduced to Salesforce, I realized that career potential and decided to actively pursue one. I quickly realized that the first step was to become certified. In preparation, I attended the ADM 201 which was a disappointment to me. There wasn’t much that I learned and with the high price, I didn’t feel that the class was worth it. Also, it doesn’t cover all the topics you need for the exam

At the conclusion of the week-long course, I spent 2 weeks reviewing it and the other topics listed in the study guide. I then felt confident to take the exam…..and passed!

DEVELOPER: About 1.5 years later, I started preparing for the Dev 401 exam. It is very similar to the Admin exam so in retrospect I would recommend you do it immediately after. This time, I watched a recorded Salesforce course and reviewed the necessary information. I looked over the study guide, felt that I scored high enough and went for it….and passed!

**Tip: Use the study guide as a…guide. Gauge your knowledge of each topic and give yourself a rating. Once you score over 85% – 90%, you should have sufficient knowledge to pass the test.

ADVANCED ADMINISTRATOR: For this exam, I followed David Liu‘s recommendation. I went though the study guide topic by topic and read the relevant Salesforce documentation on it. Then, I rated my knowledge on each topic. My last step was to go through the flashcards. All this done, I felt ready to take the exam…and passed!

So yes, with lots of studying and prepping, I passed these 3 exams on the first try.

You can do it too!

Tip #1: Review the study guide. I can’t stress it enough. It outlines exactly what you need to know and what percentage of the exam it covers. Adjust your studying accordingly.

Tip #2: Watch videos on topics you’re not familiar with. If you don’t have hands-on experience with a specific feature, it is sometime hard to visualize what you read on it.

Tip #3: Use flashcards and mock exams. While they may not accurately reflect the exams, they will help you think in a question/answer format and probe into areas you may have overlooked.

———–

Resources

Udacity: Intro to Point & Click App Development: Great place to get hands on overview of many Salesforce functions.

Trailhead: Another great place to get aquainted with Salesforce

SFDC99: Guide to Passing all Salesforce Certifications

Charidy.com: The New Crowdfunding

 Launched in the beginning of 2014, this crowdfunding site has run over 380 campaigns,  raising over $24,000 000 for various non-profits. They credit their success to these 3 campaign criteria:

1. Three matchers. That’s right. You need 3 donors (or groups of donors) that will match dollar for dollar all donations received to reach their goal. So if your organization wants to raise $250,000, then you need 3 donors of $62,500 (is my math correct?) to match the rest of the participants. On the flip side, every dollar donated has quadruple impact; $50 becomes $200, $1000 becomes $4000….

2. It’s all or nothing. You reach your goal, you get all the money. Should you not, the funds are returned to the donors.

3. Only 24 hours. Every campaign runs for 24 hours. Any start and finish time. But it’s only 24 hours.

“To date, Charidy.com campaigns have an 100% success rate!”

Why the interest and why the success?

I watched in astonishment as hundreds of charities ran fundraising campaigns with Charidy. My astonishment changed to delight as I watched the funds come in and goals reached. This week, an organization that I support ran such a campaign and I finally got it.

The thrill

The anxiety

The excitement

The tension

The stress

The emotion

The passion

The care.

The support

Because, for only 24 hours, every dollar donated would be matched by three matchers and it’s all or nothing.

Simple and brilliant.

For 24 hours, supporters were glued to their phones and computers, watching the success of the campaign, calling friends and relatives to donate, posting on social media and spreading the word. There was a hype and frenzy that comes about when there is so much at stake. And then we hit the goal and the stress and anxiety left. Elation and exhilaration kicked in.

Another Charidy success.

———————-

Disclaimer: This post is purely my thoughts and not written at the request or behest of any company or organization.

Power of Us Hub: A Love Affair

Like flour is to a cake.

Like water is to a pool.

Like a smile is to a face.

Like the HUB is to NPSP users. Or just non-profit Salesforce users. Or soon to be users.

Seriously.

When I first stumbled through Google some three years ago in search of answers and solutions for my Salesfore org, I came across 2 Google Group forums dedicated to users of the NPSP. It was there that I was first introduced to the wonderful community of Salesforce. There were hundreds of threads on various topics, ideas and solutions for best practices, and a place to connect with other users.

It was at first sight.

Since then, the NPSP community has grown by leaps and bounds (I know, Cliche, right?) and the updates the Salesforce Foundation made to the system are incredible. But to me, the most incredible change is the HUB.

Sooo, what is it?

Its a private community for non-profit users – whether you use the NPSP or not. Its a place to connect, to discover, to learn, to share, to inspire and to be inspired. It’s a place to get answers, discuss solutions and brainstorm ideas. But the first word that comes to my mind is “COMMUNITY“. There is a vibe and family ambiance of caring and helping each other that goes beyond the written words on my screen.

I must admit, that at first I was quite lost. I would login (**Using my regular login!!- no new usernames and passwords to remember!**), look around, get intimidated after a bit, and then logout. All the time. Here and there I would deviate and join a group. And that was it. And the Weekly Chatter Digest was ignored. But slowly, things changed (mostly along with the new interface). I would see a question and think, “Hey, I know the answer to that!” or, “Wow, we had the same problem. What is their solution?” And that’s when I fell in love again. And I joined more discussions, and asked questions, and learned, and reached out. And that’s when I realized the Power of US: Me, you and you and you and you. Yes YOU. All of US together, empowering each other.  

So if you are a Non-Profit User, and have not logged into the HUB yet, do so now. It will be a transforming experience for you and your organization.

——-

According to Salesforce Foundation:

The Power of Us Hub is a one-stop resource center where customers of the Salesforce Foundation can find resources and training specific to nonprofit and higher education users, engage with one-another, and connect with employees, MVP’s in our community, and relevant partners.

  • Ask Questions
  • Answer a Question
  • Collaborate
  • Share resources
  • Access Nonprofit Starter Pack documentation
  • and lots more to come . . .

Login by visiting, https://powerofus.force.com and the logging in with your regular (non-profit) Salesforce username.

Top Tip #1

Challenge:

Display a lookup in a related list. For example, when viewing a Contact record, we wanted to see the Campaign an Opportunity is associated with. Unfortunately, this is not possible using the standard interface.

My Solution:

Create a formula field that populates/references the lookup field (Campaign) and then add that field to the related list (no need to have it in your page layout).

Voila!

Now you can go into the weekend with ease of mind.