| Using the Increment, Decrement and Operations commands |
To add/multiple/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 overwrite 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/muliplying with a fixed value and with a given precision. The operation can be also
defined as a formula referring to a given field (or fields).
There are five increment/decrement different pair settings and the active one is determined by the active tab
in the Operations dialog box.
For example:
1. Define some 'increment' formula-based action on the 'Settings1' tab and make it active.
2. Use the 'increment' command (Ctrl+Alt+'+'). Values in the selected fields will be modified according to the defined formula:
