SpreadsheetWEB allows you to create web application that can save data to a database. For more information on how to enable this feature using the Wizard, please click here.
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.
To view a data record, click on the link of the data record in 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.
In the status column, data records can be assigned a status. The default status options are 'new', 'pending' and 'approved'. The status dialog also allows the transfer of this data record to another user.
It is possible to customize the status definitions using the button 'Options' above the data table.
To edit a data record click on the edit button (pencil icon) of the data record in the table. Clicking the edit button will open the web application filled with the data of this specific data record. It now possible to change values and then store the edited record by clicking the 'save' button.
The copy function allows you 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.
The history dialogs provide an overview about the history of events for a data record.
To delete selected data records first activate the check boxes of the data records you wish to remove, then click the button 'Delete selected records'.
Click the button 'Delete all records'.
You can download an Excel report, which contains selected data records, by clicking the button 'Download selected records' above the data table.
You can download an Excel report, which contains all currently stored data records, by clicking 'Download all records'.
The option dialog allows you to customize and insert new status definitions. These status definitions will be used in the status column of the data table as well as in the status dialog. You can now also change the color associated with each individual status. This color will show up in the data tab, highlighting each various status ID. This can be done by clicking on the button next to the status type in this window.
