@valueListNameFromID ( valueList.ID )

Function Name is descriptive

Be the first to rate this function Log in to vote

Tony White - Show more from this author
Tony White Designs, Inc.
http://www.twdesigns.com/

Sample input:

@valueListNameFromID ( 123 )

Sample output:

"MyValueListDemo"

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

// @valueListNameFromID ( valueList.ID )
// twdesigns.com 2024-07-11

Let (
[ 
~the_ValueListIDs.padded = ¶ & ValueListIDs ( "" ) & ¶ ; 
~a_ValueListID.padded = ¶ & valueList.ID & ¶  ; 

~position = Position ( ~the_ValueListIDs.padded ; ~a_ValueListID.padded ; 1 ; 1 ) ; 
~list.padded.left = Left ( ~the_ValueListIDs.padded ; ~position ) ;
~index = ValueCount ( ~list.padded.left ) ;

~a_valueListName = GetValue ( ValueListNames ( "" ) ; ~index ) ; 

~result = ~a_valueListName

] ; 
~result
)

Used as an Field > Auto-Enter to protect against drag and drop data onto a field where values could be entered without the user knowing.

Comments

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

@valueListNameFromID ( valueList.ID )

Comments

Support this website.

Support this website.