SBX - Search With Button

SBX - Forum Post Title

How Many form sections can we add in one MS CRM Entity form

Microsoft Dynamics CRM Forum

Eshwar asked a question on 15 May 2019 1:40 PM

Question Status

Suggested Answer

Hi,

Can anybody tell me How Many form sections can we add in one MS CRM Entity form and what is the maximum fields should we add in one entity?

Reply
Ravi Kashyap responded on 16 May 2019 12:08 AM
Suggested Answer

Hi,

I don't think there is any upper limit of section however the tabs are said to be 100 maximum. Regarding the fields, its a SQL limitation wherein you can only have 1024 columns in a table. If that is reached then you will get an maximum field reached error. However the count of column used by an attribute is defined by the type of attribute i.e. optionset take 2 columns where as single line text takes 1 column.

Refer below links for more details-

www.crmsoftwareblog.com/.../field-limits-in-dynamics-365-how-many-fields-is-too-many-fields

community.dynamics.com/.../178635

There is a very good response from Guido on the above thread, do take a look.

Hope this helps.

Reply
Ravi Kashyap responded on 16 May 2019 12:08 AM
Suggested Answer

Hi,

I don't think there is any upper limit of section however the tabs are said to be 100 maximum. Regarding the fields, its a SQL limitation wherein you can only have 1024 columns in a table. If that is reached then you will get an maximum field reached error. However the count of column used by an attribute is defined by the type of attribute i.e. optionset take 2 columns where as single line text takes 1 column.

Refer below links for more details-

www.crmsoftwareblog.com/.../field-limits-in-dynamics-365-how-many-fields-is-too-many-fields

community.dynamics.com/.../178635

There is a very good response from Guido on the above thread, do take a look.

Hope this helps.

Reply

SBX - Two Col Forum

SBX - Migrated JS