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
Josie FarrellJosie Farrell 

Using an auto number filed to lookup and account

I need to set up a field in a custom object that we have called Sample Received. I already know that I can lookup and account based on the name, but I need to be able to look upi the account based on the auto number that was given to the account upon creation. Is taht possible and what would be the best formula to use?
Best Answer chosen by Josie Farrell
VinayVinay (Salesforce Developers) 
Hi Josie,

This will work for auto number as well.  Make sure you select All fields in the lookup dialog window.

Below is a screenshot of the same.

User-added image

Thanks,
Vinay Kumar

All Answers

VinayVinay (Salesforce Developers) 
Hi Josie,

Yes this is possible and you need to enable enhanced lookup for specific object.  One you enable enhanced lookup you can search based on other fields.

Review below link to 'Enable Enhanced Lookups'.

https://help.salesforce.com/articleView?id=search_enhanced_lookup_enable.htm&type=5

User-added image
Hope above information was helpful.

Please mark as Best Answer so that it can help others in the future.

Thanks,
Vinay Kumar
Josie FarrellJosie Farrell
That looks liek it would work but not for an auto nubmer inside an account for some reason it only lets me look up an account based on the Account Name. Is there any workarounds for this?
VinayVinay (Salesforce Developers) 
Hi Josie,

This will work for auto number as well.  Make sure you select All fields in the lookup dialog window.

Below is a screenshot of the same.

User-added image

Thanks,
Vinay Kumar
This was selected as the best answer
Josie FarrellJosie Farrell
Got it! Works perfectly!!