function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Ha TangHa Tang 

How to bypass the limitation of number of custom field?

As we know, there is a limited number of custom field per object, even with Unlimited Edition as metioned here: https://help.salesforce.com/apex/HTViewHelpDoc?id=limits_general.htm&language=en_US
So, i would like to know if there is a way to have unlimited additional values per object? Could we consider to create a custom object that has something like a list of addtional attributes?
Any idea is highly appreciated.
Best Answer chosen by Ha Tang
sandeep sankhlasandeep sankhla
Hi,

Yes we can anyways use anoter object to create other attributes...like Account and another custom object account which will store the data related to account..

Standard Account object --- we can haev 500 custom fields....

create custom object named as CustomAccount...

create master detail between these 2.

now you can create more 500 custom fields one custom object whihc will be different from standard one..

Now however you want to use you can use them...half data you will get from standard one and half you will get from custom one..

It is just that you need to handle everything properly in code to get the proper data , thats it..

by creating custom object and fields you can use these...

Thanks,
Sandeep

All Answers

sandeep sankhlasandeep sankhla
Hi,

Yes there is a limit on number of custom field per object, but if you want more than you can log a case to salesforce by asking more fields..then they will proivide you ...

Thanks,
Sandeep
Ha TangHa Tang
Thank you sandeep! But i think it would be great to bypass that limitation automatically or by a programmatic solution. 
Of course, if there is no other choice, we might have to ask for help from Salesforce.
Regards,
sandeep sankhlasandeep sankhla
Hi,

Yes we can anyways use anoter object to create other attributes...like Account and another custom object account which will store the data related to account..

Standard Account object --- we can haev 500 custom fields....

create custom object named as CustomAccount...

create master detail between these 2.

now you can create more 500 custom fields one custom object whihc will be different from standard one..

Now however you want to use you can use them...half data you will get from standard one and half you will get from custom one..

It is just that you need to handle everything properly in code to get the proper data , thats it..

by creating custom object and fields you can use these...

Thanks,
Sandeep
This was selected as the best answer
JayantJayant
Currently the number of Custom fields available depends on the edition you are using. It's a hard limit and can-not be modified (even by logging a Case with Salesforce).

Current counts are -

800 per object for Performance and Unlimited editions;
500 per object for Enterprise and Developer editions;
100 per object for Professional and Group editions;
25 per object for Contact Manager edition; and
5 per object for Personal edition.

In case you have already hit the maximum limit and require more fields, you would need to upgrade your edition (if you are not already on Performance or Unlimited edition).

By the way, if you have actually exceeded 800 or even 500 custom fields on a single object probably you should relook at your schema as these limits are not as small as it seems. Probably its a good indicator that you need to revamp your Schema and its not optimized (most probably there are too many insignificant fields).



 
Antony RaphelAntony Raphel
Hi I have a quick questiuon on this topic, we are using Enterprise edition, will managed package fields count towards the 500 Custom Field limit/Object?
Fernando Almazan Cantoral 9Fernando Almazan Cantoral 9
Hi, someone could help me to know the Custom Field Limit in a Essential Edition?