Document taking time when opening

[ferha_jafri]

Hello Everyone,

I am facing a problem and not sure why is it happening I have a document which is taking time to open , the problem is when I am triggering that application with Today date variable it is taking same time although when I am saving the application with that day selected and open it again , it is opening in sec not sure what is happening. Can anyone help.

Thanks in advance

Ferha Sharma

[kamal_sanguri]

Trigger is slowing down your application. When you open your document your objects are again calculated with the value new value of variable. Do you have object with large data/ complex calculation / If statements etc.?

[sujeetsingh]

Check for any on select triggers on open trigger. Many times they hangs the app.

[ferha_jafri]

Yes , the front part has many and complicated expressions.

[kamal_sanguri]

that's the reason, they are getting calculated again once your variable gets a value after opening document. Nothing much you can do about it.

Still few points -

*if you have multiple sheets in your document, try making default to one which has simple objects (if possible).

*you can do complex calculation in script and not at front end (may take lot of rework).

*you can minimize the object with complex calculation, it will restrict the object from recalculation.

[ferha_jafri]

Hello Everyone,

We are trying to place trigger in the application to open for one date but it is still taking 2 min time , we tried all the possible triggers but no go , here I have a question which I could not understand as when we select one date in date field and save the document and close it and open it again , it is opening in few sec but if we are implementing the trigger it is again taking 2 min time my question is why is it happening as we are reducing the data but the ways are different.