Knowledge Base

How Can We Help You?

Search here to get answers to your questions

Popular:

Introduction
Setting Up
Basic Setup
Data Import
Users and Permissions
Printing
Workflows
Email
System Configuration
Data Privacy
Configurations
Advanced
Errors and Reports
Tools
Collaboration Tools
Transactions
Automation
Accounts
Journals and Payments
Billing
Taxes
Pricing
Multi Currency
Retail Operations
Accounting Reports
Deferred Accounting
Subscription
Shareholder Management
Asset
Buying
Module Setup
CRM
Marketing
E-commerce
Website
Employee
Attendance
Recruitment
Training
Employee Lifecycle
Payroll
Employee Tax and Benefits
Performance
Travel and Expense Claim
Gratuity
Fleet Management
Loan
Projects
Project Management
Time Tracking
Quality Management
Selling
Customer Portal
Selling Reports
Stock
Item Variants
Stock Transactions
Serial and Batch Number
Return
Stock Reports
HelpDesk
Education
Student
Admission
Fees
Schedule
Assessment
Assessment Reports
Hospitality
Manufacturing
Production and Material Planning
Non Profit
Membership
Volunteer
Donor
Grant application
Customize BizCentric
Records
Navigation
Custom field
Customize Form
Customize Print Format
Fetch Values
Restrictions
Miscellaneous
BizCentric Integrations
Authentication Integration
Backup Integration
Bank Integration
E-commerce Integration
Shipping Integration
Google Integration
Payment Integration
Telephony Integration
Regional
Reports

Maximum Number of Fields in a Form

  • 68views
  • February 6, 2024

Maximum Number of Fields in a Form

Sometimes while creating custom fields, you might have faced an error message that looks like this:

Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs.

What does it mean?

Simply put, reaching the maximum number of fields for a specific form or document type indicates that you’ve hit the limit allowed for that form. But what exactly is this maximum limit?

In MySQL, there’s a strict cap of 4096 columns per table, though the practical maximum might be lower due to various factors at play.

Each table, regardless of its storage engine, has a maximum row size of 65,535 bytes. Additional constraints imposed by storage engines can further limit this maximum row size.

This row size limit affects the number and potentially the size of columns, as the combined length of all columns cannot surpass this threshold (65,535 bytes).

Solution:

To add more fields to the system, you can do some changes.

  1. Change certain fields to types such as “Text,” “Small Text,” “Text Editor,” or “Code” to optimize space usage. In MySQL, BLOB and TEXT columns count differently towards the row-size limit, consuming additional bytes separately from the main row. Thus, converting these fields to the mentioned types can help free up space, potentially allowing for the addition of more fields.
  2. When creating fields, consider setting a smaller value in the “Length” property, which defaults to 140. This property dictates the length of VARCHAR columns and allocates space accordingly. Therefore, a smaller length value enables the addition of more fields due to the reduced space allocation per field.