Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Shubhashini RajaShubhashini Raja 
Hello Trailblazers!!
I cleared my Admin Certification today. I'm so happy. Thank you so much Trailblazer Community for helping me accomplish this. You guys have responded immediately for every question I posted and thanks a lot for sharing the required materials on topics I need referencing. You guys are amazing. Let's keep Blazing!!

Next prep for "Advanced Admin"
 
Best Answer chosen by Shubhashini Raja
Sakthivel MadeshSakthivel Madesh
Wow.. Congratulation Shubhashini !!

Try this trailmix from trailhead - https://trailhead.salesforce.com/en/users/strailhead/trailmixes/prepare-for-your-salesforce-advanced-administrator-credential

Advanced Administrator Quiz from SalesforceBen Website - https://www.salesforceben.com/certified-advanced-administrator-quiz/
Christophe BoutillierChristophe Boutillier 
Hello,

Sorry not sure if this is in the right Topic, please move it as needed,

I'm using a bunch of salesforce report through Excel ( get Data > Online Services > Salesforce Report)
Until today I was able to login with my salesforce credentials and it worked perfectly.

The login popup windows in Excel goes to https://login.salesforce.com/services/oauth2/authorize (at least the title of the pop up says it),
User-added image
after entering my credentials it does not to recognize the password and goes to https://c.salesforce.com/login-message/promos.html
User-added image
and eventually
User-added image

I have tried to adding the Custom domain for my company, and even reinstalled Office. Same issue.

>Getting a bit despaired now, anyone would have an idea ?

Thanks, Best
 
Best Answer chosen by Christophe Boutillier
John KeepJohn Keep
Hi all. We found a workaround for this at our org. It's a registry hack that forces Excel to emulate IE 11 mode when it normally defaults to IE7/compatibility mode which is no longer compatible with the Salesforce login process. If you're not an admin on your machine, you'll have to have someone else make the change but give them this info:
  1. Open Registry Editor and navigate to HKEY_CURRENT_USER\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BROWSER_EMULATION
  2. Right click --> Select 'New' --> DWORD
  • Name: Excel.exe
  • Value: 2af8 (hex)
Megumi MladenovicMegumi Mladenovic 
I'm attempting to set up a data connection in Excel to our Salesforce Production and it is not letting me sign in.  I am using the correct credentials because I can log into my instance and I am able to log into Data Loader.  I've tried someone else's credentials.  I've cleared my cache and cookies.  I've restarted my computer.  

When I go to log in it seems to refresh the page with a new web address of https:/c.salesforce.com/login-messages/promos.html

How it looks prior to me attemping to log in:
User-added image

How it looks after I've attempted to log in:
User-added image
Best Answer chosen by Megumi Mladenovic
Christopher ViramontesChristopher Viramontes
Do the below and you will find the hack to get this to work!

John Keep

Hi all. We found a workaround for this at our org. It's a registry hack that forces Excel to emulate IE 11 mode when it normally defaults to IE7/compatibility mode which is no longer compatible with the Salesforce login process. If you're not an admin on your machine, you'll have to have someone else make the change but give them this info:
Open Registry Editor and navigate to HKEY_CURRENT_USER\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BROWSER_EMULATION
Right click --> Select 'New' --> DWORD
Name: Excel.exe
Value: 2af8 (hex)
 
nilesh tiwarinilesh tiwari 
Hi All,

I hope all are doing well.
I am not able to connect to SF from Excel. Till Friday(17th Jul 2020) i was able to login but all of sudden it stopped.
Steps: 
1. open Excel 2. Click on Data 3. New Query-> Click on salesforce object.
When i enter credentials it is not taking me anywhere. It still ask me to enter the password.
Appreciate any help here.

Thanks.
Best Answer chosen by nilesh tiwari
Krishna DadiKrishna Dadi
Hi Nilesh
follow below thread
https://answers.microsoft.com/en-us/msoffice/forum/all/power-query-excel-365-to-salesforce-sandbox/f0e2810b-4ac1-4fdc-b188-4ec25b227462
Arpita BoseArpita Bose 
Hi
Can anyone please explain the use of VLOOKUP() function in salesforce with a good example, other than the common ZIP_CODE_c ?
As I am new to salesforce, this function is very confusing for me.

Thanks
Best Answer chosen by Moderator (salesforce.com) 
Deepak AnandDeepak Anand
Hey Arpita,

Forget about the Zip Code example. Lets take an another one for now.

Suppose that you are creating Employee(a custom object) records in the SF org. Now since Employees are very important records, you do not want the users to create duplicate Employee again and again. For example, say one User already created an Employee Record with name - Arpita Bose. Now, an another User who does not know about this tries to create an another Employee record with the same name - Arpita Bose. and hence there is a potential duplication. This should not be allowed. 

So you have two options now:
  1. Add a Validation Rule on the Employee which checks whether there are any existing Employee records with the same name if so stop the User from saving it. Here comes the role of VLOOKUP.
  2. Create an Apex Trigger(before Insert, before Update) which runs a SOQL query to get all the Employee records in the Org with same name as of the one thats getting created now. If the number of records is 1 then stop the User from creating the Employee using an addError method. This will require considerable development effort.
Now, since we are interested in VLOOKUP lets see as of how we can do the same. Create a Validation Rule as below:

(4) Name = VLOOKUP(
(1) $ObjectType.Employee__c.Fields.Name ,  
(2) $ObjectType.Employee__c.Fields.Name ,  
(3) Name)
 

Now, our basic requirement is to check if an another Employee with the same Name exists or not. So its obvious we are looking into the Name field. The logic is quite simple compare the Name (4) on the Current Record and the Name on that Employee record that matched with the same Name as of the one that we are creating now. Hence we use the equality operator (=). 

