SpreadsheetWEBConnectionString

You are here:

 

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.