Sample Code – Overview

Export to CSV and Excel

You may clone all examples from git at this repository: https://github.com/SigmaEstimates/AppScript-Examples.git In the Export to CSV and Excel example, you can learn how to create a Ribbon tab with two buttons, that allows the user to export a Sigma insight view to either CSV or Excel. This way you can create customized exports for Sigma users....

Ini files

You may clone all examples from git at this repository: https://github.com/SigmaEstimates/AppScript-Examples.git Learn how you can store App data in the end users roaming data profile. This enables you to create specific settings for your App, based on user interaction and configuration. uses System.IO.Inifiles; const //Inifile will be stored in %APPDATA%\CodeGroup\Sigma Install Folder Name\myinifile.ini sInifileName = '%sigma_currentuser%\myinifile.ini';...

Basic webservices

You may clone all examples from git at this repository: https://github.com/SigmaEstimates/AppScript-Examples.git It is easy to consume webservices directly from Appscript. This enables integrations between Sigma and Cloud based solutions to synchronize and connect data. Example: Send the Sigma budget directly to a cloud based accounting system, or update a Sigma estimate based on values from a...

Basic UI settings window

You may clone all examples from git at this repository: https://github.com/SigmaEstimates/AppScript-Examples.git To create UI and custom dialogs, use this example to get started. It shows a basic settings window with tabs, dropdown and other controls, and how to populate with data from the active Sigma project. //First, name the unit (this name is used to potentially...

Auth2 tokens

You may clone all examples from git at this repository: https://github.com/SigmaEstimates/AppScript-Examples.git When you need to authenticate a user against a OAuth2 service, one of the challenges is handling browser involvement and getting the callback token into the Sigma program (and your App). The below example is a good start on how to do that.   //First,...