You are viewing limited content. For full access, please sign in.

Question

Question

forms calculation with database lookup

asked on October 11, 2017

Hi,

I am populating a table with lookup and using Forms built in calculation on the lines.  When I do this, the forms takes longer time to load.  If the rows are more than 10 lines or so, it takes so long.  If I remove the calculation, it seems to be fast.

 

Is there a way to do the calculation after the table is pre-populated? or different method to achieve this function?

 

I have tried it with 10.1 and 10.2 but no difference in performance.

 

Thanks for your help.

0 0

Replies

replied on October 11, 2017

Try using the function "onloadlookupfinish". That might be something that could alleviate the load time.

$(document).on('onloadlookupfinished', yourFunctionHere)
 

 

0 0
replied on October 11, 2017

I definitely agree with Raul, Switch to JS for your calculations. Also maybe post the calculation formula you are using in case there is something there that can be optimised, The calculations shouldn't increase the processing time by that much.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.