Can I have 1500 or more fields in one form in one table, spread across multiple pages?
I will be creating a new app. In one table, is it possible to have a form with around 50 pages, and each page would have anywhere from approx 10 to 50 fields (probably only a few pages would have 30-50 fields, most pages would have 10-20).
Therefore, the total number of fields in the form would be anywhere from approx 1,000 to 2,500. Of that total, around 200 fields would be derived fields (formulas). I would also like to have form rules that hide certain pages based on a field selection. NOTE: for each record, only about 60-100 fields would be populated.
Are there limits that would prevent me from adding that many fields? Or could so many fields cause performance or other issues, like problems with form rules functioning properly?
While it is possible for us to pull out most fields into other tables and connect to the main table using relationships, for our users ease of use and ease of reporting, we are hoping to contain all fields in one form in one table.
I think that more of the impact than the number of fields is the number of pages. I have one form with only 8 pages and perhaps 100 fields, and the form builder BARELY works. It takes about 30 seconds to open the form builder, and dragging and dropping fields is nearly impossible. They are using my app to try and figure out how they can fix that, but so far, I would say I would hesitate to put any more than about 8-10 tabs (pages) on a new form, or its impossible to customize.
It should be noted that I haven't done enough testing to figure out if the biggest contributor to the slow down is number of fields, number of sections, or number of tabs/pages. But so far it really seems like it is number of pages.
