Legacy Platform documentation
Custom Worksheet Formulas
Explore 12 practical guides for Custom Worksheet Formulas in SpreadsheetWeb Legacy Platform, with setup instructions, examples, troubleshooting guidance, and…
Start here
Custom Worksheet Formulas guides
DBOpen and DBGetDBOpen and DBGet are custom SpreadsheetWEB functions used for database calls. While DBOpen establishes a connection between the application and the…SpreadsheetWEBAttachmentYou can use this function for SpreadsheetWEB attachment to return the status of an attachment field in your workbook as "uploaded" or "empty".SpreadsheetWEBConnectionStringSpreadsheetWEBConnectionString is a custom function used for getting an encrypted connection string for the application's parent site.SpreadsheetWEBCounterThis function will give the number of times a new entry was created in the database for the given application for counting the number of records.SpreadsheetWEBdataThe SpreadsheetWEBdata function can retrieve data from another web application using the URL of the application from which you want to retrieve data.SpreadsheetWEBFileSpreadsheetWEBfile function creates a hyperlink in the web application. When the user clicks on the hyperlink, the web application will download the file.SpreadsheetWEBImageThe SpreadsheetWEBimage function can be used to download the image and render it into the cell that has this equation by resizing the image.SpreadsheetWEBimageLinkSpreadsheetWEBimageLink (cell reference) takes the relative or absolute address of the images which can be located on the internet or intranet.SpreadsheetWebRecordInfoThe SpreadsheetWEBRecordInfo formula allows user to pull in data about the current record into their spreadsheet for reference.SpreadsheetWEBStatusIndexYou can use this function to retrieve the SpreadsheetWEB status index in the form of an ID number for the active record and use this data in your workbook.SpreadsheetWEBUserInfoThis function displays SpreadsheetWEB user info such as email or role, as they were set during account creation, or from the My Account page.SpreadsheetWEBUserRoleThis function can retrieve the SpreadsheetWEB user role into a cell in your workbook and you can use this feature to in your workbook logic.