Product documentation
App Designer
Build application interfaces with pages, controls, formulas, and events that turn spreadsheet logic into guided workflows.
Start here
Core App Designer guides
ApplicationApplication page is where one can find information about their application and can update their application. Application page can be utilized to modify…Creating an ApplicationCreate a SpreadsheetWeb application from an Excel workbook or Google Sheets file, add tags, select an application type, and start designing.Custom ActionsThe Custom Actions allow defining custom actions with custom action hooks with custom code that will be executed with calculations.DatabaseIn SpreadsheetWEB, designer applications can store input and output fields when you define them in the database designer.ElementsThe Elements module in SpreadsheetWeb Hub App Designer allows you to define user interface elements directly within an Excel-like environment, eliminating…Layout & ControlsThe user interface (UI) of a designer application can be built using a drag-and-drop interface accessible in the User Interface Designer.Names EditorNames Editor The “Names” module of the SpreadsheetWeb Hub Designer facilitates the management of named ranges in spreadsheet applications. Named ranges…Pages and NavigationYou can use a Navigation Bar, any number of Action Buttons, or any combination of both methods to allow your users to transition between pages.Power QueriesThe Power Queries module enables you to import your Power Query scripts directly from your Excel file into a SpreadsheetWeb application. This allows you to…QueriesIn the Queries module you can create database queries to retrieve data from applications in your workspace. Queries are created using an intuitive user…ScriptsScripts allow you to modify the behavior of your applications by executing additional JavaScript functions at various points of the application session…StylesheetsUsing CSS (Cascading Style Sheets) code, Stylesheets will give your applications a unique style, and can also help you customize the user interface further.Text Resource (Run-time) EditorThe text resources of designer applications, also known as runtime text, is the set of strings that you see throughout the application UI.Validation MessagesThe active spreadsheet has no named ranges! The message appears if the Excel file lacks named ranges. For a spreadsheet to be transformed into a web…
App Designer
Events
The Events submodule is comprised of a series of highly customizable, complex processing tasks that can be bound to and triggered by Action controls. These include actions that can be used to generate documents, map to Excel files, design and send emails, and execute custom code.
Email ProcessConfigure SpreadsheetWeb Email Processes, add dynamic content and attachments, and share saved records with expiring public View or Edit links.Excel ExportGenerating an Excel export from your web applications can be useful for when you want your users to be able to analyze their results.Goal Seek EventA Goal Seek is an iterative calculation event with custom action hooks. This feature is not supported on Public Cloud accounts.Print ProcessThe Print Process Designer allows for design of template-based document generation, which can then be triggered through buttons in the user interface.Simulation EventLearn how to use the Simulations event in SpreadsheetWeb to run Excel Data Table simulations directly within your web application. Trigger multi-scenario…Solver EventA Solver Event is an optimization tool that can be used for what-if analysis. This feature is not supported on Public Cloud accounts.
App Designer
Misc
App Designer
Special Formulas
The Designer includes support for some special formulas. These formulas can be added to your Excel workbook. Though they will not be evaluated within Excel, the workbook will be able to evaluate them once uploaded to the server with a designer application. Inclusion of these formulas can significantly expand the potential of your workbook’s integration with the designer application at runtime and your overall workflow generation.
DbConnect FunctionDbConnect Function DbConnect is a custom SpreadsheetWEB Hub function used for database calls. The formula allows the application to connect an external…SpreadsheetWebRecordInfoThe SpreadsheetWebRecordInfo formula can inject record-related information into your workbook to build up logic based on records metadata.SpreadsheetWebUserInfoThe SpreadsheetWebUserInfo formula can inject user-related information into your workbook to build up logic based on the specific user.
App Designer
UI Controls
Advanced LabelA content control can simultaneously handle all static content of the page, as well as dynamic labelling based on named ranges defined in the spreadsheet.Button ControlA button control is used to trigger specific actions in the workflow of an application, such as navigation, calculation, and saving.CalendarA calendar control is a basic control that allows user to select dates and/or times for data entry. Each calendar control must be associated with a Single…ChartsA chart is a complex output control that allows users to display a visual representation of a data set in the user interface.CheckboxA checkbox control allows end users to enter a TRUE or FALSE value. Each checkbox must be associated with a bool named range in the workbookContainersA container is a subsection that can help subdivide a section into multiple vertical segments. Style You can select a Well style from the Small, Medium, or…DropdownA dropdown control allows users to select a value from a defined list for data entry. Each dropdown must be associated with a Single Named Range (SNR) in…File UploadA file upload control is a drag-and-drop control that allows user to upload files to the server for storage upon performing a save action.GaugesGauges are output controls that display a visual representation of a cell value in the user interface. Widely used in data analysis and presenting key…Input GridsAn input grid is a control that allows the user to select and edit a range of items corresponding to a Table Named Range (TNR) from the spreadsheet model.MapsA map is a complex output control that allows users to visualize geographic data and its relationships. You can choose from hundreds of available maps and…Output GridAn output grid is a control that allows the user to view a range of items corresponding to a Table Named Range (TNR) from the spreadsheet model.Radio ButtonA radio button list control allows users to select a value from a defined list for data entry. Each radio button list must be associated with a Single Named…SectionsA section is a row in the user interface that can be subdivided to break up the screen. All components must be placed within a section.Simple LabelLearn how to use the Simple Label control in SpreadsheetWeb Designer to display formatted text, markup, and dynamic Excel data using named ranges. Create…SliderA slider is a control that allows user to input values by shifting a horizontal or vertical button within a predetermined minimum and maximum values.TextboxA textbox is a basic control that allows user to input values for capture, storage, or calculation. Each textbox must be associated with a Single Named…