>> How to provide a name for the worksheet
>> Save Options
>> E-mail form
Enter a name in the text field marked Worksheet Name. If you want to use the default settings for the other settings, you can click "Next >>" now to go
straight to the next step. Otherwise, the rest of the settings on this page are
explained below.
To perform calculations and other operations, SpreadsheetWEB adds buttons to the web application such as Calculate or Reset.
Click the check boxes to include buttons on the web page. If they remain unticked, then they will not be added to the finalized web application.
"Calculate" - Processes the user input and delivers output based on the functions included in the web application.
"Reset" - Resets the input cells to default values as defined during the conversion process in the Wizard.
"Save" - Saves data to a database; stored data can be viewed in the
Control Panel or downloaded as an Excel compatible file.
"Send Results" - Submitted web forms are sent to the e-mail address provided here.
"Enable Ajax based automatic calculations" - Activate this box to enable automatic calculations.
Pressing the 'calculate' button is no longer required if this option is selected.
SpreadsheetWEB allows for custom button positioning. Simply click the select button as indicated in the following screenshot. Select a cell in the worksheet to position the button.
If you do not define custom button positions they will be placed at the bottom of the web application.
This feature allows you to create a web application that can save the current data to a database upon request (i.e. when a user clicks the save button). Saved data can later be viewed from the Control Panel or downloaded as an Excel compatible data file. This process is described in the SpreadsheetWEB Control Panel section of this help document.
The following screenshot shows an Excel-compatible file that contains data saved from a web application. In the web application, two users have clicked the save button. Accordingly, SpreadsheetWEB created two data sets in the Excel data file - in rows 2 and row 3. The first row carries the column titles, which are defined by the owner of the web application.
To activate the Save-to-Excel feature, click the check box next to save.
Once you have activated the check box, the SpreadsheetWEB wizard will disappear and the following window will appear. Here you need to select the cells whose current values you wish to be saved when a user of the web application clicks the save button. These are simply the values that you want to be able to see when you open up the Excel file from the database (e.g. if they are entering their name, you would want to select it so that you could see their name saved in the database).
After you have selected all cells and confirmed your selection by clicking OK, a new window will appear asking you to enter Column Identifiers for the cells you have selected in the previous step. It is recommended to enter different names or descriptions so that later on it is possible to identify these cells in the database or the Excel compatible data file. In the column 'Column Type' you can specify what type of stored data each cell will represent. Cell Link contains references to the selected cells.
After confirming with OK this window closes itself and the main SpreadsheetWEB Wizard window will appear again.
To rename the button enter a new name in the text box.
To view saved data, please log in to the control panel and visit the data tab. Here you can view individual data records or download all records as an Excel compatible report. Please click here for more information
To send configurable auto-response emails, click on Options for Save. Bear in mind that the Save option needs to be selected in the worksheet for you to access the Options button.
A new window will appear with options for Auto-Response Email, Notification Email and Page Forwarding.
Auto Response Email ? What is it?
With this feature, you have the ability to send a custom email to users when they click on the
"Save" button in your application.
Notification Email ? What is it?
With this feature, developers can easily send themselves a notification email when new data is submitted.
Page Forwarding ? What is it?
This feature provides the ability to forward users to another page after their data is submitted. This can either be a URL entered or a custom page you've create using SpreadsheetWEB.
Selecting the Email Body (Auto Response Email/Notification Email)
When you click on the 
icon for this field, you will be prompted to select a range for the email body. The content found within this range is what will be emailed to the user when they click on the
'Save' button in the application. To select the range, follow the same steps you use when selecting the Display Area Definition. For more information please see How to select the Display Area
Selecting the Email Subject (Auto Response Email/Notification Email)
When you click on the
icon for this field, you will be prompted to select a cell for the email
subject. The content found within this cell will appear as the subject of
the email.
Recipient Email Field (Auto Response Email/Notification Email)
When you click on the
icon for this field, you will select the recipient's email, which can be taken directly from a cell or, alternatively, by using a VLOOKUP formula to select email addresses.
External URL (Page Forwarding)
Enter a URL in this text box. When a user clicks on the 'Save' button in the application, he/she will be re-directed to this URL.
Custom Page
You can create a custom page using SpreadsheetWEB. When you click on
the
icon for this field, you will be prompted to select a range to be used in the custom page. When a user clicks on the
'Save' button in the application, he/she will be re-directed to the custom page. To select the range, follow the same steps you used when selecting the Display Area Definition. For more information please see How to select the Display Area
This option allows users to send you an email with the current contents of the web application, including calculated results, charts, etc. With SpreadsheetWEB you can send calculated results to an e-mail address that is specified in this step of the Wizard. Currently, these e-mails are html files. Please make sure your e-mail application supports html-emails and the html option is not turned off.
To activate this feature, activate the check box next to E-Mail. This will insert another button in the application. When a user clicks on it, an email with the current contents of the web application will be sent to the email address specified in the text field next to E-mail Recipient. You can change the label of the button by entering a different value next to E-Mail.
Note: This feature cannot be used with Outlook 2007 because it uses Word 2007's html rendering engine, which does not fully support html. You can still receive emails in Outlook 2007 but you will be required to open the emails with an internet browser to view the full contents.
Checking 'Unique Option' next to a saving cell will allow you to set fields in the database which will be unique.
Inserts a 'Next' or 'Back' button in the application to navigate to the next or the previous worksheet - depending on the order of worksheets as set up in the application overview (first step after welcome screen). This functionality is only available in multiple worksheet applications.
These buttons can be placed anywhere within the display area of the worksheet.