To get field value from form table.

• #form.tableName.fieldId #
• #form.tableName.fieldId[recordId]# (Available in v3.1 and above) where "recordid" is a reserved variable used by Joget to retrieve the subform's id.

• In a Process Tool part of a Process.
• In a Form.
• In a process design.

• All components within the App.

Testing Values

• #envVariable.num1# = 55
• #envVariable.num2# = 288
• #envVariable.double1# = 123.45
• #envVariable.double2# = 246.78
• #envVariable.bool1# = true
• #envVariable.bool2# = false
• #envVariable.str1# = Hello World!
• #envVariable.str2# = Using Joget Hash Variables!
• #envVariable.empty# =
• #envVariable.hashVariable# = #assignment.processId#

Mathematical operators

• #exp.{envVariable.num1} + {envVariable.num2}# = 343
• #exp.{envVariable.num1} - {envVariable.num2}# = -233
• #exp.{envVariable.double1} * {envVariable.double2}# = 30464.991
• #exp.{envVariable.num2} / {envVariable.num1}# = 5
• #exp.{envVariable.num1} % 7# = 6
• #exp.({envVariable.num1} + 2) * 2# = 114
• #exp.{envVariable.num1} + 2 * 2# = 59
• #exp.2 ^ 2# = 4

Logical operators

• #exp.{envVariable.bool1} and {envVariable.bool2}# = false
• #exp.{envVariable.bool1} or {envVariable.bool2}# = true
• #exp.!{envVariable.bool1}# = false

Relational operators

• #{envVariable.num1} gt {envVariable.num2}# = false
• #{envVariable.num1} ge {envVariable.num1}# = true
• #{envVariable.num1} lt {envVariable.num2}# = true
• #{envVariable.num1} le {envVariable.num1}# = true
• #{envVariable.num1} eq {envVariable.num1}# = true
• #{envVariable.num1} ne {envVariable.num1}# = false

Ternary Operator (If Else)

• #exp.({envVariable.num1} lt {envVariable.num2})?{envVariable.num1}:{envVariable.num2}#= 55
• #exp.'{envVariable.empty?expression}'.isEmpty()?'empty':'has value'#= empty

String methods

Note: Basically most of the String methods can be used, using `?expression` to escape single quote in value.

• #exp.'{envVariable.str1?expression}' + ' ' + '{envVariable.str2?expression}'# = Hello World! Using Joget Hash Variables
• #exp.'{envVariable.str1?expression}'.substring(5)# = World!
• #exp.'{envVariable.str1?expression}'.toLowerCase()# = hello world!
• #exp.'{envVariable.str1?expression}'.toUpperCase()# = HELLO WORLD!
• #exp.'{envVariable.str1?expression}'.replace('world', 'there')# = Hello World!
• #exp.'{envVariable.str1?expression}'.replaceFirst('[a-z]', '*')# = H*llo World!
• #exp.'{envVariable.str1?expression}'.replaceAll('[a-z]', '*')# = H**** W****!
• #exp.'{envVariable.str1?expression}'.charAt(0)# = H
• #exp.'{envVariable.str1?expression}'.contains('World')# = true
• #exp.'{envVariable.str1?expression}'.equalsIgnoreCase('{envVariable.str1?expression}'.toLowerCase())# = true
• #exp.'{envVariable.empty?expression}'.isEmpty()# = true
• #exp.'{envVariable.str1?expression}'.indexOf('World')# = 6
• #exp.'{envVariable.str1?expression}'.lastIndexOf('World')# = 6
• #exp.'{envVariable.str1?expression}'.startsWith('H')# = true
• #exp.'{envVariable.str1?expression}'.endsWith('!')# = true

Custom Methods

• #exp.$isParsed('{envVariable.hashVariable}')# = false

Math methods

Note: All java.lang.Math methods can be used.

• #exp.$sin(30)# = -0.9880316240928618
• #exp.$cos(30)# = 0.15425144988758405
• #exp.$tan(30)# = -6.405331196646276
• #exp.$asin(30)# = NaN
• #exp.$acos(30)# = NaN
• #exp.$atan(30)# = 1.5374753309166493
• #exp.$sinh(30)# = 5.343237290762231E12
• #exp.$cosh(30)# = 5.343237290762231E12
• #exp.$tanh(30)# = 1.0
• #exp.$abs(-7)# = 7.0
• #exp.$max(60,30)# = 60.0
• #exp.$min(60,30)# = 30
• #exp.$round(79.52)# = 80
• #exp.$sqrt(12)# = 3.4641016151377544
• #exp.$cbrt(81)# = 4.326748710922225
• #exp.$pow(4, 2)# = 16.0
• #exp.$signum(82.7)# = 1.0
• #exp.$ceil(82.7)# = 83.0
• #exp.$copySign(740.4, -29.1)# = -740.4
• #exp.$nextAfter(84352.24, 154.284)# = 84352.234
• #exp.$nextUp(744.93)# = 744.93005
• #exp.$nextDown(744.93)# = 744.9299999999998
• #exp.$floor(744.93)# = 744.0
• #exp.$floorDiv(25, 3)# = 8
• #exp.$random()# = 0.3988245190916774
• #exp.$rint(81.68)# = 82.0
• #exp.$hypot(8, 6)# = 10.0
• #exp.$ulp(8.1)# = 9.536743E-7
• #exp.$getExponent(50.45)# = 5
• #exp.$IEEEremainder(387.1, 4.2)# = 0.7000000000000064
• #exp.$addExact(469, 737)# = 1206
• #exp.$subtractExact(469, 737)# = -268
• #exp.$multiplyExact(469, 737)# = 345653
• #exp.$incrementExact(674)# = 675
• #exp.$decrementExact(674)# = 673
• #exp.$negateExact(674)# = -674
• #exp.$toIntExact(-829)# = -829
• #exp.$log(38.9)# = 3.6609942506244004
• #exp.$log10(38.9)# = 1.5899496013257077
• #exp.$log1p(26)# = 3.295836866004329
• #exp.$exp(2)# = 7.38905609893065
• #exp.$expm1(2)# = 6.38905609893065
• #exp.$toDegrees(5)# = 286.4788975654116
• #exp.$toRadians(180.0)# = 3.141592653589793

• .38905609893065
• #exp.$toDegrees(5)# = 286.4788975654116
• #exp.$toRadians(180.0)# = 3.141592653589793

To retrieve the particular report based on the reportId.

To know more about Report Builder, see here.

• #reportLink.rp_report01#

• All components within the App.

• #reportLink.financialReport#

To retrieve the

template based on the

code snippet ID.

• #reportLink.rp_report01##code.cs-templateId#

• All components within the App.

• #reportLink#code.financialReport#cs-calculationScript#