Please clarify the maximum #fields on a form, and the max data the form can contain.
We are evaluating Zoho Creator towards an Enterprise Express license and although we don't have plans or desire for crazy-large forms, the wording of the page above seems to limit a form to 80 text fields leaving room for no other fields of any type? Plus, we'd like a clear and complete picture on #fields.
From the above, the limits on 1 form are:
- 80 single-line fields (Text/Email), 255-char each
- 60 List fields (Dropdown/Checkbox/Radio/Multiselect)
- NN Multi Line/Rich Text Fields (depends on the amount of their data in the record)
- ?? Number, Decimal, Percent Date, Currency, Lookup, Image, URL, FileUpload, AddNotes, Auto-Number, Formula, Users, Signature (these field types are not mentiond in the page above)
QUESTION: Is the max for the entire form any 1 of the above, or instead the combined limits of each of the above? In other words, if a form has 80 single-line fields:
- Would these 80 fields hit the limit for the *entire* form, allowing no other fields?
- Or, could it have 80 text fields, PLUS 60 List fields, PLUS some multi-line fields, PLUS some of the other field types that are not mentioned?
QUESTION:
- If text fields are defined as less than 255-char, does this *increase* the possible #fields?
Example: If each are defined as 80-char, could the form have appx. 240 text fields?
QUESTIONS regarding "...the Number of multi-line fields which can be used in a single form will depend on the amount of data added per record." We're not clear regarding the 64K limit and "row length" of 8k.
- Are you saying that if all the form's multi-line fields need to be very large (potential to hold close to 64K), then the max# of THESE fields on the form is 11?
- In any case, can you supply a formula, or few examples, to help us understand the limits when smaller amounts of data are held? Perhaps 4K, 8K, 16k, 32K?
QUESTION: Non-listed field types (Number, Decimal, Percent Date, Currency, Lookup, Image, URL, FileUpload, AddNotes, Auto-Number, Formula, Users, Signature)
- How do these other field types affect the max #fields on a form?
QUESTIONS: Notification
- How does the developer know when a form has reached its #fields limit?
- Since for multi-line fields, the form's limit depends on the data currently stored in those fields, how is the developer notified when reached?
(We realize we can check and enforce a max length via On User Input.)
Many thanks for the answers, and please add any helpful information, and please update the documentation as appropriate.