@UniqueValuesToAdd ( existingValues ; addingValues ; ~datatype ; ~locale )

Filter values that are not on the list.

Average rating: 4.0 (4 votes) Log in to vote

Alex Zueiv - Show more from this author
Tashkent
https://github.com/zueiv

Sample input:

Quote ( @UniqueValuesToAdd ( "existing¶values" ; "adding¶values" ; "" ; "" ) )

Sample output:

"adding¶"

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

// @UniqueValuesToAdd ( existingValues ; addingValues ; ~datatype ; ~locale )
//
// 2018-03-31 by Alex Zueiv
//
// Non-recursive function to filter values that have not yet been added to the list.
// ~datatype and ~locale are optional parameters of the FM function (see help).
//
// Example: @UniqueValuesToAdd ( "existing¶values" ; "adding¶values" ; "" ; "" )


Let ( [

EXST = UniqueValues ( existingValues ; ~datatype ; ~locale ) ;
ALL = UniqueValues ( EXST & addingValues ; ~datatype ; ~locale )

] ;

RightValues ( ALL ; ValueCount ( ALL ) - ValueCount ( EXST ) )

)

This CF allows to find out which values are new before adding them to the DB. It is useful to prevent duplicate entries when you do Insert from URL [] or when you need to post-process a set of newly selected checkboxes.

Works in FM16+ only (no runtimes).

Tip: To get the list of removed values, just change the parameters in places:

Quote ( @UniqueValuesToAdd ( "adding¶values" ; "existing¶values" ; "" ; "" ) ) = "existing¶"

Comments

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

@UniqueValuesToAdd ( existingValues ; addingValues ; ~datatype ; ~locale )

Comments

Support this website.

Support this website.