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.

Can I Create Unsorted Value List?

Featured Replies

Is anyone knows if it's possible to create unsorted value list? I need to create a value list consisting of all time values from another file, but the times are formatted in the text fields. I don't want the times be sorted as text.

I take it your time field is defined as a "Time" field? If it's a true Time field, it should sort in order of the durations/times. Do you not want that?

(If it's a *text* field with time values, then you should consider turning it into a time field, and simply *displaying* it in the way you prefer, or creating a calc to show text that fills it out the way you like.)

At any rate, you can always sort a value list by some other field than the ones whose values you're actually selecting. You can make and sort on a calc field which is a NUMBER type field, but which returns the value from the time field manipulated in whatever way you like. If your record has a "Creation Date" or "Creation Time" field, you can sort on *that* field, which is roughly what FileMaker would do when records are "unsorted"...

Create an account or sign in to comment

Important Information

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

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.