Cannot add any more app formula. The length of row is limited.

AppSheet AppSheet Q&A
, ,
1

Hazim99_0-1723190954254.png
Hazim99_0-1723190954254.png768×122 7.42 KB

Error id: 750744

Stack: TypeError: Cannot read properties of undefined (reading ‘length’)
at t.GetErrorState (https://www.appsheet.com/assets/6727b14f99d206622f5d26400bab76e1d2ba31b95261ccbf4c22bdeab1bf0716.js:1:756903)
at K.render (https://www.appsheet.com/assets/6727b14f99d206622f5d26400bab76e1d2ba31b95261ccbf4c22bdeab1bf0716.js:1:1809996)
at Ho (https://www.appsheet.com/assets/3b9506d1a02fbf90e8e73428dbb6956d182fab2498986fba5d526c6eab55f4fb.js:1:143826)
at Bo (https://www.appsheet.com/assets/3b9506d1a02fbf90e8e73428dbb6956d182fab2498986fba5d526c6eab55f4fb.js:1:143625)
at ql (https://www.appsheet.com/assets/3b9506d1a02fbf90e8e73428dbb6956d182fab2498986fba5d526c6eab55f4fb.js:1:184412)
at Tu (https://www.appsheet.com/assets/3b9506d1a02fbf90e8e73428dbb6956d182fab2498986fba5d526c6eab55f4fb.js:1:170629)
at Ru (https://www.appsheet.com/assets/3b9506d1a02fbf90e8e73428dbb6956d182fab2498986fba5d526c6eab55f4fb.js:1:170557)
at _u (https://www.appsheet.com/assets/3b9506d1a02fbf90e8e73428dbb6956d182fab2498986fba5d526c6eab55f4fb.js:1:170420)
at bu (https://www.appsheet.com/assets/3b9506d1a02fbf90e8e73428dbb6956d182fab2498986fba5d526c6eab55f4fb.js:1:167407)
at https://www.appsheet.com/assets/3b9506d1a02fbf90e8e73428dbb6956d182fab2498986fba5d526c6eab55f4fb.js:1:117194

2

Can you provide the problematic formula and perhaps some context about where the calculation is included in your app?

3

Hello, I haven’t seen your specific case, but if you can’t continue writing the expression on the same line, it’s clear that your expression is too long.

If that’s the case, you could improve your approach by creating smaller expressions in virtual columns. You could then combine these virtual columns instead of making such extensive formulas like in Excel.

Once you’ve simplified your logic, it’s easier to manage because you can edit each small part individually without getting confused by such a lengthy expression.

I repeat, I haven’t had time to look at your case; I only based this on the title. I hope that, although it might not help this time, it could be useful in other cases. Regards.

1 Like