Widgets Overview


Widgets are special mini-applications that can be embedded in a Jedox Web spreadsheet. Technically, they consist of HTML and JavaScript code that is either directly fetched from the API of an external source (such as Google Maps) or — similar to a macro — defined within the application itself.

Some examples of widgets include:

  • news ticker that refreshes automatically
  • graphic clock
  • integrated calendar tool
  • map

Data can be passed to widgets from the worksheet, and the widget can return data to the worksheet.

Widget enhancements

It is possible within the Widget HTML code to create a hyperlink with the function __hyperlink() or to call the function __macro() with three possibilities.

Examples of function calls:

You can call PHP macros with the function __macro(). A double array is not necessary for a single macro.

__macro(['Module1.foo2', 'bar2'])

__macro([['Module1.foo2', 'bar2'], ['Module1.foo3', 'bar3'],…])

bar2 and bar3 are values that are passed to the macro foo2 or foo3.

The PHP API has the following functions to access some of the features of Jedox from external PHP scripts:

jedox_is_logged_in()   – TRUE/FALSE if the current user is logged in
jedox_get_username()   – gets the user name of the logged in user
jedox_get_password()   – gets the password of the logged in user
jedox_get_groups()  – gets the groups of the user
jedox_get_locale()   – gets the current locale of the user
jedox_get_theme()     – gets the current theme of the user
jedox_get_sid()   – gets the current session ID of the user

Related links: