Maximum number of fields on a table

Enrique Tabalon
Kilo Guru

We currently have 90 fields/column on a custom table that was extended from task. The business needs to add like 50 more fields.

 

Is there a limitation on maximum number of fields allowed on a table? 

 

Your input is greatly appreciated.

 

Thank you!
Enrique

1 ACCEPTED SOLUTION

Mark Roethof
Tera Patron
Tera Patron

Hi there,

 

Its not really about the number of maximum fields, its more the maximum row size. 140 fields like you are mentioning doesn't have to be an issue (I've seen more than double), than can be... for example when adding too many multiline string fields. It is a ServiceNow best practice to not have more than 10 of those (is really a low number, though I have seen it go wrong at a customer having 50 of those, causing serious database corruption and ServiceNow Support needed).

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn

View solution in original post

6 REPLIES 6

SNOW? Wasn't this about ServiceNow?

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn

SNFan
Tera Expert

The SN Engineering team should be deciding how many fields are needed not the business 🙂

If you haven't already, make sure you understand the underlying business requirements and propose a solution aligned with out of the box features. e.g. Using metrics instead of adding many time stamp fields, assessments for questions, etc