Is there a limit in lenght for custom properties formulas?

[Mathias Jonathan]

Hi!

I was thinking about an alternative to the way my sum area python script works: https://community.graphisoft.com/t5/Archicad-Python-API/PYTHON-Sum-area-script/td-p/371704 

Atm, the result of the sum is stored in each zone. The problem is that if the zone is locked, the layer is locked, the zone is a module.... the script can't work. I don't think that this is a big problem, i could work on unlocking layers and objects, opening modules, reserving elements, but I would like to test something else.

An alternative would be to store with a python/tapir script all the result in a single formula that would look like that:

-IF (ZONE NUMBER = A, value of the sum of all area with a zone nuber = A; (ZONE NUMBER = B, value of the sum of all area with a zone nuber = B;  ETC...)  )

That would mean I could have several hundred nested Ifs.

My questions:
- Is there a size limit for a formula?
- Will I crash Archicad (and my computer?) with formulas that are computationally intensive?

Operating system used: Mac Apple Silicon

[Mathias Jonathan · Accepted solution]

And same question for the project info part, I could store all data in one info if it is possible.

EDIT: I tried with 300 values and It worked well. Lets go for a new version !