Writing Syntax for Actions

Writing Syntax for Actions

For a review of Actions related to Scenarios please refer to the article here. Writing actions take the form of an equation:

  • ColumnName = MyScenarioValue

If you are ever doubting the name of a column that needs to be used in an action, you can type CTRL+SPACE to have the full list of columns available to you displayed. Alternatively, you can start typing and the valid column names will auto-complete.

Allowed Numerical Syntax

When assigning numerical values to a column, we can use mathematical operators such as +, -, *, and /. Likewise you can use parenthesis to establish a preferred order of operations. Below are some examples of the syntax.

Allowed Numerical Value Syntax

When assigning numerical values to a column we can use mathematical operators such as +, -, *, and /. Likewise you can use parentheses to establish a preferred order of operations as shown in the following examples.

Business Goal: Action Syntax

  • Increase the unit value by 10%: unitvalue=unitvalue*1.10
  • Increase the unit value by 10% and add $30: unitvalue=(unitvalue*1.10)+30

Allowed String Syntax

When assigning string values to a column you must use single quotation marks to reference any string that is not a column name. Some examples of changing values with a string are included in the examples below:

Business Goal: Action Syntax

  • Exclude an element by changing the status: status=’Exclude’
  • Change the product that goes into a BOM: productname=’RM_02′
  • Set a customer to be single sourced: singlesource=’True’

Writing Syntax for Actions

For a review of Actions related to Scenarios please refer to the article here. Writing actions take the form of an equation:

  • ColumnName = MyScenarioValue

If you are ever doubting the name of a column that needs to be used in an action, you can type CTRL+SPACE to have the full list of columns available to you displayed. Alternatively, you can start typing and the valid column names will auto-complete.

Allowed Numerical Syntax

When assigning numerical values to a column, we can use mathematical operators such as +, -, *, and /. Likewise you can use parenthesis to establish a preferred order of operations. Below are some examples of the syntax.

Allowed Numerical Value Syntax

When assigning numerical values to a column we can use mathematical operators such as +, -, *, and /. Likewise you can use parentheses to establish a preferred order of operations as shown in the following examples.

Business Goal: Action Syntax

  • Increase the unit value by 10%: unitvalue=unitvalue*1.10
  • Increase the unit value by 10% and add $30: unitvalue=(unitvalue*1.10)+30

Allowed String Syntax

When assigning string values to a column you must use single quotation marks to reference any string that is not a column name. Some examples of changing values with a string are included in the examples below:

Business Goal: Action Syntax

  • Exclude an element by changing the status: status=’Exclude’
  • Change the product that goes into a BOM: productname=’RM_02′
  • Set a customer to be single sourced: singlesource=’True’

Have More Questions?

Scalability Icon

Contact Support

Get in touch
Scalability Icon

Contact Sales

Get in touch
Scalability Icon

Visit Frogger Pond Community

Visit our Community