If you click on the field usage tab there is a link there to show how much space that one field takes up.
But I don't think that's available in a report, so you would need to guess at the likely suspects and then click that link to see how much space is used by that field, on a one by one basis.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com------------------------------
Original Message:
Sent: 01-05-2022 15:31
From: Paul Peterson
Subject: Table Data Usage of a Field
Also, returning to the original question, is there a way to determine how much data a field or collection of fields is using. We have talked before about one of the tables I inherited in some of my apps that has an insane number of fields. I need to normalize that table and want to start with the biggest return on the time invested.
------------------------------
Paul Peterson
Original Message:
Sent: 01-05-2022 15:25
From: Paul Peterson
Subject: Table Data Usage of a Field
Thank you. That helps immensely!
------------------------------
Paul Peterson
Original Message:
Sent: 01-05-2022 15:14
From: Mark Shnier (YQC)
Subject: Table Data Usage of a Field
Correct. Only data entry fields count.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
Original Message:
Sent: 01-05-2022 15:10
From: Paul Peterson
Subject: Table Data Usage of a Field
Am I understanding you correctly, formula fields, including Formula - Rich Text fields don't count toward table size limits?
------------------------------
Paul Peterson
Original Message:
Sent: 01-05-2022 14:53
From: Mark Shnier (YQC)
Subject: Table Data Usage of a Field
Only data entry fields count toward Table Size Limits. Summary fields, Formulas fields and lookup fields don't count against table space or application space limits.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
Original Message:
Sent: 01-05-2022 14:34
From: Paul Peterson
Subject: Table Data Usage of a Field
Is there a way to determine how much overall data is used in a field in a table. I have some formula RTF fields that may be consuming a great deal of memory in one of my tables. I am considering moving those fields to their own table and replacing them with a summary field. Or would the Summary Field take the use the same amount of data?
------------------------------
Paul Peterson
------------------------------