AddRemove ( value ; content )
A custom function which allows simple addition or extraction of values from a list.
Average rating: 4.0 (40 votes) Log in to vote
ISO Productions, Inc.
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This function is a simple tool. It simply adds or removes a value from a return delimited list of values. The area where this is most useful is when working with portals and clicking a portal row to add or remove an ID value from a global field storing a multi-key value.
Jan 6, 2010
I have added the RightValues functions so you do not have to add an "¶" to the content parameter. To be sure the list closes with an enter.
content =RightValues ( ( content );ValueCount ( content ));
value_exists = PatternCount ( "¶" & content & "¶" ; "¶" & value & "¶" )
value_exists; MiddleValues ( Substitute ( "¶" & content; "¶" & value & "¶" ; "¶" ) ; 2 ; 1000000 );
content & value & "¶" )
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.