function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
SiddoSiddo 

Excel Connector - Getting user Ids with Name

I have a list of names from our database and need to pull the lead Ids with the connector so I can update. Does anyone know how to do that? what formula/steps do I need? Im pretty sure there's a way to do it.

sflookup(tablename, name)

How do I input this^^ I keep getting error messages.

 

thanks,

 

- Sid

Best Answer chosen by Admin (Salesforce Developers) 
Pankaj PatelPankaj Patel

The callable function is

=sfUserId(Name)

 

Thanks,

Pankaj

All Answers

Pankaj PatelPankaj Patel

The callable function is

=sfUserId(Name)

 

Thanks,

Pankaj

This was selected as the best answer
SiddoSiddo

 

Pankaj Patel wrote:

The callable function is

=sfUserId(Name)

 

Thanks,

Pankaj

 

Thanks Pankaj,

 

I was actually looking for the lead ID and found that you can do it with the email lookup instead.

I could not find a way to pull lead IDs (only contacts and accounts).