Help center
Sign inTry for free

Build applications

App Creation – Intermediate

In this course, you’ll learn about other SpreadsheetWEB features that will help you create more complicated web applications. When you’re done, you’re going…

Start course
Lessons
8
Level
Intermediate
Format
Self-paced
Course contents8 lessons
Course overview
  1. 01Making a Field Required By Another Field
  2. 02Hide/Unhide Controls
  3. 03Masks
  4. 04Required Controls and Validation
  5. 05Tooltips and Popover
  6. 06Trigger Calculations
  7. 07Number Formatting
  8. 08Advanced Validation Techniques

In this course, you’ll learn about other SpreadsheetWEB features that will help you create more complicated web applications. When you’re done, you’re going to be able to create a dynamic web interface, apply formatting, and fine-tune your applications.

Requirements

  • A SpreadsheetWeb Control Panel account. You can signup for a trial account here.
  • Your spreadsheet containing named ranges for all inputs and outputs you would like to use in the web interface of your application.

Course curriculum

What you’ll learn

  1. 01
    Making a Field Required By Another FieldYou can make a UI control required by the value of a Boolean field. A required control can prevent page transitioning and/or save actions.
  2. 02
    Hide/Unhide ControlsYou can hide or show UI controls based on the outcome of a Boolean named range in your workbook, and create a dynamic UI.
  3. 03
    MasksThis video demonstrates how you can use masks in UI controls to format the values entered in SpreadsheetWEB applications.
  4. 04
    Required Controls and ValidationYou can hide or show UI controls based on the outcome of a Boolean named range in your workbook. This way, you can create a dynamic UI, which will help…
  5. 05
    Tooltips and PopoverTooltip Type Tooltips are informative message boxes that are displayed when you mouse-over or click on a control. The Tooltip Type property determines the…
  6. 06
    Trigger CalculationsIf Trigger Calculations is selected, changing the value in this input control will trigger a calculation. Calculations perform a server call with all of the…
  7. 07
    Number FormattingYou can set a number or date formatting for tooltip contents using “{keyword:#,##0.00}”. Data field names can be used in tooltips, charts, maps, and other…
  8. 08
    Advanced Validation TechniquesAdvanced Validation Techniques in Designer Applications Setup a Dynamic Input Range Based on Category Selection: Create a dropdown menu to select a category…