DbConnect Function

DbConnect Function DbConnect is a custom SpreadsheetWEB Hub function used for database calls. The formula allows the application to connect an external database or a SpreadsheetWEB Hub application’s database and return values to specified range reference. For...

Analytics

Analytics Page is a web analytics interface that allows workspace owners to monitor traffic and changes made to the workspace/applications and data on SpreadsheetWeb Hub. You can open Analytics Page from the menu on the left, it is subpage located under Workspaces. In...

Data Chat

Data chat feature is similar to Application chat. Users can use data chat for a specific saved record, rather than opening chat for the entire application. To open data chat go to the Data page and choose an application from the dropdown menu. All saved records of...

Assigning Tags to Records

You can assign tags to specific records. To do that, go to Data page and choose an application from the dropdown menu. All saved records will be listed. Choose a record then click on assign tag button. From the pop-up window, you can choose which tags to assign to the...

Queries

In the Queries module you can create database queries to retrieve data from applications in your workspace. Queries are created using an intuitive user interface and you can bind these queries to named ranges to use the query results in other runtime calculations....

Record History

You can see the entire history of a record using the Record History feature by clicking on the calendar icon () under the Actions column. Record history includes when the record was created and edited. It also lists by whom the edits were made. Users can also access...

Edit Columns

The Edit Columns allows changing the layout of the fields listed in the Data Page. You can add, remove columns and change their orders. You can choose new columns to add from the Add a Column list. Existing columns can be removed by pressing the trash icon or their...

Record Controls

You can add a new record or modify multiple records by using buttons at the top of the Data Page. Load the application with its default settings. A new record will not be added to the database unless the Save button is pressed in the application. Deletes selected...

Data Filters

You can use filters to narrow down the records listed based on a column. Clicking the Display Column Filters button will bring out the filters. You can modify the filters based on your search criteria. Filters work in additive fashion, meaning that selecting options...

Actions

Actions column in the Data table contains record-based operations like open, edit, download, or view history. Edit/View/Copy From this button a record can be edited, viewed, or copied. Download A record can be downloaded as an Excel file. History Brings up the Record...