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
  • Scenario Properties
  • SCENARIO SETTINGS
  • BUTTON GROUP STYLING
  • DIALOG STYLING
  • SCENARIO RANGES

Was this helpful?

  1. Components
  2. Controls

Scenario

This article describes the Scenario component and its properties.

PreviousToggle SwitchNextText

Last updated 11 months ago

Was this helpful?

Scenario provides a convenient graphical interface for a user to save and load different sets of data from spreadsheet ranges specified by the project designer into a running Squirrel project.

Select Scenario from the Controls category of the component library. Move the mouse over the canvas and click to add the component to your project:

When placed on the canvas the scenario component adds two buttons:

When these buttons are pressed the end-user is presented with a combination of dialogs to allow them to save, load, and edit their scenarios:

Scenario Properties

The Scenario properties are organized into SCENARIO SETTINGS, BUTTON GOUP STYLING, and DIALOG STYLING and SCENARIO RANGES drawers.


SCENARIO SETTINGS

This property drawer controls the overall function of the Scenario component. Initially, it looks like this:

  • Scenario ID

    • This property provides an identifier under which the scenarios will be saved.

    • When the end user saves a scenario it will be tagged with this identifier and only scenarios with this identifier will be shown to the end user when they choose to re-load a scenario.

    • You should use different identifiers for different projects.

    • In addition to this identifier, scenarios are also tagged with the unique ID of the project author, i.e. the person who initially added the Scenario component to the canvas, in case other authors select the same scenario identifier.

  • Save scenario to

    • This property allows the designer to choose whether scenarios are saved to the Squirrel cloud or stored locally on the end-user’s machine.

    • Scenarios that are saved locally are not only specific to the local machine but also to the browser in which the project is viewed. As a result, scenarios saved in one browser (e.g. Microsoft Edge) will not appear when the project is run in another browser (e.g. Google Chrome). Additionally, scenarios saved from a project embedded in PowerPoint will only appear when the project is viewed in PowerPoint

    • Locally saved scenarios are saved in the “IndexedDB” database of the browser

    • Scenarios that are saved to the Squirrel Cloud will appear no matter which machine or browser is used to view the project.

    • Selecting to save scenarios to the Squirrel Cloud reveals several additional options:

  • Cloud scenario modes – This property controls the scenario actions that the end-user will be able to perform in the final project

    • Allow Save – if this option is deselected then the user will not see the “Add Scenario” button. This is useful to provide a project with several built-in scenarios but not allow further ones to be added by the user.

    • Allow Load – if this option is deselected then the user will not see the “View all scenarios” button. This can be useful to capture specific information from the user, for example in a lead capture form.

    • Allow edit – this option is only available if “Allow load” is checked and controls whether the end user is offered the menu option to rename and delete scenarios.

  • Where will your project be hosted?

    • This is a security setting that ensures that the Squirrel cloud will only deliver scenario information to a genuine Squirrel project

    • If Squirrel Cloud is selected then there is nothing else to do, however, if “Custom domain” is selected then the domain on which the project will be hosted must be entered. This should be the high-level domain without any subdomains and care must be taken to exactly match the name of the hosting domain (including http or https at the start and any port number at the end, e.g. https://somedomain:5000).


BUTTON GROUP STYLING

The BUTTON GROUP STYLING properties are used to control the appearance of the save and load buttons on the canvas. The top section controls the options which are common to both buttons:

  • Font – Choose a font style from the dropdown list.

  • Size – Change the font size of the push button label.

  • B I U – Use these toggle buttons (bold, italic, underline) to change the format of the button label. When any of these is toggled on, the button is blue:

  • Corners – This property determines the corner radius of the button borders. 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.

Each of the buttons can be independently styled by expanding the “SAVE BUTTON” and “LOAD BUTTON” sections to reveal the formatting options:


DIALOG STYLING

The DIALOG STYLING properties are used to control the appearance of pop-up dialogs which are presented when the end-user chooses to save or load a scenario:

  • Font – Controls the font of the title and text in the main part of the dialogs.

  • Text Color – Controls the color of the title and text in the main part of the dialog

  • Fill – Controls the background color of the dialogs

  • Border – Controls the border of the dialogs

  • Accent Color – Controls the coloring of the buttons in the dialog


SCENARIO RANGES

These properties specify the spreadsheet ranges that will be saved as part of the scenario.

If a spreadsheet cell that is saved as part of a scenario contains a formula its values will be saved as part of the scenario and not the formula. This means that formulas will be overwritten with values when loading back saved scenarios. As a result, it is recommended to avoid specifying ranges that contain spreadsheet formulas.

Each scenario can consist of many saved ranges, new ranges can be added by clicking on the + icon at the top right of the list of ranges.

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.

Set Property Values