Data Tab

SpreadsheetWEB allows you to create web application that can save data to a database.

 
The following information is for users who have already enabled 'saving to database' for one of their web applications and want to view saved data in the control panel.
Click on the 'data tab' in the navigation bar.

In the next step, use the combo box to select the web application whose data records you wish to work on. The data records stored for this web application will be displayed in the table below. Each row represents an individual data record.

An example data tab that displays data from the test application. 

View Data

To view a data record, click on the data record link located on the table. For example, in the screenshot above these links would be in the left column with the title 'Year'. Clicking one of the links will open the web application filled with the data of this specific data record. 

Status

Data records can be assigned a status in the status column. The default status options are 'new', 'pending' and 'approved'. The status dialog also allows you to transfer this data record to another user. The Status Names screen will also allow the user to determine a color that will correspond to a certain status. This will simply highlight each individual row under the data tab based on the status of the end-user, making it easier for the user to organize data.

An example status change window. It's possible to customize the status definitions using the 'Options' button above the data table. 

Edit

To edit a data record, click on the button of the data record in the table. Clicking this button will open the web application filled with the data of this specific data record. It is then possible to change the values and then store the edited record by clicking the 'save' button. 

Copy

The copy function allows the user to open a data record in duplicate mode. First it can be edited, then after pressing save, a new data record is inserted in the data table. 

Delete selected data records

To delete selected data records, first activate the check boxes next to the data records you wish to remove and then click the button 'Delete selected records'. 

Delete all data records

Click the button 'Delete all records'. 

Download selected data records

You can download an Excel report that contains selected data records by ticking the check boxes next to the data records you wish to save and then clicking the button 'Download selected records' above the data table. 

Download all data records

You can download an Excel report that contains all currently stored data records by clicking 'Download all records'.