FieldName is a file type other than image, it will render the data as text on the web-page. 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 RecordIdentifier is the ID of the record for which you are attempting to get data. For example, of the Data tab shows that for your application there is a Record titled 'John', then the RecordIdentifier in this case is 'John.' The FieldName is the column header for the type of data you want. For example, if one of the column headers in the web application is 'Age', then that is an appropriate FieldName. Therefore, if we wanted the age of John in an application with the ID 5b82e9eb-f006-4641-a96f-5a537810fdf9, we would type in:
=SpreadsheetWEBdata(5b82e9eb-f006-4641-a96f-5a537810fdf9,John,Age)
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.
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.
Creating a static image display application:
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.
We have constructed this application with the hyperlink in Cell A. Now, we need some way to display this image in our web application. For this, we will use the SpreadsheetWEBimageLink formula which takes the address of the cell containing the link or the direct link and renders the image. In our case we typed this formula in Cell A2 as =SpreadsheetWEBimageLink (A1). All we have to do is upload this application to the Spreadsheet WEB Server and our image will be displayed in the browser.
Creating dynamic image display applications
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.
SpreadsheetWEBUserRole
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.
SpreadsheetWEBUserName
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.