Could we have a way to fraction a large table into several partitions where only the most recent data would be read-write, and the older data would be read only?
This should be then be re-appended as a single table but updates would only sync on the read-write partition.
There are many ways to do it. One simple way is to write a condition rule into the edit system action. For example you could write like [DATE]>TODAY()-7 and you can open/edit the record if the evaluation is true.
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |