自定义函数: JSONforLayoutFields ( Layout )

2020年5月18日 • JSON • Layout

函数功能描述

来源:

作者:

作者原述:

猫壹佰描述:

给函数当前布局的名称, 以JSON格式返回当前布局所有非空字段的字段名和字段值.

测试文档下载:

调用范例

JSONforLayoutFields ("Client")

返回结果

{

"FirstName": "Jeremy",

"LastName": "Brown",

"Address": "Somewhere in Orlando",

"ReasonMoved" : "Done with winters"

}

函数内容

While ( 


//VARIABLES
//This is where you will define the variables that will be needed later in the function.

[

	  _fieldNames = FieldNames ( Get ( FileName ) ; Layout )
	; _fieldCount = ValueCount ( _fieldNames )
	; _n = 0
	; _json = JSONSetElement ( "{}" ; "" ; "" ; "" )


] ; 
//END VARIABLES


//CONDITIONS
//Condition parameter is a test. It is a Boolean expression that is evaluated before each loop iteration. As long as the condition is true…or while the condition is true, the loop repeats. When false, the loop stops (and jumps to the result).

	_n ≤ _fieldCount 

; 
//END CONDITION

	


//LOGIC
//The logic parameter is the section that gets evaluated each time the loop is repeated. Variables that are established here will be “reset” or rather “reevaluated” for each loop.

[ 

	_fieldName = GetValue ( _fieldNames ; _n ) ; 
	_fieldEmpty = If ( GetField ( GetValue ( _fieldNames ; _n ) ) ; 1 ; 0 ) ;
	_fieldValue = GetField ( GetValue ( _fieldNames ; _n ) ) ;
	_fieldType = If ( PatternCount ( FieldType ( Get ( FileName ) ; GetValue ( _fieldNames ; _n ) ) ; "number" ) ; JSONNumber ; JSONString ) ;

	_json = If ( _fieldEmpty ; _json ; JSONSetElement ( _json ; _fieldName ; _fieldValue ; _fieldType ) ) ;
	_n = _n + 1

] ; 
//END LOGIC



//RESULT
//The result parameter is an expression that is returned when the loop stops. Just as the name implies, this is where the result of the function (i.e. the result of your calculation) will go.

	JSONFormatElements ( _json )


//END RESULT

)  //End While

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

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