Update Contact Address When Source = Cvent

Today we are going to create a process that updates the Contact Mailing Address when getting an event registration from Cvent (Event Management Software).

Salesforce Process Automation Tool: Process Builder.

Two things to have in consideration:
1. Street 2 is being captured in a Custom Contact field.
2. Mailing Address (Data Type = address) is a Compound Field.

What is a Compound Field?

Compound fields group together multiple elements of primitive data types, such as numbers or strings, to represent complex data types, such as a location or an address. Compound fields are an abstraction that can simplify application code that handles the values, leading to more concise, understandable code.

Mailing Address is a compound of the following fields: Mailing City, Mailing Country, Mailing Geocode Accuracy, Mailing Latitude, Mailing Longitude, Mailing State/Province, Mailing Street, Mailing Zip/Postal Code.

Steps

  1. Create a Contact Custom Field called “Mailing Street 2”.
  2. Map Cvent “Street 2” Contact field to Salesforce “Mailing Street 2” Contact field.
  3. Create a Process in Process Builder.
    OBJECT
  4. Choose Object: Contact
    NODE
  5. Specify When to Start the Process: when a record is created or edited
  6. Define Criteria for this Action Group: Name your Criteria.
  7. We are going to define two conditions:
    a) Is “Mailing Street 2” different than NULL?
    b) Does “Mailing Street” contain “”Mailing Street 2”?
  8. Customize the logic: 1 AND NOT 2. Please note the “NOT 2″. We are going to update “Mailing Street” only if it is not already part of “Mailing Street”. We need to check on this to avoid concatenating “Mailing Street 2” to “Mailing Street” indefinitely when editing the address/record.
    IMMEDIATE ACTIONS
  9. Name your action.
  10. Record: Contact
  11. Criteria for Updating Records: No criteria—just update the records!
  12. Set new field values for the records you update
  13. Update Mailing Street by using the following formula:
    [Contact].MailingStreet &
    SUBSTITUTE($Label.New_Line, “-“,””)&
    [Contact].MailingStreet_2__c
  14. If you are wondering about this line of code: “SUBSTITUTE($Label.New_Line, “-“,””)&”, please refer to this blog. It explains how to add a line break between “Mailing Street” and “Mailing Street 2”. There’s a known issue with the BR() function, so don’t even try it. It would be a waste of time. I know! It’s a pain.

That’s it! I hope this was helpful to you. Let me know if you have any comments.

BONUS
If you get ever get this error: “The filter logic references an undefined filter”.
It means that you need to reference to all of your conditions when customizing the logic.

PD: I dedicate this blog post to my 7 year old daughter who is always reminding me and encouraging me to update my blog. ❤️

Update Salesforce Lead and Contact Email Opt Out Field from Mailchimp Contact’s Subscription Status with Process Builder.

Did you install the Mailchimp Integration App in your Salesforce Org?

It helps you managing your Mailchimp subscribers from Salesforce leads and contacts, upload Mailchimp subscribers as Salesforce leads, build segments in your Mailchimp audience, and view Mailchimp campaign activity and reports in Salesforce.

But! What happens when a subscriber’s subscription status changes from a Mailchimp audience?
When a contact’s subscription status changes from a Mailchimp audience, their subscription status appears on the Mailchimp Membership Visualforce page inside a Contact or Lead record but it doesn’t mean that the Email Opt Out field on their Salesforce Contact or Lead got updated.

This is what Mailchimp says about it: “The Email Opt Out field on their Salesforce Contact or Lead record will not change.”

As an awesome Salesforce Admin, how can you automate this task so that you don’t have to periodically update this field manually? Use Process Builder to create a process that does it for you.

This is how my Process works:

Node 1: Member Status has changed to Unsubscribed

Immediate Actions: Update Lead Email Opt Out to True, Update Contact Email Opt Out to True

Node 2: Member Status has changed to Subscribed

Immediate Actions: Update Lead Email Opt Out to False, Update Contact Email Opt Out to False

Node 3: Member Status has changed to Cleaned

Immediate Action: Delete Lead Email
The reason why I’m deleting these emails is because they are considered as Hard Bounces in Mailchimp so there’s no reason for us to keep them.

I hope this helps you and saves you time. To me, this meant more time to dive into “Trailhead” and support my clients in other ways.

Let me know if you have any questions.

Cheers!
Gaby

