February 27, 200421 yr Is there any way to sort value lists alphabetically - once some enters a new value into a value list it appears at the bottom regardless of its name is there any script I could run to sort it alphabetically? Thanks S
February 27, 200421 yr Hi Simmon, If you base your "Value List" on a "Field" it will always be in Alphabetically order based on the first word. AFAIK, there isn't a Script or procedure, native to FileMaker, that will allow you to do this to do a "Hard Coded" list. The way I do this is to access the values through the File - Define - Edit list, and then select all of the values in the list, Copy, and then Paste the values into a text editor (excel works too), Sort the list, Copy the sorted list, and then go back to FileMaker[color:"blue"] (Be sure you have the List in FileMaker still selected) and Paste, this will replace the current list with the alphabetized one. HTH Lee
Create an account or sign in to comment