Column Advanced Settings: Min, Max, Step
Overview
When restricting the minimum and maximum values of a "Numerical Value Column", specify the "Step" when using "Spinner" as the "Control Type".
Restrictions
- Can only be set for "Numerical Value Column".
- "Minimum" cannot be smaller than "-999999999999999".
- "Maximum" cannot be larger than "999999999999999".
- "Step" can only be used when "Spinner" is selected as the "Control Type".
- "Step" adds or subtracts a numerical value based on the numerical value specified in "Minimum". If you specify a numerical value of 2 or more as "Step", make sure that "Minimum" is a multiple of "Step".
Prerequisites
- "Site Administration Permission" is required to configure settings.
Usage Example
1. Behavior when using "Spinner" with default values for "Min, Max, Step"
Advanced settings for "NumA"
| Content | Value |
| Default Value | 0 |
| Control Type | Spinner |
| Minimum | -999999999999999 |
| Maximum | 9999999999999999 |
| Step | 1 |
Behavior of "NumA" in the Edit Screen
| Content | Increase/Decrease "NumA" |
| Behavior when increasing from the initial value | 0 → 1 → 2 → 3 ... 999999999999999 |
| Behavior when decreasing from the initial value | 0 → -1 → -2 → -3 ... -999999999999999 |
2. When entering only positive numbers
Advanced settings for "NumA"
| Content | Value |
| Default Value | 1 |
| Control Type | Spinner |
| Minimum | 1 |
| Maximum | 999999999999999 |
| Step | 1 |
Behavior of "NumA" in the Edit Screen
| Content | Increase/Decrease "NumA" |
| Behavior when increasing from the initial value | 1 → 2 → 3 → 4 … 999999999999999 |
| Behavior when decreasing from the initial value | Cannot decrease to a numerical value smaller than 1 |
3. When entering only 0 and multiples of 5
Advanced settings for "NumA"
| Content | Value |
| Default Value | 0 |
| Control Type | Spinner |
| Minimum | -999999999999995 |
| Maximum | 999999999999995 |
| Step | 5 |
Behavior of "NumA" in the Edit Screen
| Content | Increase/Decrease "NumA" |
| Behavior when increasing from the initial value | 0 → 5 → 10 → 15 ... 999999999999995 |
| Behavior when decreasing from the initial value | 0 → -5 → -10 → -15 ... -999999999999995 |
Specify a multiple of "Step" for "Minimum". As stated in Restriction 5 above, "NumA" will be set to the result of adding or subtracting "5" in increments of "Step" based on the "Minimum" setting of "-99999999999995." Please note that if "Minimum" is set to a value other than a multiple of 5, "NumA" will not be set to a multiple of 5. You will not be able to reset the value to the default value of 0 once it has been increased or decreased.
4. When entering only positive numbers and multiples of 5
Advanced settings for "NumA"
| Content | Value |
| Default Value | 5 |
| Control Type | Spinner |
| Minimum | 5 |
| Maximum | 999999999999995 |
| Step | 5 |
Behavior "NumA" in the Edit Screen
| Content | Increase/Decrease "NumA" |
| Behavior when increasing from the initial value | 5 → 10 → 15 → 20 … 999999999999995 |
| Behavior when decreasing from the initial value | Cannot decrease to a numerical value smaller than 5 |