How many fields?

👨‍💻 Development Help
1

I have a non-standard setup I want to use SuiteCRM for, and in doing so I have many fields that are not in the tables already.

But there are some fields that I am pretty sure I can just rename and use instead of creating a ton of new fields.

However, as an example; I am starting in the accounts table, and it has only 67 labels and fields when I select “Frequently Used Labels” but if I select “All Labels” there are 110.

But if I go look at the layout for accounts and select a record and export it, there are only 40 fields.

I am so confused.

2

Labels are any translatable message that appears on screen, this will include field labels but also many other things like warnings, help messages, delete confirmations, etc.

But if I may warn you - having “a ton of fields” in a single table is a sure sign of a database design that needs to be improved. You should find out the relationships and patterns in those fields and split the data onto related tables. This will help your users a lot, and yourself, since it’s hard to have a good app built around a faulty data design.

1 Like
3

Ok so the labels are just that, labels and nothing more. That’s good to know.

So I found a list of the fields in the docs, and compared it to the field list in the admin menu for accounts.

There seems to be some discrepancies in both lists. Whats up with that?

4

If you mean this https://docs.suitecrm.com/user/appendix-a/

it’s simply very out of date. VERY.

This one is more recent, Jul 2017: https://schema–suitecrm-docs.netlify.com/schema/
… and it’s much more informative.