SpreadsheetWeb Help
  • Home
  • Courses
  • Tips
  • Legacy Platform
    • FAQ
    • Legacy Courses
    • Legacy Tips
  • Contact Us
  • Try For Free
  • Sign In
Select Page

Search for Tips Videos

Controls

  • How to change tooltip positions
  • How to copy controls
  • How to disable control labels
  • How to place labels over controls
  • Validation trigger options
  • How to enable formula overwrites
  • How to enable popover messages
  • How to disable auto-calculate
  • How to change the tooltip text
  • How to move controls
  • How to populate input controls from a worksheet and generate single outputs
  • How to enable dynamic labels
  • How to delete multiple controls
  • How to change control types
  • Calendar

    • How to create a Time Picker control
    • How to default a calendar control to current time and date
    • How to disable specific days in a calendar control
    • How to set start and end dates in a calendar control
    • How to configure short and long dates in Calendar controls
    • How to change between 24-hour and AM/PM format in Time Pickers
  • Checkbox

    • How to change checkbox styles
    • How to create a Toggle control
    • How to customize text in a toggle control
  • Dropdown

    • Enable searchable dropdown (Select2)
    • How to create a multi-select dropdown
    • How to format text in dropdowns
    • How to set defaults in Dropdown controls
  • Radio Button

    • How to create a Listbox control
    • How to enable multi-select radio buttons
    • How to enable styles in radio buttons
    • How to set horizontal and vertical alignment in radio buttons
    • How to create a listbox with images
  • Slider

    • How to create a Spinner control
    • How to enable date support in Slider controls
    • How to change Slider With Buttons to Plus Minus Style
  • Textbox

    • How to enable custom masks in Textboxes
    • How to enable validation in Textboxes
    • How to format data in Textbox controls
    • How to set defaults in Textbox controls
    • How to add prefix or suffix to a textbox control
    • How to resize multiline textbox
  • Sections & Containers

    • How to change vertical alignment in sections and containers
    • How to enable collapsing containers
    • How to resize containers
    • How to select Panel Style in Containers and Sections
    • How to stretch the height of a container to match the section height
    • How to create tab based containers
  • Content

    • How to insert a video into your application
    • How to make an image resize in different devices
    • How to format numbers in a Content control
    • How to insert an image into your application
  • File Upload

    • How to enable image upload control
    • How to limit file size in file upload control
    • How to restrict file type in file upload control
    • How to make File Upload Control With Styled Button
    • How to import data from CSV files into a SpreadsheetWeb application
  • Buttons

    • How to make button names dynamic
    • How to enable Reset function in an application
    • How to enable Save As in an application

Charts

  • How to apply a color schema to all charts in your application
  • How to change axis crossings in charts
  • How to change gap in column and bar charts
  • How to change tick counts on charts
  • How to configure left and right axes in combo charts
  • How to create a Gantt chart
  • How to enable animation effects in charts
  • How to enable animations in charts
  • How to enable chart multiples
  • How to enable download data feature in charts
  • How to enable download image feature in charts
  • How to fix chart height
  • How to fix chart width
  • How to format chart labels
  • How to format chart tooltips
  • How to invert chart data
  • How to make chart background transparent
  • How to reorder axis labels in bar charts
  • How to enable smart labels in charts
  • How to enable logarithmic axis in charts
  • How to sort Legend in a custom order
  • How to copy/paste already created visualizations and other controls to different pages across the application
  • How to enable tooltips for labels and legends in charts
  • How to enable culture configuration in charts

Grids

  • How to add Clear All button to input grids
  • How to change column widths by percentage
  • How to change column widths by pixel
  • How to copy data from Excel into a grid
  • How to distribute column widths evenly in grids
  • How to download data from a grid control
  • How to enable a super header in grids
  • How to enable responsive grids
  • How to navigate in a grid control using arrow, tab, and enter keys
  • What is the difference between inline and form based grids
  • How to make a column editable in a Grid control
  • How to enable pagination in a Grid control
  • How to enable dropdowns in a Grid control
  • How to enable sorting in a Grid control
  • How to enable tooltips in a Grid control
  • How to enable search in a Grid control
  • How to make a column checkbox in a Grid control
  • How to configure date format in a Grid control
  • How to enable date picker in a Grid control
  • How to make dynamic headers in Grid controls
  • How to make cells not editable in Grid controls
  • How to enable multi-line text in grid controls
  • How to hide rows in grid
  • How to disable formula-based cells in input grid
  • How to enable formula override and force override on save in input grid
  • How to enable row editability by value of in input grid
  • How to change inline input grid type to form-based/form-based start empty
  • How to Hide Empty Rows in grids
  • How to change Grid Visual Style
  • How to change Input Color Style
  • How to enable filters in a grid
  • How to enable dynamic grid
  • How to change style in form based controls

