There are three types of applications that can be created with SpreadsheetWEB:
- Web Applications are the default applications that you can create from an spreadsheet. Web applications captures user interface and calculation logic in your spreadsheet. They can also collect user data (transactions) through database integration.
- Web Services are used when another application need to communicate with a spreadsheet to use its calculation algorithm.
- Dashboard Reports are interactive data visualization applications. They can be tied to the database of an existing data collection web application. Alternatively, you can import any data to SpreadsheetWEB and build a report.
All applications are listed in a table. If you have more web applications than can be listed on a single page, the table will be spread out over several pages.
An example Web Applications list in SpreadsheetWEB Control Panel
An explanation of symbols and buttons seen on this page can be found below:
|Applications||Displays the name of the application as a link. Upon click, application will open in a new browser window|
|Download the Excel file associated with the applications|
|Shows the web address (URL) of a web application|
|Shows WSDL location of a web service|
|Edit settings of an application|
|Open data tab|
|Creation Date||Creation date of an application|
|Online|| Shows whether an application is online of offline:
: online - application is published
: offline – application is offline, cannot be accessed over the internet
|Access|| : everybody can access the application
: access restricted to registered users
|Group||Name of the group application is associated with|
To find out the web address of a web application click on in the list of web applications. A new screen will appear displaying the name and address of your web application. See the screenshot below.
An example web application URL found using the Control Panel.
Click the icon in the data column to open the data tab to view, download and work on saved data of a web application. Please note: the data tab and database functionality are only available if activated and set up during conversion with the SpreadsheetWEB wizard.
An example data tab that allows the user to view, download, and work on saved data.
Check the box of the applications you wish to remove.
In applications, select the applications you wish to delete in the list of web applications by ticking the respective check boxes. Then click on Delete selected applications above the table. The page will refresh, now showing the updated list of web applications - those that are currently stored in your account with the selected ones now removed.
To change the name of a web application, go to the applications tab and browse to the web application you wish to edit and in the same row click the button. A new page will appear with a table showing the current settings of your web application. In the top row, simply overwrite the existing web application name and then click save at the bottom of the page.
To update the Excel spreadsheet that is linked to an application, go to the applications tab and browse to the application you wish to edit and in the same row click the button. A new page will appear with a table showing the current settings of your application.
In the second row it says Excel spreadsheet. Here you can simply upload a new Excel spreadsheet. Important: only Excel spreadsheets that prior to uploading have been processed with the SpreadsheetWEB Wizard can be used here. That means that if you have changed anything in the Excel file, you need to convert the file again using the SpreadsheetWEB wizard, save and close the file before you can upload it.
To assign an application to a user group, it is required that you have already created a user group. The steps to create a new user group will be explained farther in the document.
Assigning an application to a group of users can be done while adding an application or at any time afterward.
If you already have an application that you want to assign to a group, please go to the applications tab, then browse to the web application you wish to edit and in the same row click the button. A new page will appear with a table showing the current settings of your web application. Go down to the row where it says Add to group(s) and select the group that you want your web application to be assigned to. When you are done, click save.
Restricting access to an application is a multiple-step process.
- It is required that you have created a group.
- At least one user must be assigned to that group.
- Access must be changed to restricted.
- The web application must be assigned to the same group.
For step 3 and 4, click the applications tab in the navigation menu. From the list of web application, find the one that you want to restrict access from and click the button in the same row. On the next page, please go to the row where it says Access and activate the option button next to restricted. To assign the web application to a group, go to Add to group farther down in the table and select a group from the combo box.
To change the online/offline status of a web application, click the applications tab in the navigation menu and browse to the application you wish to edit and in the same row click the button. A new page will appear with a table showing the current settings of your web application.
Go to Status and activate either the option button online, if you wish your application to be available on the web, or offline if you wish that your application is only stored in your account but not yet available for others on the web.