Is there any limit of fields that i can add to a layout?, For example, let’s say i create a layout in the accounts module, and i want to add 500 fields on it for whatever reason, is that possible?
There is no such limit that I’m aware of.
Check this thread:
https://suitecrm.com/community/forum/suitecrm-7-0-discussion/8971-studio-issue
it speaks of a limit (from Studio, at least), and provides a workaround.
However, I would warn you that you are probably (99.9% probable) not designing your database correctly. That much multiplicity must have a pattern, you need to find it, and handle it as a separate module, and show items as a list related to your current item.
You’re about to create a nightmare for your users, please don’t do it! : - )
If you are using MySQL there are some limits imposed at the database level. See this: http://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html