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.

Problem Sorting by # in a portal

snatkins
in Portals

Featured Replies

I have a portal that has records shown in order of "edition #." From 1/25 (1 of 25) to 25/25. It is set to sort by the #: 1 first through 25. Unfortunately, when it sorts - it puts everything with a "1" first so it looks like this:

1

10

12

13

14

15

.....and then goes to 2, 21 - so obviously it is sorting by the first # - how do i fix this?

Help!

Thanks,

Sarah

Is Edition # defined as text or number? If number, it should sort correctly. If text, you will need to sort by a calculation field equal to

Right( "0" & EditionNumber; 2 )

Create an account or sign in to comment

https://fmforums.com/topic/35389-problem-sorting-by-in-a-portal/
Go to topic listing

Important Information

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

I accept

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.