File Name Formula Help
Formula functions are similar to Microsoft Excel Formulas. Not all Excel functions are relevant and supported. Formula Evaluation is based on Open Source, Apache POI
All formulas listed may not be relevant to workflow application. Here are the list of formulas: http://poi.apache.org/components/spreadsheet/eval-devguide.html
Note: Syntax checker is not available in User Site for formula entry. If there is a Syntax error in the formula, file will be named as 'FileNameFormulaFailed'
Certain Variables from the workflow application are available to use in the formula. Availalbe variables are listed under each workflow below.
Sample Formulas
| Formula | Result |
|---|---|
| YEAR(NOW()) & "-" & MONTH(NOW()) & "-" & DAY(NOW()) & "-" & HOUR(NOW()) & MINUTE(NOW()) & SECOND(NOW()) | 2018-12-21-102657 |
| YEAR(NOW()) & "-INVOICE" | 2018-INVOICE |
|
_[UserId] & "-" & YEAR(NOW()) & "-" & MONTH(NOW()) &
"-" & DAY(NOW()) Note: 'UserId' is a variable |
TOM-2018-12-21 |
|
_[Metadata1] & "-" & MONTH(NOW()) & DAY(NOW()) &
YEAR(NOW()) & "-" & HOUR(NOW()) & MINUTE(NOW()) &
SECOND(NOW()) Note: 'Metadata1' is a variable |
DOC-142019-192311 |
| TEXT(TODAY(), “mm-dd-yyyy”) Note: This is an example for how to format date |
01-08-2019 |
| _[identifier1] & "_" &
_[identifier2] & "_" & _[date] Note: 'identifier1', 'identifier2', 'date' are variables |
12345_CDW_2018-05-16 |
Advanced Scan to Folder
Following variables from the workflow application are available to use in the formula.| Variable | Description |
|---|---|
| TenantId | Smart Integration Tenant ID |
| UserId | Smart Integration User ID |
| Metadata1 | From Workflow UI, User Entered value for Metadata1 |
| Metadata2 | From Workflow UI, User Entered value for Metadata2 |
| Metadata3 | From Workflow UI, User Entered value for Metadata3 |
| Metadata4 | From Workflow UI, User Entered value for Metadata4 |
| Metadata5 | From Workflow UI, User Entered value for Metadata5 |
Sample Formulas
| Formula | Result |
|---|---|
|
_[UserId] & "-" & YEAR(NOW()) & "-" & MONTH(NOW()) &
"-" & DAY(NOW()) Note: 'UserId' is a variable |
TOM-2018-12-21 |
|
_[Metadata1] & "-" & MONTH(NOW()) & DAY(NOW()) &
YEAR(NOW()) & "-" & HOUR(NOW()) & MINUTE(NOW()) &
SECOND(NOW()) Note: 'Metadata1' is a variable, it's value is 'DOC' as an example |
DOC-142019-192311 |
|
_[Metadata1] & "-" &
_[Metadata2] & "-" &
_[Metadata3] Note: 'Metadata1', 'Metadata2' & 'Metadata3' are variables, Example values 'INVOICE', 'CDW' & 'MARKETING' |
INVOICE-CDW-MARKETING |
Multi Destination Scan
Following variables from the workflow application are available to use in the formula.
| Variable | Description |
|---|---|
| TenantId | Smart Integration Tenant ID |
| UserId | Smart Integration User ID |
Sample Formulas
| Formula | Result |
|---|---|
|
_[UserId] & "-" & YEAR(NOW()) & "-" & MONTH(NOW()) &
"-" & DAY(NOW()) Note: 'UserId' is a variable |
TOM-2018-12-21 |
|
_[TenandId] & "-" & MONTH(NOW()) & DAY(NOW()) &
YEAR(NOW()) & "-" & HOUR(NOW()) & MINUTE(NOW()) &
SECOND(NOW()) Note: 'TenanaId' is a variable, it's value is '2145614091' as an example |
2145614091-142019-192311 |
QR Cover Sheet
Following variables from the workflow application are available to
use in the formula.
QR Code Data Format
= Folder:identifier1:identifier2:date
| Variable | Description |
|---|---|
| TenantId | Smart Integration Tenant ID |
| UserId | Smart Integration User ID |
| identifier1 | From QR Code on the Cover Sheet |
| identifier1 | From QR Code on the Cover Sheet |
| date | From QR Code on the Cover Sheet |
Sample Formulas
| Formula | Result |
|---|---|
|
_[identifier1] & "_" &
_[identifier2] & "_" &
_[date] Note: 'identifier1', 'identifier2', 'date' are variables. Example values '12345', 'CDW' & '2018-05-16 |
12345_CDW_2018-05-16 |
|
_[identifier1] & "_" &
_[date] Note: 'identifier1', 'date' are variables. Example values '12345' & '2018-05-16 |
12345_2018-05-16 |
|
_[identifier1] & "_" & TEXT(TODAY(), "mm-dd-yyy") Note: 'identifier1' is a variable. Example value '12345' |
12345_01-08-2019 |
QR Read and Route
Following variables from the workflow application are available to
use in the formula.
QR Code Data Format
= employee_number:workorder_number
| Variable | Description |
|---|---|
| TenantId | Smart Integration Tenant ID |
| UserId | Smart Integration User ID |
| employee_number | From QR Code on the document |
| workorder_number | From QR Code on the document |
Sample Formulas
| Formula | Result |
|---|---|
|
_[workorder_number] & "_" & "completed" Note: 'workorder_number', is a variable. Example value '220100' |
220100_completed |
|
_[workorder_number] & "_" &
_[employee_number] Note: 'workorder_number', 'employee_number' are variables. Example values '220100' & '33001' |
220100_33001 |
|
_[workorder_number] & "_" & TEXT(TODAY(), "mm-dd-yyy") Note: 'workorder_number' is a variable. Example value '220100' |
220100_01-08-2019 |