JSON.List_Layouts

Creates a List of all Layouts and Layout IDs in JSON format

Be the first to rate this function Log in to vote

Kyle Williams - Show more from this author
Augusto Digital
https://www.youtube.com/channel/UCpJlB7cmVNMjbjgY96MEsng

Sample input:

JSON.List_Layouts()

Sample output:

{
"Layouts" :
[
{
"ID" : "2",
"Name" : "Invoices"
},
{
"ID" : "48",
"Name" : "Invoice_List"
}
]
}

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
Author:     Kyle Williams
Date:       2/01/2020
Purpose:    Create a list of Layouts with IDs in JSON format
Updated 2/15/2020:  Now sorts the layouts by layout id number
*/

While (

//Initial Variables
[
	 list_ids = SortValues ( LayoutIDs ( "" ); 2 )
	;FoundCt = ValueCount( list_ids )
	;LoopCt = 1
	;$record = If(LoopCt = 1; ""; $record)
];

//Condition
LoopCt ≤ FoundCt;

//Logic
[
	 LayoutID = GetValue ( list_ids; LoopCt )
	;LayoutName = GetLayout ( LayoutID )
	;$record = 
		JSONSetElement ( $record
			;[ "Layouts[" & LoopCt - 1 & "]ID"; LayoutID; JSONString ]
			;[ "Layouts[" & LoopCt - 1 & "]Name"; LayoutName; JSONString ]
			)
	;LoopCt = LoopCt + 1
];

//Result
JSONFormatElements ( $record )

)

Creates a List of all Layouts and Layout IDs in JSON format

Comments

		Kyle Williams, Augusto Digital Feb 14, 2020
NOTE: This function requires FMP 18 or later to work.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

JSON.List_Layouts

Comments

Support this website.

Support this website.