RICOH Smart Integration

File Name Formula

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

Note: Please see link below. All formulas listed may not be relevant to workflow application. Here is 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