+ Start a Discussion
aswanijagadesh1.397398535585991E12aswanijagadesh1.397398535585991E12 

How many external Id's are allowed on an object?

SaketJoshiSaketJoshi
There can be at the most 3 external ID fields on an object
venkateshyadav1243venkateshyadav1243
Hi ,
You can create upto 7 external id fields on an object, This is new update in salesforce summer 14.
SaketJoshiSaketJoshi
I see, I need to update myself with the release notes :)
aswanijagadesh1.397398535585991E12aswanijagadesh1.397398535585991E12
hai venkatesh will you please check it is 10 0r 7 with latest summer . in research i found it is 7 t0 10 please conform me
venkateshyadav1243venkateshyadav1243
Hi Jagadesh,

I dont have any idea about 10 external id,i read summer 14 relase in pdf its mentioned 7 and see this article also,

https://help.salesforce.com/HTViewSolution?id=000005081&language=en_US

please share me the link or pdf where its mentioned 10. external id's.

if u have still doubt, create external id field in  your org and test and let me know.
aswanijagadesh1.397398535585991E12aswanijagadesh1.397398535585991E12
hai
we can create only 7 external ids.now i tested .when i am creating 8 th it gives an error like this "Error: External ID and Unique field limit exceeded"
Pramod_SFDCPramod_SFDC
Hi,

I hope below link will clarify your doubt.

>> https://help.salesforce.com/apex/HTViewSolution?id=000005081

Regards
Pramod
David "w00t!" LiuDavid "w00t!" Liu
Little known fact - you can ask your friendly Salesforce rep for more External IDs and they'll usually give you more for free!
Avinash AkondiAvinash Akondi
Hello,

The limit is three per object.

Thanks
Autorabit
http://www.autorabit.com/
Sumit_SFDCSumit_SFDC
Hello,
We can create upto 7 External ID's on single object. But anyone please give me one scenario where we require all 7 Ext. ID's for upsert. As per my understanding 1 Ext. ID is sufficient for upsert then where we use all 7 ID's.

Thank you in advance.
Sredhar KaruturiSredhar Karuturi
You can designate up to 25 External ID fields per object.
 
External ID fields must be Custom text, number or email fields.
External ID fields contain record IDs from systems outside Salesforce.
You can use the upsert call to match against External ID fields during import or integration.
External ID fields are indexed, so selective filters on them should run quickly.

Ref Link: https://help.salesforce.com/articleView?id=000005081&type=1
meenal hardyameenal hardya
Could you please advise what will happen if we will make 25 fields as a external Id as well as Unique id. Will it work or through an error?  
JThakkarJThakkar
External ID – is a custom field that has the “External ID” attributes checked meaning that it contains unique record identifiers outside of Salesforce.
External id is a custom field which you mark as unique to identify the data uniquely while the data is coming from external source

Only fields with data type Auto number, email, Number and text can be marked as external ID
An object can have most 7 external ID fields

Custom fields marked as unique also count against an object’s limit of 7 external id fields. – Unique fields +External ID fields <=7
Once you make field as external ID – When you go to data import wizard select object, update existing record, In match by field, you can also see the field which you make it external ID

Hope this will help u to understand External ID

Thanks