Forum Discussion

DianeSinawi's avatar
DianeSinawi
Qrew Member
2 days ago

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.

Forms

2 Replies

Sort By
  • DianeSinawi's avatar
    DianeSinawi
    Qrew Member
    2 days ago

    I'll be using the new style form. I've built a few smaller apps in the legacy form, but there were also not as many records in those as there will be for this new app. Wondering if anyone out there has experience with a large number of fields in the new style forms?

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 days ago

    I do work with a few apps that have that number of fields on a single table, and that app uses legacy forms. I do know that as a builder, the loading of the form and making changes starts to get pretty laggy once you get over about 1000 fields.

    My guess is on Legacy forms. It will perform fine for the users.

     

    But having said all that if you're going into a brand new app with the plan to put that many fields on the form, then there is a good chance there's a better design with trial tables that will reduce the number of fields on the form. So I think you really got a question your architecture.

    But if you thought that all through the architecture is right for your use case and I think it'll work fine on legacy Forums. 

    I have no idea how new style forms would behave with that number of fields