AdapTable Version:

Framework:

Plus Minus

Summary

Plus / Minus increments / decrements numeric cells when the + or - keys are pressed
Users can set the amount by which the Cell will change
And specify a Nudge Rule which defines whether the Nudge should be applied

Plus / Minus updates numeric cells in response to keyboard input:

the plus keyboard key will cause an increment
the minus keyboard key will cause a decrement

Note

This is ideal for situations where data needs to be edited incredibly quickly

Plus Minus uses Nudge Rules - provided by users - which specify:

where to apply the Nudge
the amount by which to increment or decrement the cell
a Rule which specifies whether to apply the Nudge in all cases, or when a Query Expression is met

Applying Plus Minus

Plus / Minus is applied when the user presses the + or - keys in numeric cells which are in a Nude Rule Scope.

AdapTable will automatically increment or decrement the cell by the Rule's Nudge Value.

Using Plus/Minus

Fork Fork

This demo has 2 Plus / Minus Rules defined for the GitHub Stars column:
- Nudge by 500 if the Language column in the Row is TypeScript
- Nudge by 10 in all other cases

Expand to see the Plus Minus Rules

initialState: {
  PlusMinus: {
    PlusMinusNudges: [
      {
        Name: 'Plus-500',
        Scope: { ColumnIds: ['github_stars'] },
        Rule: { BooleanExpression: '[language] = "TypeScript"' },
        NudgeValue: 500,
      },
      {
        Name: 'Plus-10',
        Scope: { ColumnIds: ['github_stars'] },
        NudgeValue: 10,
      },
    ],
  },
},

Try It Out

Select a cell in the the GitHub Stars column and press the + or - key on your Keyboard
If Language column in the Row is TypeScript it will nudge by 500; otherwise it will nude by 10

Creating Plus Minus Rules

Plus / Minus can be managed at runtime via the Plus / Minus section of the Settings Panel.

This lists the details of all existing Nudge Rules in Adaptable State together with options to:

create (via the Shortcut Wizard)
edit (via the Shortcut Wizard)
delete
suspend
share (if Team Sharing is running)

UI Step by Step Guide

Using the Plus / Minus Wizard

Defining Plus Minus Rules

Plus / Minus Nudge Rules can be provided at design-time through Plus Minus Initial Adaptable State.

Developer Guide

Providing a Plus / Minus Nudge Rule in Initial Adaptable State

There are a few stages to defining a Plus / Minus Nudge Rule:

// Set 2 Plus Minus Rules
// Bid & Ask columns to increment / decrement on any key press
// Bid column - but only when Currency is Euro
const initialState: InitialState = {
 PlusMinus: {
    PlusMinusNudges: [
      {
        Name: 'bid-ask-10',
        Scope: { ColumnIds: ['bid', 'ask'] },
        NudgeValue: 10,
      },
      {
        Name: 'bid-eur-20',
        Scope: { ColumnIds: ['bid'] },
        Rule: { BooleanExpression: '[currency]="EUR"'},
        NudgeValue: 20,
      },
    ],
  },
};

Select Plus / Minus Scope

Provide a unique and identifiable name for the Nudge Rule.

Select Plus / Minus Scope

Specify which numeric columns can use the Nudge Rule.

Or set Number DataType to include all numeric columns.

Specify the Nudge Value

Set the numeric value for the Nudge Rule - the amount by which the cell will increment / decrement in response to key press.

Optionally Provide an Expression

Provide optional Boolean Expression (which will be evaluated by AdapTableQL) specifying when Nudge Value should be applied.

UI Entitlements

Plus / Minus Nudge Rules with ReadOnly Entitlement can be applied but Users cannot manage or suspend them.

FAQ

Can I use Plus/Minus across multiple cells simultaneously? Yes, AdapTable will automatically apply the correct nudge value for each cell in the selection.

PreviousTechnical Reference NextTechnical Reference