-
App Creation
-
- Creating a Designer Application
- User Interface
- Pages and Navigation
- Database
- Print Process
- Email Process
- Excel Export
- Stylesheets
- Custom Actions
- Text Resource (Run-time) Editor
- Queries
- Goal Seek Event
- Solver Event
- Application
-
- Sections
- Containers
- Textbox
- Checkbox
- Dropdown
- Radio Button
- Calendar
- File Upload
- Input Grids
- Slider
- Content
- Output Grid
- Charts
- Maps
- Gauges
- Action Button
- Show all articles ( 1 ) Collapse Articles
-
-
App Management
-
Data Management
-
Users and Teams
-
Developers
-
-
- GetDocumentStubs (Application-Level)
- GetRecordExtended (Application-Level)
- GetRecord (Application-Level)
- GetBatchResults (Application-Level)
- GetResult (Application-Level)
- CloseDedicatedSession (Application-Level)
- OpenDedicatedSession (Application-Level)
- SendEmail (Application-Level)
- GenerateDocument (Application-Level)
- MergeDocumentsExtended (Application-Level)
- MergeDocuments (Application-Level)
- DeleteUser (Site-Level)
- UpdateUser (Site-Level)
- CreateUser (Site-Level)
-
-
-
Administration
-
Changelog
- Version 6.27
- Version 6.26
- Version 6.25
- Version 6.24
- Version 6.23
- Version 6.22
- Version 6.21
- Version 6.20
- Version 6.19
- Version 6.18
- Version 6.17
- Version 6.16
- Version 6.15
- Version 6.14
- Version 6.13
- Version 6.12
- Version 6.11
- Version 6.10
- Version 6.9
- Version 6.8
- Version 6.7
- Version 6.6
- Version 6.5
- Version 6.4
- Version 6.3
- Version 6.2
- Version 6.1
- Version 6.0
- Version 5.2
- Version 5.1
- Version 5.0
- Version 4.8
- Version 4.7
- Version 4.6
- Version 4.5
- Version 4.4
- Version 4.3
- Version 4.2
- Version 4.1
- Version 4.0
- Version 3.5
- Version 3.4
- Version 3.3
- Version 3.2
- Version 3.1
- Version 3.0
- Version 2.5
- Version 2.4
- Version 2.3
- Version 2.2
- Version 2.1
- Version 2.0
- Version 1.6
- Version 1.5
- Version 1.4
- Version 1.3
- Version 1.2
- Version 1.1
- Version 1.0
- Show all articles ( 44 ) Collapse Articles
-
Other Features
-
Connectors
-
Integrations
SpreadsheetWEBConnectionString
Created On
byIlker Burhan
You are here:
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. |