I have a virtual column that pulls data from a specific field from a different table, and I want it to update whenever there’s a modification to that field - currently only happens when the application syncs. Is it possible to trigger a sync based on an update to a specific field?
Alternatively, is it possible to have Update Behaviour functionality on a virtual column?
Thanks!
Hey @rommel
@MultiTech wrote:
- meaning there is no direct connection to any changed data (ie. there’s no [column] value being used in the virtual column formula)
In this case they only update during the main sync.
Hey @MultiTech does it mean if some VC that calculates the COUNT() of number of rows will not work in the app ? Could you please have a look at this Best way to have virtual column recalculate - Google Cloud Community
The background syncing is not possible in your case? Then it would sync each time for example when you save a record.
User | Count |
---|---|
63 | |
25 | |
14 | |
11 | |
6 |