SpreadsheetWEBConnectionString
SpreadsheetWEBConnectionString is a custom function used for getting an encrypted connection string for the application's parent site.
Works in Converted Applications only
SpreadsheetWEBConnectionString is a custom function used for getting an encrypted connection string to be used with DBOpen functions. The encrypted connection string is generated on a site-basis, and only allows accessing the applications in that site.
Use the SpreadsheetWEBConnectionString to avoid exposing the connection string that contains your database credentials, as well as updating the connections string when moving applications from one site to the other.
Syntax
=SpreadsheetWEBConnectionString()
| No argument |
Returns
String. Returns an encrypted version of the connection string which points to the parent site of the application.
Examples
Formula | Description |
|---|---|
=SpreadsheetWEBConnectionString() | Returns the value into the originating cell. |
| =DBOpen(SpreadsheetWEBConnectionString(),,) | When using in combination with a DBOpen function, the function returns a value to the originating cell. Pooling is enabled. |