I have several docs where I use formulas and HTML to calculate complex stuff, like reports, risk matrix, etc
I am thinking of replacing those formulas, which are calculated, as I understand, for every row they appear, independent of the row being selected or not, by HTML/JS widgets (either hosted on the cloud or made with the Custom Widget Builder).
Would I be right to think that with a Custom Widget, the formula will ONLY be calculated for the specific row being selected, thus severely reducing Formula Timer times?
I have a KPI/Indicators table. There are some 50 indicators, and each indicator has values for several months… resulting in some 5000 RELATED rows in the IndicatorData table.
The indicator table has several formula columns. For example, to calculate if the Indicator has a positive or negative tendency, based on previous X results.
For that obviously, each time a new result for ANY indicator is inserted in the IndicatorData table, I think all indicator tendencies are recalculated. Or for a matter of fact, probably everytime the page is accessed or reloaded.
But one would ONLY need to recalculate anything if data in IndicatorData was inserted AND RELATED to the indicator.
Would it help in that case if I transformed ALL(or most) formulas in the Indicators table into TRIGGER formulas pointed at changes in “CHECKING” column… that being single column at Indicator table checking for new related records at IndicatorData table, and if a NEW related record is inserted, that CHECKING column changes, and if the checking column changes, then triggers the formula for calculation…