javascript - Google Forms very slow performance - Stack Overflow

admin管理员组

文章数量:1336632

I have a google form that I am working on with some scripting done using GAS in the background that loads drop down lists with a lot of different info. The form itself is quite large, about 16 sections and it is loading and responding to scrolling up and down very slowly on several machines including my desktop puter which is a very powerful puter, so I don't think this is a machine dependent problem. Any tips to speed it up would be much appreciated, other than splitting the form into 2 forms or something similar to that.

I have a google form that I am working on with some scripting done using GAS in the background that loads drop down lists with a lot of different info. The form itself is quite large, about 16 sections and it is loading and responding to scrolling up and down very slowly on several machines including my desktop puter which is a very powerful puter, so I don't think this is a machine dependent problem. Any tips to speed it up would be much appreciated, other than splitting the form into 2 forms or something similar to that.

• javascript
• google-apps-script

Share Improve this question Follow asked Jun 7, 2016 at 13:52 IntegrateThisIntegrateThis 96233 gold badges2121 silver badges4444 bronze badges 7

• 1 Try testing the speed, switching off different parts of code, so you'll be able to see what exactly slows down the performance. Or, if you already know it, please share your sample code, so that it would be possible to reproduce your problem. – Max Makhrov Commented Jun 8, 2016 at 6:57
• @MaxMakhrov I have pletely mented out the onOpen trigger so there is no script running in the background. – IntegrateThis Commented Jun 14, 2016 at 14:36
• 2 the speed of a live Google Form has nothing to do with Apps Script / JS – Bryan P Commented Jun 15, 2016 at 15:56
• 2 same deal, we can't change the code the controls the UI of the laggy drag and drop form builder. try downgrading to the old form builder if that's still an option or reporting to the appropriate Google Product forum. Please specify if you are on the newer version of the builder there – Bryan P Commented Jun 15, 2016 at 16:05
• 3 @BryanP this is exactly what I was looking for. Switching to the old forms instantly changed the performance by a lot. There were 25 drown down lists each with 300 or so entries. If you post this as an answer I will give you the bounty as that helped a lot. – IntegrateThis Commented Jun 15, 2016 at 16:16

 |  Show 2 more ments

1 Answer 1

Sorted by: Reset to default 8 +100

You can temporarily downgrade to the old Google Form builder and see if that fixes the lag. Keep in mind that this changes all themes for any live forms back to the old ones too, so you may want to re-upgrade after making changes to the one giving you trouble.

本文标签： javascriptGoogle Forms very slow performanceStack Overflow