‘’Application’’ page is where one can find information about web application and can update the web application. ‘’Application’’ page can be utilized to modify settings that are specific to the web application. The screen is available through pressing Edit on the Designer Home Page. Application page includes three sections:
Edit Existing Settings
This section lets users edit existing settings of the designer application.
Web Service Key
Web Service Key textbox is an information-only field that displays the unique identifier for the application when utilizing the SpreadsheetWeb API for consumption can be found. Unlike other information that exists in this section, Web Service Key is not editable.
The name of the web application can be modified from the Application Name textbox.
Enable Google Analytics
SpreadsheetWeb also supports Google Analytics for Designer Applications. In order to use it, Enable Google Analytics checkbox needs to be to checked the and the tracking ID must be entered to the Google Analytics Key input. A new tracking ID for the application can be retrieved by using the Google Analytics control panel. The domain address of the application should be entered correctly in order for Google Analytics to function as expected. After the application is saved and published, application’s hits from the Google Analytics tracking site can be monitored.
Designer applications can be configured to use different color sets in visualizations, i.e. charts, and maps. The desired color set can be set by clicking Edit Default Colors button. Color manager window will allow to select a color set from the pre-defined sets. Also, a desired color set can be chosen too.
Designer applications support different Culture settings which can be used to set how the thousands and decimal separators will be shown.
Enable Record Locking
If your designer application has Save Event, Enable Record Locking feature will help to lock a record to other users while another user is editing it.
Inactive Record Locking Timeout
If Enable Record Locking is enabled, this value can be set with following format “hh:mm”. Setting this value means that a record will be locked for the selected duration for other users but for the user which opened the record first.
Prompt User Confirmation on Log Out
Enabling this feature will ask for a confirmation from the user before logging out of the application. By using this feature, users can reduce the risk of logging out from the application with unsaved data.
This section includes of features to modify the visualization of the application.
The Favicon allows users to modify the associated icon that shows up in the tab of the user’s browser. To upload a favicon, click on edit then select an image to upload or simply drag and drop your favicon into the drop zone. Once the file has been successfully uploaded, you can press the Upload button to save the favicon for your application. PS: The permitted format for favicon images is *.ICO, which can be generated using a standard image and any number of web-based or desktop-based image editing tools.
This feature allows users to modify the image that is displayed in the navigation bar of the application. To edit navigation bar branding, click on edit then select an image to upload or simply drag and drop an image into the drop zone. Once the file has been successfully uploaded, you can press the Upload button to save the navigation bar branding for your application. PS: The permitted formats for branding images are *.PNG, *.JPEG, *.JPG, *.GIF, and *.SVG, which can be generated using a standard image and any number of web-based or desktop-based image editing tools.
This feature allows users to modify the image that is displayed on the background of all pages in your web application. To edit the background image, click on edit then select an image to upload or simply drag and drop an image into the drop zone. Once the file has been successfully uploaded, you can press the Upload button to save the background image for your application. PS: The permitted formats for background images are *.PNG, *.JPEG, *.JPG, and *.GIF, which can be generated using a standard image and any number of web-based or desktop-based image editing tools. Please make sure that your image file is under 2MB in size.
Upload New Workbook
From this section the underlying Excel model for the application that includes all information for the application can be updated. In order to update the workbook, simply select the Excel file by clicking on the Spreadsheet File drop zone or drag and drop your file into the browser window. Upon updating the model and pressing the Update button, all of the named ranges will be updated and SpreadsheetWeb’s internal system validation will run to ensure that the new model is compatible with the existing user interface, database, and page design. If there are any incompatibilities, the system will redirect user to the Validation Messages screen, where these issues will be further detailed. PS: Updating the Excel model from the design mode will not affect any published versions of the application. The published version will continue to utilize your existing calculation engine until the new version is published, at which point the new Excel model will be the production version. However, the I/O changes from the Excel model will be applied to the designer components themselves (e.g., user interface, page, and database designer will reflect updated named ranges), as well as within the preview of the current transaction (i.e., previewing the transaction will use the new Excel model for calculations).