Giving back to the community by sharing your story

I was recently invited to be part of a panel discussion called “Reshape your Future”. This event was hosted by WHW formerly known as Women Helping Women. WHW is a non-profit organization based in Irvine, CA with the mission of providing the unemployed and the underemployed the skills and resources they need to get and keep a good job.  

Each year hundreds of job seekers participate in programs focused on equipping them to be the most marketable candidate for the job they seek. Their programs include Employment Readiness Workshops, Computer Training, Job Placement Assistance, Employment Retention Support and Professional Apparel.

An amazing group of Salesforce Professionals, including myself, were invited to share our Salesforce story as they were introducing their new Salesforce Trailhead 101 Webinar which starts Tuesday, September 15th. Sharing my story was a pleasure. I hope I inspired someone out there in the same situation as me especially moms who are returning to work after taking a career break to raise their families. (Actually, I know that I did inspire other people, especially women, by the nice emails I received through LinkedIn. Thanks for your kind and empowering words!)

These are some of the things that I’m grateful for after being part of an event like this.

  1. Being a panelist not only inspires the listeners and attendees but it also inspires the panelists and the moderators too. I was inspired and learned from each of the stories I listened to. Their stories motivated me to continue growing in my field. One thing I’m sure about is that no matter the subject, I’ll never stop learning or creating. Life always teaches you something new everyday, especially if you are receptive to listening and seeing the obvious as well as the not so obvious. That’s when you are able to absorb knowledge and feed your brain and even your soul.
  2. I got the chance to strengthen my professional brand by sharing my story and offering advice from my experience, my point of view, from my end.
  3. I’m glad I was able to connect with professionals with many years of experience in Salesforce. Only good things can come from this new connections. Remember, relationships are like plants. You need to water and nurture them on a regular basis for them to survive.

I’m grateful for many other things too but it’s time to sleep in order to be productive tomorrow. Time to let the neurons and brain cells rest. Cheers for good health!

If you’re interested in hearing the webinar and listening to what each of the panelists had to say. Please visit this link: https://t.co/0XbzwiAuGm

To register for Computer Training Workshops through WHW, please call 949-631-2333.

For more information, please contact education@whw.org or 949-631-2333 x1346.

And share it with someone who you think might benefit from it. Because sharing is caring!

Thanks,
Gaby

Preparing for Your Salesforce Admin Certification

I wanted to share with you a list of things that helped me prepare for my Salesforce Admin Certification.  

  1. I registered for the Salesforce Trailhead Virtual Bootcamp for Administrators course through Career Circle. It’s a prescriptive, expert-led training program that fast tracks you to the Salesforce Certified Administrator certification. This is where I got introduced to Trailhead and where my adventure with Salesforce began.
  2. I continued reading on Trailhead as much as I could after the course. I completed the “Build Your Admin Career on Salesforce” Trailmix by Salesforce Trailhead.
  3. I completed all the Admin and App Builder Supersets. Five Super-badges in total. I think you would be fine completing just the Admin superset (Three Superbadges) before your exam but it never hurts to learn more. I highly recommend working on Trailhead Projects and Superbadges. Hands on experience is crucial to your success. 
  4. I watched all of the Trailhead Live videos under the title “Preparing for Your Admin Certification”. All of the instructors do an amazing job at explaining the concepts and giving you tips for the exam. My favorite instructors are: @Caitlin Nguyen and @Mari Greenberg. Their teaching method is very clear and on point.
  5. I watched the “Who Sees What” series on Salesforce Help instead of watching it on YouTube just because it’s in order! Watching it chronologically makes a huge difference when learning about the layers of “Security”. I understood it in one shot.
  6. I went through each section and bullet point of the exam content and read the technical documentation of each topic under Salesforce Help. This is the link: https://help.salesforce.com/home Trailhead is the fun way to learn. There’s no doubt about that especially when you see confetti falling all over you. But if you like to read just the technical documentation go to the link I mentioned above. The amount of information can be overwhelming but I promise it will be very useful to you not only for the exam but for when you work as a Salesforce Admin.
  7. I attended the WEBINAR: Preparation for Your Administrator Certification (CDW-101) offered by Salesforce. You are not allowed to record it so I made sure to take lots of notes. I heard @KevinCorcoran’s presentation and I really liked it. The examples, questions and scenarios that he presented were comparable to the exam questions. He does a very good job of explaining the best answer.

