Page 1 of 1
Calculated fields
Posted: 2020-06-07 12:03
by angus
Is it possible to amend the calculated fields to only update the record on update/insert and not update the whole table all the time?
Re: Calculated fields
Posted: 2020-06-07 16:18
by pbottcher
Hi,
can you explain what you try to achieve? The purpose of the calculated field is to get the actual data for the field at the time it is displayed.
Re: Calculated fields
Posted: 2020-06-07 17:07
by angus
Sure, say there is 10,000 records in a table with the calculation in it. And there are maybe a few folk adding records then the load on the server might be fairly high and slow down the app.
It seems as if it is updating the calculation on the whole table every page load?