The Shortcut Module helps to avoid fat finger issues and to speed up data entry for numeric columns.
Defining a Shortcut
A Shortcut defines which mathematical calculation is applied to the currently edited (numeric) cell when a given key is pressed.
|Scope||On which numeric Columns the Rule is applied|
|ShortcutKey||Key which triggers the Shortcut when pressed|
|ShortcutOperation||The Operation: 'Add', 'Subtract', 'Multiply', 'Divide'|
|ShortcutValue||Value which acts as 2nd operand for ShortcutOperation (the first operand being the cell value)|
As can be seen it comprises 4 elements:
Which numeric Columns will use the Shortcut.
This can be set to be DataType of 'Numeric' so that it applies to all
The mathmatical operation to undertake. There are 4 potential values:
- Multiply (the default)
The key to use to trigger the Shortcut
This has to be a letter of the alphabet.
The numeric value to use in the mathmetical operation when the shortcut is applied
Putting it together
Here we define 2 Shortcuts which will happen when a key is pressed in the numeric cell editor:
- 'm' - for any numeric column - will multiply current edit value by 1000 (e.g. 5'm' produces 5,000)
- 'v' - for the 'amount' column - will multiply current edit value by 1.175 (e.g. 100'v' produces 117.5)
Shortcut includes the following UI Elements:
- Popup - Shows a list of existing Shortcuts with a Delete button. Plus an Add button to start the Shortcut Wizard which facilitates the creation and editing of Shortcuts.
Shortcut Entitlement Rules:
Full: Everything is available to the User - they can create and edit Shortcuts
Hidden: Everything is hidden from the User
ReadOnly: Users can use pre-existing Shortcuts but not create or edit their own
Can we apply shortcuts on non-numeric columns?
No, Shortcuts only work for numeric columns.