After doing all of those things I got a great understanding of the concepts as a whole and gained experience with the platform. I knew I was not missing pockets of information here and there and felt confident on the day of the exam. I’m not going to lie, I was a bit nervous but I passed! It’s a big accomplishment!

On to the next one: Platform App Builder

I hope you find this information helpful and that you pass as well. Good luck! Shout me out when you do. I would be happy to celebrate your success!

Breaking into Tech

My family and close friends know my story very well but I wanted to put it in writing hoping that it encourages other moms to upscaling into tech, upskilling and reskilling. 

A few days ago I was asked to put together a short bio (my success story) and this is what I came up with:

Gaby has a Bachelor of Science (BS), Computer Software Engineering degree with experience as a Web Developer and Support Manager. She is currently re-entering the tech world (after taking a career break to raise her children and dabble as an artist) with the support of the partnership between Salesforce and CareerCircle which is designed to bring Trailhead training to new Trailblazers all across the United States. 

She successfully got certified as a Salesforce Administrator and reached Ranger Ranking during the midst of the COVID-19 pandemic. She is currently supporting a Blockchain and Digital Assets start-up by implementing Salesforce, managing the CRM, and training their users on the platform.

Gaby has recently started a blog named “The Creative Trailblazer – Trying to find Work-Life Balance” which can be found at the following link: thecreativetrailblazer.com She will be writing about two topics that she is passionate about, Salesforce and Art. 

Yes, that is my story summed up in a few lines. I’m in the midst of a transition in my life and I’m working hard to make it work and have a great start. I work and learn new skills every day. The same way as my daughter practices for a gymnastics competition or the guitar, or as my youngest daughter practices violin. Every day is about hard work, dedication and determination. 

Let’s rewind and go back to the moment when I decided that it was time for me to return to my career. I taught my kids how to fly so now it’s my turn to fly higher along with my husband and our two girls. I never stopped flying. I was just devoted to motherhood, bonding with my daughters, painting, creating, traveling and doing many other fun things that life has to offer. 

Ok, so what now? I’m free as a bird with a degree under my belt. After a deep introspective analysis of myself I decided to do what I know and what I like. Restarting my career in technology was the path.  Probably one of the hardest industries to restart a career. After some research, I came across a few good options of which Salesforce was the one that resonated the most with me. Why? Because of their culture and Trailhead

Salesforce builds its culture around the spirit of Ohana, which means “family” in Hawaiian. Their values consist of Trust, Customer Success, Innovation, Giving Back, Equality, Wellness, Transparency and Fun .

“Trailhead is a learning experience platform — a library of educational content that you can access whenever you like. You can choose from various topics to learn new skills at your own pace. Salesforce continually adds content to Trailhead so there’s always something new to learn. Trailhead helps you gain new skills and hone existing ones. Trailhead is gamified with assessments that demonstrate your skills and badges and points that illustrate your progress.” Trailhead is the fun way to learn. That’s all you need to know for now.

Being certified is the quasi ultimate goal of the continuous Training and Learning process. Once certified, you can start thinking about applying for jobs and being more noticeable in this huge spectrum of talented professionals. 

I’m not going to lie, it’s not an easy path. I’m talking about everything that involves returning to work. Making up your mind, studying, passing the exams, applying for jobs, going through rejection, reset and continue. Breaking into technology, as a professional  that’s been out of work for years, is hard and even harder if you factor in the unemployment crisis that COVID-19 has caused. Simply getting any job, much less your dream job, is the hardest part. But that’s why I am writing this blog. Because returning to work is a process. I want to make this blog part of my process. So if you like, tag along and see what the future holds for me. 

Let’s start with Personal Branding as apparently that’s what I need to focus on. I grew up in a culture where kids/students and future professionals were motivated or taught to sell themselves by putting their best foot forward. I’m not saying it’s still like that in my home country but that’s what it was like growing up. Being modest and humble was what I was taught. Throughout out the years, I’ve learned that it’s Ok to brag about your own accomplishments and successes . It helps get you to the place where you will feel successful and thrive as the valuable person/professional that you are. One thing that comes to my mind at this point is “Capitalism” as not only are products marketable but professionals are as well. 

So this is my contribution into creating my personal branding today. Most of all, this is the first step to breaking into technology, making a difference in my life, restarting my career, getting inspired and hopefully inspiring others. Until next time…