Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

value lists sort

Featured Replies

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

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

cool.gif

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.