In some apps, it is important to track when and where some data was changed. For example, in a field service app, it may be important to record when a certain field was changed.
AppSheet has a simple mechanism to track changes -- the
Change column types. There are three
Change column types:
ChangeLocation. These column types all have a set of shared characteristics:
What triggers a change: Any change to any other column, any change to some specific fields or a single field, or changes to a specific field that result in one of a known set of values
What should happen when such a change is detected: Increment a counter (
ChangeCounter), set a timestamp to the current time (
ChangeTimestamp), or record the current location (
ChangeCounter Update Mode setting
ChangeCounter Update Mode setting controls how the counter increments when data changes occur.
- Accumulate (default): In this mode, the counter increments by 1 per row update when at least one qualifying change occurs. In other words, it counts how many times a row has changed in a way that triggered the counter. An individual row update might occur through a single save of a form, a single Quick Edit in a detail view, or a single action.
- Reset: In this mode, the counter resets to its initial value at the beginning of each update and counts the total number of changed columns that triggered the counter within that update. This mode makes it easy to detect that a particular change occurred during a given update, which is useful for setting up automations that only fire when a specific change occurs.