How to get data by using ESF_getFldValue function to fill to the cells from Excel server?
ESF_getFldValue(<TargetTableName>, <TargetFieldName>,
<FieldName1>,<ValueForFieldName1>,
<FieldName2>,<ValueForFieldName2>,
...
)
Means: Select<TableName> Where:
<ConditionFieldName1>=<ValueOfConditionFieldName1> and <ConditionFieldName2>=<ValueOfConditionFieldName2>,...,
<Get the first qualified record's value for <TargetFieldName> as the return value.
Note: <TargetTableName> is the defined data table name at the Excel server.
<TargetTableName>, <ConditionFieldName1>, <ConditionFieldName2> is the fields of <TargetTableName>
Input <ValueOfConditionFieldName1> and <ValueOfConditionFieldName2> to the Excel cell means fetching the value of the cell.
For Example:
1. In the template designing stage, input '=' at the cell that needs to get the value from the data table.
2. Click 'fx' from the Excel menu; then find 'ESF_getFldValue' from the list. then click 'OK'.
3. Input <TargetTableName> at 'TabName', <TargetFieldName> at 'Flds', and '<ConditionalFieldName> at 'Keys' (in this case, input "Order_Main" at the 'TabName', 'CustomerName' at Flds' and 'OrderID' at Keys).Then click the 'small icon' at the end of each row and selecting the data accordingly.
4. Input cell address for <ValueOfConditionalFieldName1> to the following window:
5. Click the icon on the right of the box:
6. If there are more conditions, then repeat step 3 to 5 until get them all.
Click 'OK' to end.
7. Save the template.