To Add/Multiply/Divide/Subtract Values in Selected Fields Automatically
Select a numeric or date/time (a text field with the date/time format) field value or any group
of such values within a table and use the Edit > Increment (Ctrl+Alt+'+') or Edit > Decrement (Ctrl+Alt+'-') command.
By default, for numeric fields these commands respectively add 1 and subtract 1. For textual date values they
add and subtract one day, and for textual time they add and subtract one hour.
The above plain adding and subtracting can be overwritten with the Edit > Operations command
to perform more complex field value changes.
To Define Operations Executed When You Use the "Edit > Increment" and "Edit > Decrement" Commands
Use the Edit > Operations command and specify the incrementing and decrementing operations, which
can be adding/subtracting/dividing/multiplying with a fixed value and with a given precision. The operation can also be
defined as a formula referring to a given field (or fields).
There are five different increment/decrement pair settings, and the active one is determined by the active tab
in the Operations dialog box.
For example:
-
Define some "increment" formula-based action on the "Settings1" tab and make it active.
-
Use the "increment" command (Ctrl+Alt+'+'). Values in the selected fields will be modified according to the defined formula:
