Skip to content

CINFO

The CINFO formula is used to retrieve one of the following data items from the report currently running:

  • AppURL
  • CalumoURL
  • ClientTimezoneOffset
  • HostName
  • ReportName
  • ReportURL
  • ReportURLWithQueryString
  • UserFileURL
  • UserInGroup
  • UserName
  • ViewURL

Syntax

CINFO (Arg1, Arg2…Arg20)

Arguments

Arg1 : string (required)

Specify the value of the first argument.

AppURL

The full URL to a CALUMO App.

The 2nd argument for this function will be the name of the app.

CALUMOURL

The full URL of the CALUMO host server.

ClientTimezoneOffset

The timezone offset integer for the client, e.g. If you are running in Australian Eastern Daylight Time, this will be 10.

HostName

Name of the CALUMO host server.

ReportName

Name of the current report.

ReportURL

URL of the current report, or another report if Arg2 set (to another report name)

The 2nd argument for this function will be the name of the report.

ReportURLWithQueryString

The full URL used by the current report including the querystring parameters (Only works for a Published Report).

UserFileURL

The full URL to download a CALUMO User File of the given name.

The 2nd argument for this function will be the name of the user file that was uploaded without the extension.

UserInGroup

“True” or “False”.

The remaining argument(s) for this function will be the name of the Group(s). The very last Arg can be “ANY” or “ALL” (the default is ANY) to specify whether the current user must be in ALL groups listed or ANY.

UserName

The current user in the format: DOMAIN\username.

ViewURL

The full URL to a CALUMO View of the given id.

The 2nd argument for this function will be the id of the CALUMO View.

Arg2 : string

This arg is for the case where Arg1 requires it - such as in the case of Arg1 being “AppURL” or “UserInGroup”. For “AppURL”, the name is specified here, for “UserGroup” all Args starting from Arg2 are groups. It can also be ANY/ALL, which is last if specified (default is ANY).

ArgN : string

Any further arguments that may be required or optional (currently only UserInGroup has optional multiple arguments).

Examples

  • CINFO(“AppURL”, “All Reports”) - returns the URL of the App named “All Reports”, if it doesn’t exist, it will still create the URL, but it won’t be valid.
  • CINFO(“ReportName”) – Returns the name of the current report.
  • CINFO(“ReportURL”) – Returns the URL of the current report.
  • CINFO(“ReportURL”, “nameOfReport”) – Returns the URL of the report named in the 2nd argument.
  • CINFO(“ReportURLWithQueryString”) – Only works for a Published Report, and will return the full URL used by the current report including the querystring parameters.
  • CINFO(“UserFileURL”, “MyPdfFile”) - returns the URL of the User File named “MyPdfFile”, if it doesn’t exist, it will still create the URL, but it won’t be valid.
  • CINFO(“UserInGroup”, “Administrators”) - returns “True” if current user is in group “Administrators”.
  • CINFO(“UserInGroup”, “Administrators”, “Finance”) - returns “True” if current user in is in either Administrators or Finance groups (ie default for last Arg is ANY).
  • CINFO(“UserInGroup”, “Group1”, “Group2”, ALL) - returns “True” if current user is in both Group1 and Group2 (ie all groups listed must be matched).
  • CINFO(“Username”) – Returns the username of the current user in the format, DOMAIN[username].
  • CINFO(“ViewURL”, idOfView) – Returns the URL of the CALUMO View specified in the 2nd argument. In this case the second argument is a number.