Skip to main content

FieldLogs

Columns

The Table Column manipulation Instructions manipulates the columns of Table Steps in a Template.

This category includes four types of Fieldlogs Specific Instructions:

  1. Flkw:SetTableColumnValues

  2. Flkw:SetTableColumnValidatedValues

  3. Flkw:GetTableColumnMaxValue

  4. Flkw:GetTableColumnMinValue

  5. Flkw:GetTableColumnAveValue

Flkw:SetTableColumnValues

Flkw:SetTableColumnValues sets the value of the specified column of the Table.

Format: Flkw:SetTableColumnValues('step ID','row ID','column ID','value');

Parameters

Description

Step ID

The ID of the target table Step.

Row ID

The ID of the row that contains the target cell.

Column ID

The ID of the column that contains the target cell.

Value

The value to be set.

To construct a Script Instruction using Flkw:SetTableColumnValues:

  • Select JS Execute from the Instruction dropdown list. In the Expression field, enter the Flkw:SetTableColumnValues Instruction as shown.

    SetTableColVales1.png

The Flkw:SetTableColumnValues Instruction is added to the Script.

SetColVal2.png

At runtime, the Script replaces the values of the specified columns in rows 1 and 2 with the values NewValue1 and NewValue2.

SetColVal3.png

Note that the values are not validated by the Script. The user is required to validate them.

Flkw:SetTableColumnValidatedValues

Flkw:SetTableColumnValidatedValues sets the value of the specified column of the Table and validates it.

Format: Flkw:SetTableColumnValidatedValues('Step ID','Row ID','Column ID','value');

Parameters

Description

Step ID

The ID of the target table Step.

Row ID

The ID of the row that contains the target cell.

Column ID

The ID of the column that contains the target cell.

Value

The value to be set.

To construct a Script Instruction using Flkw:SetTableColumnValidatedValues:

  • Select JS Execute from the Instruction dropdown list. In the Expression field, enter the  Flkw:SetTableColumnValidatedValues Instruction as shown.

    SetValidatedColTable1.png

The Flkw:SetTableColumnValidatedValues Instruction is added to the Script.

SetValidatedColTable2.png

At runtime, the Script replaces the values of the specified columns in rows 1 and 2 with the values NewValue1 and NewValue2 and validates them.

SetValidatedColTable3.png

Note that the entries are validated by the Script. The user is not required to validate them.

Flkw:GetTableColumnMaxValue

Flkw:GetTableColumnMaxValue retrieves the maximum value in the specified column of the Table.

Format: Flkw:GetTableColumnMaxValue('Step ID', 'Column Step ID');

Parameters

Description

Step ID

The ID of the target table step.

Column Step ID

The step ID of the column.

To construct a Script Instruction using Flkw:GetTableColumnMaxValue:

  • Select JS Execute from the Instruction dropdown list. In the Expression field, enter the Flkw:GetTableColumnMaxValue Instruction as shown.

    MaxCol1.png

The Instruction Flkw:GetTableColumnMaxValue is added to the Script.

MaxCol2.png

At runtime, the Script gets the maximum value in the column and stores it in a Local Variable. It is then displayed as shown.

MaxCol4.png
Flkw:GetTableColumnMinValue('Step ID', 'Column Step ID');

GetTableColumnMinValue retrieves the minimum value in the specified column of the Table.

Format:Flkw:GetTableColumnMinValue('Step ID', 'Column Step ID');

Parameters

Description

step ID

The ID of the target table step.

Column Step ID

The Step ID of the column.

To construct a Script Instruction using Flkw:GetTableColumnMinValue

  • Select JS Execute from the Instruction dropdown list. In the Expression field, enter the Flkw:GetTableColumnMinValue Instruction as shown.

    MinVal1.png

The Instruction Flkw:GetTableColumnMinValue is added to the Script.

MinVal2.png

At runtime, the Script gets the minimum value in the column and stores it in a Local Variable. It is then displayed as shown.

MinVal3.png
Flkw:GetTableColumnAveValue("step ID","column ID");

Flkw:GetTableColumnAveValue retrieves the average value in the specified column of the Table.

Format: Flkw:GetTableColumnAveValue('Step ID', 'Column Step ID');

Parameters

Description

step ID

The ID of the target table step.

column Step ID

The Step ID of the column.

To construct a Script Instruction using Flkw:GetTableColumnAveValue:

  • Select JS Execute from the Instruction dropdown list. In the Expression field, enter the  Flkw:GetTableColumnAveValue Instruction as shown.

    AveVal1.png

The  Flkw:GetTableColumnAveValue Instruction is added to the Script.

AveVal2.png

At runtime, the Script gets the average value in the column and stores it in a Local Variable. It is then displayed as shown.

AveVal3.png
In this section: