自定义函数: GetAsTemplateLiteral ( fieldName )

2020年6月7日 • Evaluate • Field Name • GetFiledName

函数功能描述

来源:

作者:

作者原述:

猫壹佰描述:

GetFieldName的辅助函数, 用于在使用Evaluate函数处理包含运算符或保留字符的字段前, 对字段名称按FileMaker规范处理.

前往官方帮助了解关于如何在计算中引用包含保留字符的字段

测试文档下载:

调用范例

GetAsTemplateLiteral ( GetFieldName ( Table::${A + B} )

返回结果

"Table::${A + B}"

函数内容

/**
 * ==================================================================
 * GetAsTemplateLiteral ( fieldName )
 *
 * PARAMETERS:
 *            @fieldName (text) Text value
 * RETURNS:
 *            (text) The field name as a template literal
 * EXAMPLE:
 *            "GetAsTemplateLiteral ( GetFieldName ( Table::${A + B} )" returns "Table::${A + B}" which can be used to retrieve the field value using "Evaluate ( expression )" or "GetField ( fieldName )", unlike "Table::A + B" which is returned by default.
 * DEPENDENCIES:
 *            None
 * AUTHOR:
 *            Marcus Nilsson, Square Moon Industries AB, marcus@squaremoon.se
 * PURPOSE:
 *            Return the field - whose name contains reserved characters and/or symbols - as a template literal which can be used to retrieve the field value.
 * NOTES:
 *            For more information, read the article "Using a reserved word or symbol for a field or table name" @ https://fmhelp.filemaker.com/help/18/fmp/en/index.html#page/FMP_Help%2Freserved-word-symbol-for-field-or-table.html%23ww1030956
 * REVISIONS:
 *            2020-06-05, Marcus Nilsson. Created.
 * ==================================================================
 *
 */

Replace ( fieldName ; Position ( fieldName ; "::" ; 1 ; 1 ) ; 2 ; "::${" ) & "}"

当前页面使用FileMaker生成发布, 更新于2021年3月15日0时47分32秒

← 较旧的文章较新的文章 →