Setting Global Variables

Adding Variables

To add a global variable:

1. Open the tab "Admin" and select "Variables". All existing variables are listed.
    
2. Click "New Variable". A new row opens. INFO: The data for 'Created' and 'Modified' is automatically given, when creating a new variable.
    
3. Enter the name and value of the variable in the respective field. 
    
4. Click the 'checkmark icon' to confirm. The variable is added. 
    

Editing Variables

 To edit a global variable:

1. Open the tab "Admin" and select "Variables". All existing variables are listed.
    
2. Click the 'pencil icon' in the row of the variable to edit or click directly in the field you want to edit. 
    
3. Edit the name and/or value for the selected variable.
    
4. Click the 'checkmark icon' to confirm. The variable is edited.
    

Deleting Variables

 To delete a global variable:

1. Open the tab "Admin" and select "Variables". All existing variables are listed.
    
2. Click the 'trash icon' in the row of the variable to delete. A dialog opens.
    
3. Confirm with "Ok". The variable is deleted. 
    

Searching Variables

To search for a variable name, enter a string into the search bar. The result list contains all variables that have a match to the entered string. INFO: The search feature is case insensitive. That means you can't create and use a variable ${ABC} and ${abc}. 

Using Variables

Syntax used to refer to a variable

Example

Enter the file path for an import job:

File path used:

Using variables in workbooks