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.

Web-based sort w/ value list problem!

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.

THANKS!! :-)

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.