[SalesForce] How to i get Account id in Lead object for Formula

Firstly i need the write query in mailchimp entegration for salesforce contacts and leads, in this case i will get 1 checkbox situation. with formula but in leads i dont have lookup for account rather i have but any times its coming null but i saw one thing, if my leads have account i can see like this.
Here to Lead under account object,
Accounts
in this case can i get account field ? with formula or without just i need the get and actually i dont wanna write apex update code because too many records have and i cant use 2000 up OFFSET.

Best Answer

There are fields for converted records on the lead object. Which are not visible on the layout but you can use them in the formula or SOQL.

Here are those fields

Account - ConvertedAccountId Contact - ConvertedContactId Opportunity - ConvertedOpportunityId

In the Advanced formula editor, you can find those fields. enter image description here

Sample Query

SELECT Id, ConvertedAccountId, ConvertedContactId, ConvertedOpportunityId FROM Lead
Related Topic