I need a live monitoring system to track statuses marked as "NEW." If it's been 2 minutes since the timestamp, I want the status to switch to "No Employee
AppSheet allows for creating data-driven apps and is not suited for real-time purposes; you'd better think of having some backend that would read your data and update your app's database accordingly through API. However, users will not see the updated status until there's a new sync.
The best you can achieve is to implement this monitoring in a virtual column which would also recalculate only upon a new sync.
User | Count |
---|---|
18 | |
10 | |
8 | |
6 | |
5 |