Dreamforce is an annual user conference hosted by Salesforce.com in downtown San Francisco, bringing together thought leaders, industry pioneers and thousands of IT professionals. This is Salesforce’s big annual event, in 2016 over 170,000 people descended on San Francisco for the event.
I have spoken at Dreamforce for the past 5 years.
Very excited to say that I will be heading over to India to present at India Dreamin 2017! Looking forward to seeing all the people who I’ve worked with who live in India!!
After the success of my last Automation Hour talk webinar I’m doing it again in Jan 2018! Come learn some advanced features around Process Automation within Salesforce.
Registration Link: http://bit.ly/FPindarJan1918
I had the honour of speaking at the Salesforce World Tour this year with the amazing Stefanie Bialas. She showed us the power of “The Power of One”, this is her blog on really how powerful it is!
Yeaahh, you’ve managed to build some excellent reports monitoring the pipeline of your company or also enabling marketing to contact all your prospects in the DB. And suddenly someone comes along and asks “How many opportunities do we actually have in the pipeline? The record count seems way to high” or “That’s awesome, now I can contact all our prospects. How many companies do we actually contacts?”. So how to address this in order to answer those questions?
You’ve probably noticed by then that the record count for reports like Opportunities with Products or Contacts and Accounts count the total number of child records associated with the parent record. So for opportunities, this is, for example, the sum of each product line item. Or a number of contacts associated with each account. How can you do this now to have a record count of the parent record, counting every record only ones? The answer is, use the Power of One!
Simply described the Power of One is a custom formula which you best create on each object and holds simply the value 1. When you sum it up in a report, 1 will be the result for each line item.
Here now a step by step guide helping you to setup the Power of One. I am taking the account and contact example to demonstrate this here but this works in the same way for all the other objects.
Go to your setup menu and select the object you’d like to count each record separately of. Create a new field:
For Step 2, fill in a name for your newly created field in “Field Label”. With tab, a field name will be created automatically. Number is what you should select as formula return type with zero decimals.
With next you will go to step 3. Now you get to write your formula which will be used to calculate the value you’d like to have displayed in your newly created field. Think again of what the purpose of this field is, we simply want to count the parent record only ones within our reports. And therefore all you need to insert into the formula canvas is 1 as a number:
That was easy, wasn’t it? Now save your newly created field and test it out. For the test go to your report tab and select for our example here “Contacts and Accounts” as a report type. As usual first select the records you want to look at, then group the account field. Now your report will look like this:
As you can see the record count next to each account name counts the number of contacts associated with each account. That’s great to tell how many contacts we will have and can contact, but we won’t be able to answer the question of our Marketing Director how many companies we are contacting this way. Now your newly created superpower formula comes into place. Add it from the side panel with the quick find and drop it onto your report builder. Hoover over your field to open up the menu for the field and select “Summarize This Field”. You will get a window as shown below:
Check the checkbox “Sum” and click on apply. Now save and run your report to see the magic. When you scroll to the very bottom of your page you will now see two numbers. One being the classic record count as we know it, in this case counting each contact held in the report. And a second one which is the SUM of the Power of One for each individual account record. This number is logically lower (or the same) than the total count of the child records and gives you the total of accounts in your report. Yeeaahh!
Now share this with your manager and make yourself a well-deserved coffee.
Stefanie Bialas | ステファニ ビアラス
@schdaephyie
Marketing Operations Europe | NTT Europe
Join me and the rest of the Pardot geeks at Guinness World Records where I demo how to supercharge your Pardot and get near 100% read-rates on your marketing using SMSs!
The ‘Salesforce World Tour London’ is Salesforce’s largest Sales event in London. This yearly event has sponsors, talks and workshops throughout the day. Last year I was invited to do a couple of talks at the event its always a great event with simply loads of people there. They had a trailhead zone which is a great place to pick the brains of Salesforce gurus and get free advice!
Sign up now FREE
I’m heading to Austin to present at the Austin Salesforce User Group. More Details to come soon!
A couple of weeks ago I was at CeBIT one of “the largest computer expo’s in the world”. At its height during the dot-com boom around 800,000 people would descend to Hanover in Germany to see the latest tech. Since then things have changed and people generally get their dose of tech via the internet rather than going to big tech events so now CeBIT has reduced to around 300,000 people.
Anyone for an Alexa implant?Salesforce was there in full force running their German Salesforce World Tour, BUT in one of the adjoining rooms, there was a stand where you could get a RFID chip injected … yes injected! into your hand, so you could unlock your phone with a wave of your hand, or even unlock your front door? (check out the video above!)
Yes, this isn’t new but what was interesting to me was that there was a steady stream of people wanting this done to them. It’s interesting to see how attitudes to tech have changed over the years and how something in the 80s was a thing of horror is now becoming more acceptable…
So Monday night was a big night! We had none other than Mike Rosenbaum (@mike945778) who is in charge of the Salesforce platform including Sales, Service and Lightning. We asked him a load of questions that the community had come up with and here are some of his answers. I’ll be putting the full video up shortly:
Mike would love your feedback! Just tweet him at @mike945778 (he even said why his twitter has the crazy number)
We're talking @salesforce Lightning ⚡⚡⚡ with @radnip interviewing @mike945778 at a mega London meetup pic.twitter.com/9LNcr3e0K9
— Louise Lockie (@LouiseLockie) April 3, 2017
https://twitter.com/Salesforce_Tom/status/848952112574758912
All the questions by @radnip sourced from the London @salesforceadmns group for @mike945778. pic.twitter.com/0vQlLdLJrK
— Christie Fidura (@cfidurauk) April 3, 2017
It was Salesforce Developer evangelist John Stevenson’s birthday as well but he didn’t say a word until the very end of the evening!! Now that’s dedication to the job.
Happy 80th birthday Mr S. @jr0cket pic.twitter.com/PTkKhoDgce
— Claire Jones (@cejhoney) April 3, 2017
Salesforce has announced that S-Controls are coming back to Salesforce classic. For those who don’t know what S-Controls are, they were the technology before VisualForce and allowed you to create webpages and use the Salesforce JavaScript APIs to communicate with Salesforce (hence the S in S-Controls). Around 10 years ago Salesforce stopped Salesforce customers from creating new S-Controls as VisualForce had replaced the need for S-Controls, but I still find S-Controls in customers orgs. You can still edit and make changes too… well that was until this announcement!
It’s all due to Lighting! Lightning is a JavaScript framework and by bringing back S-Controls, Salesforce will allow developers to develop JavaScript based Lightning apps directly in Salesforce classic without the need of VisualForce. S-Controls are much lighter than VisualForce so you can illuminate the need for an Apex controller or even VisualForce markup! It also means new developers coming to the platform with a client who is still using the Classic UI can skip learning VisualForce/Apex and jump straight into the JavaScript world that is Lightning & S-Controls.
New ‘Add Lightning Component’ Button
So Salesforce as expanded the S-Control functionality to allow you to easily add Lightning Components into your S-Control using the ‘Add Lightning Component’ Button (see pic).
I think also another reason for re-enabling S-Controls is to allow developers & businesses a softer introduction into Lightning components & development. Lightning components/apps can be created directly in the Classic UI using S-Controls or just using regular old JavaScript. It also means that those orgs still using S-Controls can refactor the controls into Lightning components/apps more quickly without the need for VisualForce.
Yes, well I couldn’t resist! 🙂 S-Controls have been consigned to history and now with Lightning replacing VisualForce there is NO CHANCE S-Controls will see the light of day again.
So in conclusion, I think it makes a lot of sense it. Let’s make S-Controls great again! 😉
From Goodreads
Debt: The First 5,000 Years
The Warren Buffett Way: Investment Strategies of the World's Greatest Investor
