SpreadsheetWEB has several specific formulas that pertain solely to SpreadsheetWEB. The purpose of these formulas is to query data collected by another SpreadsheetWEB application:
The Application ID is the same ID that can be found in the URL of the application from which you are attempting to attain data. The FieldName is the name of the column that filtering will be applied. For example, if the Column name is "Name" then the FieldName in this case is 'Name'. The FieldValue is the filter value that will be applied on the column.DisplayFieldName is the name of the column whose value will be returned from the formula with respect to filtering. If DisplayFieldName is blank then FieldName column will be used to return the value.
The FieldName in this case is an image file. It will download the image and render it into the cell that has this equation by resizing the image. The developer of the excel file needs to keep the size of the cell large enough so that the image will be viewable when resized by SpreadsheetWEB. Follow the example above in SpreadsheetWEBdata for what each individual piece of the equation refers to.
The FieldName in this case is a file type other than an image. This equation will create a hyperlink in the web application. When the user clicks on the hyperlink, the web application will download the file. Follow the example above in SpreadsheetWEBdata for what each individual piece of the equation refers to.
If there is no data or file corresponding to the parameters of SpreadsheetWEBdata,SpreadsheetWEBFile or SpreadsheetWEBImage, then the formula returns #N/A.
Spreadsheet WEB supports presentation of images using the SpreadsheetWEBimageLink formula. SpreadsheetWEBimageLink (cell reference) takes the relative or absolute address of the images which can be located on the internet or intranet.
To create a static image web application which fetches images directly from a server, you must create a hyperlink pointing to an image. This image could be residing on the internet or intranet. We can use a link such as http://www.spreadsheetweb.com/media/logo-pagos.jpg to construct such an application. See the image below.
To create dynamic image web applications that fetch images directly from a server, we can create an application in Excel which takes 2 inputs as numeric values .We can use Excel's Hyperlink formula [ =Hyperlink (link location) ] to create a dynamic link based on the values of these inputs as seen below.
The Hyperlink, which is seen in blue (default), is based on values which will be inserted by the user of the application. The cell below the hyperlink has our formula [ =SpreadsheetWEBimageLink (cell reference) ]. Cell reference will point to the cell where it will read the hyperlink. In our case we have inserted the hyperlink at cell B3 so the complete formula would be [ =SpreadsheetWEBimageLink (B3) ]. Once this application is uploaded to the Spreadsheet WEB server it will automatically run the formula and display the images if it exists on the same server with the address we assigned in the hyperlink. See the image below.
We are connecting to an image server and requesting images depending on the inputs. SpreadsheetWEBimageLink (Cell Address) does the work of getting the images and displaying them in the browser.
By typing in =SpreadsheetWEBUserRole into a cell prior to conversion, the cell will retrieve the application user's "role" in the web application. For example, if someone who is not logged in gets access to the web page, then the equation will reflect 'Anonymous'. This can be used to set up IF statements to disable worksheets or individual inputs depending on the user type.
By typing in =SpreadsheetWEBUserName into a cell prior to conversion, the cell will retrieve the application user's name in the web application. If they have no account with SpreadsheetWEB, then it will display 'Anonymous'. Otherwise, it will retrieve the name linked with the account used to log in to the web application. This can be used in a similar manner as SpreadsheetWEBUserRole in order to set specific restrictions or privileges for individual users.
By typing in =SpreadsheetWEBUserEmail into a cell prior to conversion, the cell will retrieve the application user's email address in the web application that has been captured during that user has been created within SpreadsheetWEB's user management module.If someone who is not logged in gets access to the web page, then the equation will reflect 'Anonymous'. This can be used to build up email automations and have the email sent to or sen from the user who saved a record of the application.