Skip to main content
Session functions use the snapshot supplied by the current Dsync screen or workflow. They are useful for client-facing routing and labels, but they do not replace server-side access control.

​
AppId

Returns the ID of the current TeamDesk database.
  • Syntax: AppId()
  • Requires: an active session snapshot.
  • Returns: Text.
  • Best for: integration payloads and database-aware links.

​
BackURL

Returns the back-navigation URL supplied by the current screen or workflow.
  • Syntax: BackURL()
  • Requires: an active session snapshot with back-navigation information.
  • Returns: Text URL.
  • Best for: return links after a client action.

​
Browser

Returns the current client device class.
  • Syntax: Browser()
  • Requires: an active session snapshot.
  • Returns: Text: Desktop, Tablet, Mobile, or TV.
  • Best for: presentation choices and client-side routing hints.
Do not use browser class as an authentication or authorisation check.

​
ColumnId

Returns the unique ID mapped to a column.
  • Syntax: ColumnId([Column]) or ColumnId("Column Name")
  • Requires: an active session snapshot containing column identities.
  • Returns: Text ID, or empty text when the column is not mapped.
  • Best for: metadata and integrations that address columns by stable ID.

​
Exists

Checks whether a selected reference record exists and is accessible in the current session.
  • Syntax: Exists(referenceName)
  • Requires: Text identifying a reference present in the session snapshot.
  • Returns: Boolean.
  • Best for: guarding client presentation or workflow steps that depend on a related record.

​
IsUserEmail

Checks whether an email belongs to a known database user.
  • Syntax: IsUserEmail(email)
  • Requires: Text email and an active session user directory.
  • Returns: Boolean.
  • Best for: validating user selections and assignment inputs.

​
RecordId

Returns the internal ID of the current record.
  • Syntax: RecordId()
  • Requires: an active record session snapshot.
  • Returns: Text.
  • Best for: deep links, integration correlation, and record labels.

​
Role

Returns the current user’s role or the role attached to another User value.
  • Syntax: Role() or Role(user)
  • Requires: an active session; the optional argument must be a User value.
  • Returns: Text role name, or empty text when the supplied user has no role.
  • Best for: role-aware client presentation and workflow defaults.
Use server-side permissions for access control. A formula result is not an authorisation boundary.

​
TableId

Returns the ID of the current table.
  • Syntax: TableId()
  • Requires: an active session snapshot.
  • Returns: Text.
  • Best for: integration payloads and table-aware links.

​
ToUser

Looks up a User value by email.
  • Syntax: ToUser(email)
  • Requires: Text email and an active session user directory.
  • Returns: User, or null when no user matches.
  • Best for: turning imported or entered email addresses into assignable users.
Email matching ignores case.

​
URL

Returns the full URL of the current page.
  • Syntax: URL()
  • Requires: an active session snapshot with page URL information.
  • Returns: Text URL.
  • Best for: share links and integration context.

​
URLRoot

Returns the protocol and site portion used to access TeamDesk.
  • Syntax: URLRoot()
  • Requires: an active session snapshot with URL-root information.
  • Returns: Text URL root.
  • Best for: building stable links to other pages in the same site.

​
User

Returns the user currently accessing the database.
  • Syntax: User()
  • Requires: an active session snapshot.
  • Returns: User.
  • Best for: defaults, attribution, and user-specific presentation.

​
UserToEmail

Returns the email address stored on a User value.
  • Syntax: UserToEmail(user)
  • Requires: a User value.
  • Returns: Text email.
  • Best for: messages and integration payloads.

​
UserToName

Returns the display name stored on a User value.
  • Syntax: UserToName(user[, format])
  • Requires: a User value and optional "FF" or "LF" format. FF is the default display order; LF converts a multi-part name to last-name-first when possible.
  • Returns: Text name.
  • Best for: greetings, assignments, print output, and sorted labels.
Keep a person as a User value while making assignments. Convert to name or email only when displaying or exporting it.
Last modified on September 7, 2026