JSON.PrependArray ( JSON )

This will add a new item to the beginning of a JSONArray

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.PrependArray( "[]", "{\"layoutID\":4,\"layoutName\":\"Table2\"}" )
JSON.PrependArray( "[{\"layoutID\":3,\"layoutName\":\"Table1\"}]", "{\"layoutID\":4,\"layoutName\":\"Table2\"}" )

Sample output:

[{"layoutID":4,"layoutName":"Table2"}]
[{"layoutID":4,"layoutName":"Table2"} , {"layoutID":3,"layoutName":"Table1"}]

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

/*
   Author:  Kyle Williams
   Date:    2/15/2020
   Updated: 4/16/2021
   Update Notes: Old formula used a substitute function which did not play well with embedded JSON Objects. This update resolves that issue.
*/


If( JSON = "[]"; "[" & NewItem & "]";

	Let([
		Old_Items = Right(JSON; Length(JSON) - 1)
	];

	"[" & NewItem & " , " & Old_Items

	)

)

This will add a new JSON Object to the beginning of any JSON Array.
This is useful when creating navigation scripts to return to a previous layout or go back to the next layout.

Comments

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

JSON.PrependArray ( JSON )

Comments

Support this website.

Support this website.