Shrink a table's columns with Optimize Datatable
Optimize Datatable reduces the storage size of a table's text and choice columns to fit the data they hold, freeing room in the table's rows.
- Verified Nov 17, 2026
- Classic builder
On this page
Each field of a table takes room in the table's rows, sized for the longest value the field could hold. Optimize Datatable sets a smaller size on fields whose stored values are much shorter than that, based on the longest value each one holds today. Use it on a wide table that is running short of room for new fields.
Before you start #
- Optimize Datatable is available on some plans only. On other plans, the button shows a message instead.
- A smaller size limits how long a value in that field can be. Choose a size that leaves room for the longest values you expect to save later.
Optimize a table #
- Open Application Configuration In the builder, press Shift+I. The Application Configuration window opens.
- Open Optimize Datatable Click Optimize Datatable at the bottom of the window.
- Choose the table In Select Datatable, choose the table. The window shows its number of Records and Eligible Fields, then lists each field it can resize.
- Pick fields and sizes Tick each field to optimize. Its New Size starts at the length of the longest value stored in it. Change it if you want more room; it must stay within the Min and Max shown under the box.
- Optimize Click Optimize Selected Fields, tick I understand this action is irreversible., and click Optimize Now.
| Column | What it shows |
|---|---|
| Field Name | The field and its type. Name and address fields are listed once per part, such as First Name or City. |
| Field ID | The field's ID. |
| Current Size | The size the field's column has now. |
| Current Value Stored Size | The length of the longest value stored in the field. |
| New Size | The size to set. Min is the longest stored value (15 when the field is empty); Max is the field's original size. |
| Reset | Shown for a field you optimized before: puts its column back to its original type and size. |
Which fields can be optimized #
Text, Email, Phone, Number, Currency, Slider, Select, Multi-Select, Checkbox, Radio, Decision Box, Name and Address fields, when their values are stored as text. Hidden and system fields are left out. If a field's stored values are already longer than its original size, it is greyed out with the reason, and it can't be reduced.
If the window says No eligible columns found for this datatable., the table has no field that can be resized.
Put a field back to its original size #
Open Optimize Datatable again and choose the table. Next to a field you optimized, click Reset, tick I understand this will reset the column. and click Reset. The field's column goes back to its original type and size.
Was this page helpful?
Something wrong or missing on this page? Tell us.