Lets look into the VLOOKUP side. You could express the VLOOKUP formula as below: "Look into the Name(2) field on all the Employee Records and return value in it's Name (1) field if the it happens to be same as the Name (3) on the Current Record." 

The SFDC Document define VLOOKUP as follows:

VLOOKUP(field_to_return, field_on_lookup_object, lookup_value)
 
Searches an object for a record where the specified field matches the specified lookup_value. If a match is found, returns another specified field value.

Points to Remember:
  1. VLOOKUP only available on Custom Objects. Vote for this idea: https://success.salesforce.com/ideaView?id=08730000000BqPs
  2. VLOOKUP only available in Validation Rules.
  3. VLOOKUP can only be done on the Name fields.
  4. The field_to_return must be an auto number, roll-up summary, lookup relationship, master-detail relationship, checkbox, date, date/time, email, number, percent, phone, picklist, text, text area, or URL field type.
  5. The field_on_lookup_object must be the Record Name field on a custom object.
  6. The field_on_lookup_object and lookup_value must be the same data type.

Hope this helps!

Best Wishes,
Deepak
 




Jan TonnetJan Tonnet 

Hello there,

I am trying to display a related list in my task lightning record page that comes from the linked account.  As a 'Parent Record' I can't chose "Related To" because it only gives back the default lists.
So I created a lookup field on the task object to Accounts to choose this as a parent record:

Vom Benutzer hinzugefügtes Bild
 

  • The account field is populated
  • The contact related list exists on the account layout
  • I have no option to put anything to the related list of the task object other than attachment
I begin to wonder if this is due to the task object which is always a bit "special" in its own way - or (hopefully) I am just missing something.

All I am trying to achieve here is to display the related list of contacts from the account (populated in my custom field "account__c") 

Thanks in Advance!
Best Answer chosen by Jan Tonnet
Jan TonnetJan Tonnet
Nvm. I figured out it was the access after all. I have multiple Record Types in place which seems to be a problem. I dumped them down to one and now the list gets displayed!
Sophy TereschenkoSophy Tereschenko 
I'm trying to use Process Builder to update a custom date field using the following criteria (1 AND 2 AND (3 OR 4)):
  1. Stage = Processing
  2. [Custom Date Field] is null
  3. Opportunity Stage is changed
  4. Opportunity Created Date = Today
I want to validate that the stage has been changed to Processing and the date field I'm updating is blank, and I also want to make sure that either the stage has just been changed or that the opportunity was created today and moved directly into the Processing stage. I'm running into trouble with the fourth criteria, since the Created Date field is a Date/Time field but I'm trying to use a formula returning TODAY( ). How can I solve for this and have process builder validate whether the opportunity was created today?

Error received = The formula expression is invalid: Formula result is data type (Date), incompatible with expected data type (Date/Time).
Best Answer chosen by Sophy Tereschenko
Steve MolisSteve Molis
CreatedDate is a DateTime value not a Date, you need to convert it using a DATEVALUE function 

Like this 

DATEVALUE([ObjectName].CreatedDate) = TODAY()
Karen KehrliKaren Kehrli 

I have set up my domain, and enabled for all users. Installed the ContactsToday component and added it to the MyData App and activated it for Lightning, but I keep getting the following error message and am not sure what I am missing:

Challenge Not yet complete... here's what's wrong: 
The 'MyData' Lightning App does not include the 'Contacts for Today' custom component.

Best Answer chosen by Jayson (salesforce.com) 
Ana Paula Soares LimaAna Paula Soares Lima

Hi everyone,

I wanna share with you how I solved this challenge, because I had some trouble too. I wasn't find MyData after installing the package, so I tried to find the Package Id: 04t2E00000161fNQAQ.

With this number I just launch the same Playground where I had built MyData and I did this way: App Launcher > View All > Playground Starter > Install a Package, then and I put the sequency 04t2E00000161fNQAQ to install the package.

Now, when you go to Lightning App Builder and edit MyData, remember refresh the page to the ContatcsToday appears. 

I hope I have helped!

Didi Mahamat AbbaDidi Mahamat Abba 
Hello,

When I'm trying to create a new Playground to achieve badges and superbadges I receive this message: "We were unable to create a Trailhead Playground for you. Please try again."

Step to reproduce: Click on "create a new playground"
Wait for the message "Please hold while our robots build your Trailhead Playground. This may take a few minutes..."
The following message will appear: We were unable to create a Trailhead Playground for you. Please try again."

Expected result: A new playground

Actual result: Nothing is created

Could you please help solve the issue.
 
Best Answer chosen by Didi Mahamat Abba
Didi Mahamat AbbaDidi Mahamat Abba

Hi everyone,

Thanks for your answer. I've tried everything you are suggesting but it doesn't work for me. However, I have contacted Trailhead Support and they suggest to change the country if you are from an EMEA country to another one, this perfectly works for me.

Have a nice day

Laura LanningLaura Lanning 
User-added imageI keep getting the above error message, regardless of how I group the warranty status and states. Here's some screenshots that show how I organized the report. 
Right now, I've grouped the report rows by warranty expiration and billing state: 
User-added image
My filters are Under Warranty = False, Warranty Expiration less or equal to NEXT 45 DAYS and Billing State/Province = NV,UT,CA 

User-added imageI cannot find my error and I've never seen the "Remove any parenthesis" error message. 

Can anyone point me to what I'm not seeing? 

Thank you!
Best Answer chosen by Ed (salesforce.com) 
Jennifer BernardoJennifer Bernardo
Report logic is required in order to include both no warranty Or warranty is expiring in 45 days.  I used (1 or 2) and 3
This passed. Best of luck!
User-added image