Can we add SQL to the table formula field for cross table calculations?
Now that we have a formula field which is great for in table calculations can we take the logic step and include SQL commands or soem form of macro that would allow cross table calculations to be stored in table.
For example at present we can SUM a range of records from any table or view using the calculations field, but the performance is slow i'd say. But to be able to do the same in table, would make a significant improvement to performance and functionality.
With the introduction of Triggered Actions, it is possible to perform complex calculations and logic at table level. More information can be found at https://howto.caspio.com/tables-and-views/triggered-actions/.
Douglas Vega commented
But this is based in actions. What about I have 1000 records in my table before triggers existed and I want to do a calculation for all my records?
I think, there should be a way to include SQL in formula fields at table level in the same was we can do in calculated fields at datapage level.
Would it be possible?
Without server side calculations caspio is only good for limited applications, this functionality would open up lots of possibilities. Plus as mentioned performance wise, it would run much quicker in the browser.
I'm amazed caspio doesn't have this functionality already, not being able to do server side calculations like this must cause performance issues?
Being able to do aggregates and sums on a range of records held in another table or view, from the table formula field would be awesome, the power of that would be immense.
Alex Fenech commented
Even if we could have a calculated field or formula in a view, I think it would be awesome.