Taking So Long to open the form

Hey there!

I have an app connected to a google sheet that has a lot of data in it But overall the table is in 60% of usage.

When the user clicks “+” button to add a new record it just takes so long

Juan_Camilo_Sierra:

the table is in 60% of usage

What does this mean?

Whatever the case, the problem is with the complexity of and/or data referenced by your Show?, Editable?, Required?, Valid If, Suggested values, Initial value, and/or App formula expressions.

Steve:

What does this mean?

This I what I mean with 60% The Size of the whole sheet

But the table doesn´t have much complexity, It’s just a normal table that has some ref columns and simple math in it

But Just Opening the form takes around 25sec

1 Like

Thanks for the clarification! Neat tool!

That said, I’ll stick with this answer:

Steve:

Whatever the case, the problem is with the complexity of and/or data referenced by your Show? , Editable? , Required? , Valid If , Suggested values , Initial value , and/or App formula expressions.

2 Likes