LogoLogo
FeaturesHelp & ResourcesShowcasePricingLogin
Learn Section
Learn Section
  • Introduction
  • Getting Started
    • Finding your way around
    • Core concepts
      • Data Binding
      • Data Insertion
      • Dynamic Visibility
    • Creating and managing projects
      • Creating a Project
      • Saving a Project
      • Opening a Project
      • Version History
    • Templates
  • Components
    • Overview
    • Layout & Positioning
    • Charts
      • Line Chart
      • Column Chart
      • Bar Chart
      • Pie Chart
      • Combination Chart
      • Area Chart
      • Spline Chart
      • Step Chart
    • DataViz
      • Gauge
      • Word Cloud
      • Chord Diagram
      • Sankey Diagram
      • Schedule (Gantt)
      • Metric Tile
      • Progress Bar
      • Trend Icon
      • Mapbox
      • Loading Animation
    • Tables
      • Scorecard
      • Data Table
    • Controls
      • Push Button
      • Dropdown
      • Multi Select Dropdown
      • Listbox
      • Label Based Menu
      • Checkbox
      • Radio Button
      • Slider
      • Value Input
      • Print Button
      • URL Button
      • Screenshot
      • Hotspot
      • Date Picker
      • Toggle Switch
      • Scenario
    • Text
      • Text Label
      • Text Input
      • Text Area
    • Shapes
      • Rectangle
      • Ellipse
      • Line
    • Media
      • Image
      • Icon
    • Containers
      • Container
      • Web View
      • Repeat Container
      • Row Layout
      • Column Layout
  • Functions
    • Overview
    • Data Mover
    • External Parameters
    • Export to Excel
    • Export to PDF
    • Timer
    • Tableau Parameters
    • Browser Info
    • TextJoin
    • Unique List
  • Connections
    • Overview
    • Excel One Drive
      • Excel One Drive Read
      • Excel One Drive Writeback
    • Google Sheets
      • Google Sheets Read
      • Google Sheets Writeback
    • Ninox Connections
    • Smartsheets
    • CSV Connector
    • SAP Webi Connector
    • XDC Connections
    • Database Connections
    • Zapier Trigger
  • Spreadsheet
    • Overview
    • Spreadsheet functionality
    • Supported Spreadsheet Functions
    • Spreadsheet performance
  • Best practices for the Squirrel spreadsheet
  • Publishing & Sharing
    • Overview
    • Project Settings
    • Publishing to Squirrel Cloud
    • Publishing Locally
    • Using the Project Manager
    • Adding projects to PowerPoint
    • Adding projects to Tableau
    • Progressive Web Apps (PWA)
  • SETTINGS
    • Image Library
    • Custom Fonts
  • Account Management
    • Manage your account Profile
    • Understanding your Squirrel plan usage
    • Changing your Plan
    • Billing
    • How do I delete my account?
  • Frequent Questions
    • What data do you keep and for how long?
  • How-Tos
    • Overview
    • Add-ons
      • Add-on Documentation
      • Window Size – Add responsive behavior to your components
      • Window Size - Getting responsive behavior in the canvas
    • Adding your own Google Fonts
    • Chart title and Checkbox label text case formatting
    • Deleting functions and connections
    • Find & Replace Fonts
    • Getting a Mapbox API access token
    • Renaming a component, function or connection
    • Seeing Data from a Connector at Design time
    • Troubleshooting Projects in the Console
    • Using colors and color values
  • Tutorials
    • Create a temperature conversion app
    • Create a revenue growth app from an existing spreadsheet
    • Whack-A-Squirrel Game
    • Filtered Rows Insertion: Building a Filtered Selection
Powered by GitBook
LogoLogo

Explore

  • Home
  • Features
  • Pricing
  • Download Squirrel

Help

  • Learn
  • Community
  • Support
  • FAQ's

Updates

  • Blog
  • Events
  • Release Notes

Company

  • Contact Us
  • Privacy Policy
  • Terms of Use

Copyright © 2019 - 2024 InfoSol Ltd. All rights reserved.

On this page
  • Value Input Properties
  • DATA INSERTION
  • STYLING

Was this helpful?

  1. Components
  2. Controls

Value Input

This article describes the Value Input component and its properties.

PreviousSliderNextPrint Button

Last updated 3 months ago

Was this helpful?

Who can use this feature?

All Squirrel365 plans include the Value Input component.

For more details, see our .

Squirrel 1.12 introduced a “Quick Set-up” tab on many property panels. The properties described on this page are available on the “All Properties” tab of the property panel. For more details on “Quick Set-Up” properties see

The Value Input allows a user to either type in a value or alter it using up and down arrows.

Select Value Input from the controls category of the component library. Move the mouse over the canvas and click to add the component to your project:


Value Input Properties


DATA INSERTION

  • Value – This property is the value that is controlled by the value input. This should be bound to a cell in the spreadsheet. The value in the spreadsheet will update and be updated by the component’s value.

  • Step Size – the size of the change in the value caused by the up/down arrow buttons (if enabled)

  • Enable limits – determines if there are limits to the values that can be input

  • Min / Max – These properties determine the minimum and maximum values the user can enter using the component.


STYLING

The appearance of the slider can be altered to suit a theme or particular style by using the STYLING properties.

Hide Up / Down arrows – this determines whether the component shows up and down arrows which allow the user to click to increase or decrease the value

VALUE

These properties apply to the value displayed by the component

  • Font – The fonts used for the labels.

  • Size – The size of the font of the labels.

  • Text Colour – The color of the text of the labels.

    • Opacity – This opacity of the text of the labels.

  • Number format – This property determines how the displayed value is formatted. Note:

    • selecting Number, Percentage, or Currency provides an extra option to set the number of decimal places displayed

    • selecting Currency also provides an option to set the currency character and in the case of a custom character whether it should come before or after the number

    • when Percentage is selected the component treats the value in the cell as fractional, i.e. 0.1 to represent 10%, 0.5 to represent 50%, etc. However, the other values in the property sheet (Min, Max, and Step Size) should be treated as percentages, ie 10 for 10% and 50 for 50%.

BACKGROUND

These formatting properties apply to the handle of the slider

  • Fill – the color of the body of the component

    • Opacity – the opacity of the body of the component

  • Border – the color of the outline of the component

    • Opacity – the opacity of the outline of the component

  • Corners – This property determines the corner radius of the value input border. Use the slider to amend this property, or type a numerical value into the property field.

    • Individual Corners - selected this property to apply different radii to each of the component's corners. Each of these individual inputs can be manually edited or bound to the spreadsheet.

PADDING

These formatting properties apply to the Value Input padding.

  • Padding – This property defines the space between the dropdown label and the dropdown border.

    • Individual Padding - selected this property to apply different amounts of padding to each of the component's edges. Each of these individual inputs can be manually edited or bound to the spreadsheet.

The Value Input properties are organized into, STYLING, and DYNAMIC VISIBILITY drawers. This guide will describe the data insertion and styling properties only; the dynamic visibility properties are generic and a separate guide and tutorial on dynamic visibility can be found .

The component properties are set and edited using different methods, some have multiple methods, some just one. See this article for more information on using the different methods.

here
Set Property Values
pricing comparison matrix
this article