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 w/ Custom sort! Help?

Featured Replies

USED CUSTOM SORTS? PLEASE HELP...

I have a web-based solution that does a custom sort, based on the values in a value list named "plantgroup". The CDML is:

<input type="Hidden" name="-sortfield" value="grouping">

<input type="Hidden" name="-sortorder" value="custom=PlantGroup">

I developed and tested on a Mac. Works fine. We deploy production

solutions on NT, so I moved it there, then noticed the custom sort

did not occur. I did all sorts of testing, hosting this on another

Windows machine, this time 98. I made sure the newest Web Companion

plug in was in place, so we're talking FMPro 5.0v3, with Web Companion

5.0v6.

When I access through the web, the custom sort does not occur. I've

used FMP-CurrentSort, FMP-SortFieldItem, and FMP-SortOrderItem to see

what Web Companion thought. It reports that a custom sort of field

"grouping" occurred, based on the values in value list "plantgroup". This

would be correct! But the order is merely ascending. When I go to the

hosting machine and check out the last sort, I see that it DID a custom

sort on field "grouping" based on value list "<unknown>". For some reason,

the value list is not getting found, though the value list name matches

that returned by [FMP-SortOrderItem]. Value list "plantgroup" is there

in the list of value lists.

I've made sure the character case, etc. match perfectly.

Works when hosted on a MAC! Is this truly a bug no one's run into yet?

Surely there are those out there doing custom sorts from the web on

databases hosted on Windows. Please fire any input directly at me.

THANKS!! :-)

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.