Skip to content

Input - Numerical Web Controls

This document provides an overview of the various Numerical Web Control types that you can create to manipulate your product. Each control includes a preview that will be shown both in the Task Pane and on the published product in nopCommerce. Once you've created a control, you can set up references to dynamically update your Excel formulas.

You can download sample products from the samples folder.

Numerical web controls in Cadify handle values that may include both static and dynamic min/max limits. Each input is validated against defined ranges, ensuring that calculations remain consistent and errors are avoided. When a value falls outside limits, the system applies strategies such as error messages or guided corrections. This section introduces the concept before detailing each numerical type.

Example: Hole Count on PCD Numerical controls often need both minimum and maximum values, and these may change dynamically with the geometry. The illustration shows a case where the number of holes on a pitch circle (PCD) depends on hole size and available space.

If the user enters a value above the maximum allowed, the Excel field turns red and a message appears, as shown in the example where 11 holes is outside the valid range of 4–10. Cadify then applies a chosen strategy: block the value, suggest a valid alternative, or automatically correct it.
MaxMinHolesInPCD

This ensures that inputs always respect physical limits and that the resulting data remains consistent and usable in production.

Numerical

Numerical Wizard

Simple numeric input.

  • Example Name: How tall are you
  • Example Value: 1900
  • Unit: mm
  • Min/Max: 0 / 10000
  • Decimal: 0
  • Increment: 1
  • Type: Output

Spinbox Up Down

Spinbox Up Down Wizard

Numeric input with increment/decrement buttons.

  • Example Name: Number A
  • Example Value: 10
  • Unit: mm
  • Min/Max: 1 / 1000
  • Decimal: 0
  • Increment: 1
  • Type: Input

Spinbox Slider

Spinbox Slider Wizard

Slider control for numeric input within a range.

  • Example Name: Number B
  • Example Value: 15
  • Unit: mm
  • Min/Max: 1 / 1000
  • Decimal: 0
  • Increment: 1
  • Type: Input

List Numeric

List Numeric Wizard

Input control for lists of numeric values.

  • Example Name: Numeric List
  • List Values: 1;2;3;4;5;6;7
  • Unit: mm
  • Type: Input

Notes

  • Min/Max indicates allowed range for numeric controls.
  • Type is either "Input" (user provides value) or "Output" (value shown to user).
  • Increment/Decimal are relevant for numeric controls to define step size and precision.
  • List Values are separated by semicolons.
  • Controls with Condition or CT Settings may have additional rules for when and how they're displayed or editable.