Error - Unable to display web part

[andyb]

I'm thinking that maybe I should split the form up between form sets, and use buttons or a field value to switch between them. Could you advise how this can be accomplished - I'm guessing using fd.openForm and then the filename of the form set, is there a specified way of doing this?

[AlexZver]

Dear Andy,

Please check out this article: https://spform.com/uncategorized/handli ... office-365

I hope you'll find it useful.

[2xdutchAZ]

We should really get to the bottom of this as it's important for everyone that works with this product to know the limits. Adoption by the users is impacted by these issues. I'm experiencing the same for a while now and was told to reduce the fields and go with sub-formsets - I implemented this but it's still happening. I'm not a programmer or developer - but how can we measure the performance/render time of the form to be within the limits of sharepoint? How can we see what part is causing the most rendertime? It seems to happen more on Edit forms and during saving in my environment. REALLY need this to be solved and be reliable. Please keep suggesting or try to recreate this situation in your environment and document how to troubleshoot this. Your support is awesome - keep up the good work.

EDIT/UPDATE: I ran the performance tool in EDGE and it came back with this report. Loading took a lot of time and scripting hit the CPU hard.
Does this look "normal"? All I did was navigate to my list, opened 1 item in Display mode - then clicked EDIT and made small update to save it.

SharepointPagePerformance.jpg (151.98 KiB) Viewed 2423 times

[andyb]

I agree 2xdutchAZ it is perplexing, I thought I had created my forms within the boundaries of the 70 field custom limit and still I have issues. Although I use a fair bit of javascript in my buttons and editor it seems the issue is sporadic to say the least.

One thing I have noticed, (although I cannot prove this with any meaningful data) is that I don't get any correlation errors when I use Forms Designer without Cross Site Lookup, but in conjunction with CSL I seem to suddenly be getting issues. In some cases I can get away with the standard lookup, but it is absolutely needed for the additional rendering and searching features.

[AlexZver]

Hi!

It seems that the Edit form is definitely causing some issues, especially seeing 40s wait period.

You can try strip it down of fields one by one, see at what point the issue stops completely. There really is no defined recipe to avoid the issue as it highly depends on the types of fields used, as well as on the server itself - how much resources it has available, for example.

If you use SharePoint Online - pay attention to Forms, the Forms Designer successor, it has no limits.

[2xdutchAZ]

One additional question to the loading time of 40s that I'm experiencing - does it matter how many fields are in the list (340 in my case) - but I only expose less than 70 in the form. With the Child forms, I now have 23 form sets created on this list.
In other tests there is a "Socket.io/token …" event that varies from 6s to 20s. Is this authentication with SharePoint or to SPForms?

Would you have reference tests that you're doing in your environment to compare against?

[AlexZver]

Hi!

It does matter how many fields are in the list, so I would recommend splitting the list into multiple ones.

SPForms does not require any additional authentication. Also, we did not test the solution with so huge number of fields. Here are the boundaries of SP: https://docs.microsoft.com/en-us/ShareP ... s-0#Column

It says that a list cannot exceed 8,000 bytes - ~270 text columns