Maps

  • How to create a density map
  • How to create a location map
  • How to create a route map
  • How to create a standard map
  • How to zoom in maps
  • How to change legend colors in maps
  • How to create maps based on address data
  • How to change circle sizes on location maps
  • How to add layers to location maps
  • How to enable labels in Map
  • How to add keywords to visualizations labels/tooltips using { character

Pages

  • How to create an external page
  • How to create an icon based navigation bar
  • How to enable bottom navigation bars in mobile apps
  • How to reorder pages
  • How to enable navigation bar collapse in a page
  • How to make a page visible/enabled by value of
  • How to allow user to go to another page if validation error occurs
  • How to change Navigation Bar Orientation in a Designer's app page
  • How to change Splash Screen Type in a Page in Designer app
  • How to add popover to the tab menu
  • How to enable Compact UI Mode

Other

  • How to add background image to your application
  • How to brand your application with favicon
  • How to brand your application with navbar
  • How to change regional/culture settings of your application
  • Applying and reordering multiple stylesheets to your application
  • How to trigger queries on application load
  • How to trigger queries with each calculation
  • How to bind queries to a button click event
  • How to copy text overrides from one application to another
  • How to add edit text overrides
  • How to add prompt user confirmation on log out
  • How to change culture settings
  • How to enable record locking and set inactive record locking timeout
  • How to enable single record per user in a designer app
  • How to enable autosave
  • Show User Message When Accessing Application
  • Display Column Parsing Failures During Save
  • Explanation of new access types in UI based applications
  • How to change background color in application
  • How to change color style in applications
  • How to change font styles in applications

Documents

  • How to reorder document templates
  • How to insert charts into a PDF document
  • How to format dynamically inserted data into a PDF document
  • How to insert images into a PDF document
  • How to configure auto-resizing of embedded images in PDF documents
  • How to create a PDF document with eSignatures
  • How to insert a table with variable row count into a PDF document
  • How to attach document to email messages
  • How to increase the image quality in PDF documents

Advanced Stuff

  • How to load the status of a record in an application
  • How to load the assigned user of a record in an application
  • How to load the group name of a record in an application
  • How to load record IDs in an application
  • How to load record update dates in an application
  • How to load record creation dates in an application
  • How to load the email address of active users in an application
  • How to disable controls for specific users
  • How to change the status of a record by a button in application
  • How to hide controls for a specific group of users
  • How to hide pages for specific users
  • How to hide controls for specific users
  • How to make an application work offline
  • How to create goal seek event
  • How to deactivate/delete already created secondary datatables
  • How to disable a script

Styling

  • How to change the font family in Stylesheets
  • How to change background color in grid superheaders
  • How to change the font color in disabled cells in grid controls
  • How to change the background color in grid controls
  • How to change the background color in alternating rows in grid controls
  • How to change the background color in textbox controls
  • How to change the background color in dropdown controls
  • How to change the background color in disabled textbox controls
  • How to change the header background color in input grid controls
  • How to change the header background color in output grid controls
  • How to remove borders in grid controls
  • How to change the color of a slider control
  • How to add an image to a slider control
  • How to style hyperlinks
  • How to change border style in grid controls (Purple double line)
  • How to create a listbox with images
  • How to add custom stylesheet in addition to template stylesheet
  • How to change the look and feel of file upload control
  • How to change the look and feel of slider with buttons
  • How to change the look and feel of the disabled textboxes
  • How to change the look and feel of the grid controls
  • How to change the look and feel of toggle-style checkbox
  • How to make the controls be placed more compact in the app
  • How to change background color in grid's column
  • How to find Control ID and Page ID
  • How to find the ID of a control for use in stylesheet updates

Workbook Preparation

  • How to create a named range for a calendar control
  • How to create a named range for a checkbox control
  • How to create a named range for a grid control
  • How to create a named range for a radio button control
  • How to create a named range for a time picker control
  • How to create named ranges for a multirow header grid control

Hub

  • How to create an identity template
  • How to update an identity template
  • How to clone an identity template
  • How to delete an identity template
  • How to create a web service client
  • How to obtain identifier and secret keys for a API client

Hub - Account

  • How to update your profile
  • How to change your password
  • How to enable Two Factor Authentication
  • How to download your personal data from the system
  • How to delete your account from the system
  • How to see your login activity
  • How to reset password

Hub - Workspaces

  • How to update a workspace
  • How to switch between workspaces
  • How to create a new workspace
  • How to remove users from a workspace
  • How to add users to a workspace
  • How to configure own email settings

Hub - Users

  • How to remove users from a workspace
  • How to add users to a workspace
  • How to invite a user with an identity template
  • How to delete a user
  • How to edit a user
  • How to create a new user
  • How to add a tag to a user account

Hub - Tags

  • How to add tags to an identity template
  • How to add a tag to an identity template
  • How to add a tag to a user account
  • How to add a tag to multiple records
  • How to add a tag to a data record
  • How to create a tag
  • How to add a tag to an application

Hub - Data

  • How to add a tag to multiple records
  • How to add a tag to a data record
  • How to filter records on the data page
  • How to start a batch Run for all records
  • How to start a batch Run for selected records
  • How to download multiple records
  • How to confirm a record is locked
  • How to view conversations in a record
  • How to Delete multiple records
  • How to Delete a record
  • How to view the change history of a record
  • How to Download a record
  • How to Copy a record
  • How to Edit a record
  • How to View a record
  • How to apply a saved layout on the data page
  • How to save a layout on the data page
  • How to import data on the data page
  • How to change the column format on the data page
  • How to change the layout of the data page
  • How to access saved data (from data page)
  • How to access saved data (from app page)
  • How to display images in Data page
  • How to Create a Sharable Public Link for a Record
  • How to add Users list to Data page

Hub - Applications

  • How to add a tag to an application
  • How to load the chat window for an application
  • How to delete a transaction of an application
  • How to find the Application ID
  • How to change the URL of an application
  • How to change the name of an application
  • How to view transactions history of an application
  • How to download the Excel file for an application
  • How to delete an application
  • How to find the URL of an application
  • How to view an application
  • How to create a copy of an existing application
  • How to edit an application
  • How to create a new application manually using Designer
  • How to create a new application using Automated App Creation
  • How to download previous published transactions of an application
  • How to update the Excel file for an existing application

Hub - Dashboards

  • How to setup a dashboard as home page
  • How to customize the layout of a dashboard
  • How to add chat to a dashboard
  • How to add data to a dashboard
  • How to add analytics to a dashboard
  • How to add workspaces to a dashboard
  • How to add application's card to a dashboard
  • How to add apps to a dashboard
  • How to add labels to a dashboard
  • How to create a dashboard

Hub - Subscriptions

  • How to change the billing address for a workspace subscription
  • How to remove a credit card from a workspace subscription
  • How to add a new credit card to a workspace subscription
  • How to change the payment method for a workspace subscription
  • How to change user count while updating a workspace subscription
  • How to reactivate a workspace subscription
  • How to cancel a workspace subscription
  • How to downgrade a workspace subscription
  • How to upgrade a workspace subscription
  • How to decrease user count
  • How to download an invoice for a billing period
  • How to view your billing history
  • How to undo a pending user downgrade
  • How to undo a pending downgrade

API

  • How to add Database to an API
  • How to add PDF export to an API
  • How to add Excel export to an API
  • How to add Email event to an API
  • How to add Goal Seek to an API
  • How to add Solver to an API
  • How to add Named Range Override to an API
  • How to add Queries to an API
  • How to add inputs and outputs to an API request
  • How to save data in database with API
  • How to load data from the database with API
  • How to update an existing database record with API
  • How to get a copy of the Excel file from the API
  • How to run an API request from an older transaction
  • How to select transaction by date
  • How to add a tag to an API request
  • How to export API request to Postman
  • How to run API batch requests
  • How to add dynamic values into an API request
  • How to copy an API request

Database

  • How to add a database
  • How to add a secondary database table
  • How to add a secondary One-to-Many (1-M) database table
  • How to delete a primary database table
  • How to deactivate a secondary database table
  • How to delete a secondary database table
  • How to change the name of a database table
  • How to make a database column inactive
  • How to add a new column to an existing database table
  • How to change the type of a database column
  • How to find the Excel named range for a secondary database table
Popular Articles
  • How to change axis crossings in charts
  • How to fix chart height
  • How to fix chart width
  • How to apply a color schema to all charts in your application
  • How to change tick counts on charts
Newest Articles
  • How to import data from CSV files into a SpreadsheetWeb application
  • How to create tab based containers
  • How to change control types
  • How to enable Save As in an application
  • How to delete multiple controls
Recently Updated Articles
  • How to obtain identifier and secret keys for a API client
  • How to change the background color in dropdown controls
  • How to import data from CSV files into a SpreadsheetWeb application
  • How to create tab based containers
  • How to change control types

  • Facebook
  • X

© Pagos, Inc. - All rights reserved - Privacy Policy - Terms of Use

Manage Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
  • Manage options
  • Manage services
  • Manage {vendor_count} vendors
  • Read more about these purposes
View preferences
  • {title}
  • {title}
  • {title}