Skip 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.

perform sort on field change

Featured Replies

hi,

i have a drop-down value list set with 5 values. i'd like to perform a sort automatically when someone chooses a different value from the drop-down list. is a script needed to do this or is there another method and how should it be applied?

my knowledge is basic for filemaker.

thanks!

You will need both a script and a FileMaker plugin to do that. Have a look at zippScript.

  • Author

well, i got it to work, however, by placing the zippScript code in the Validation calculation section for the drop-down list field, whenever i change the drop-down in browse mode it always brings up a dialog box that says

""fieldA" is defined to contain only specific values. Allow this value?"

How can I disable that? Shouldn't FileMaker know that I'm selecting the values from a drop-down list?

Or is there another area where I should be entering the zippScript code?

Thanks.

You'd generally want to trigger zippScript using Auto-enter rather than Validation.

  • Author

placing that code in the auto-enter calculation doesn't do anything.

maybe because there is nothing auto-entered since it's a drop-down list?

any ideas?

Auto-entry does not only apply to new records. It can also happen when a field is modified, even the same field! The key is to auto-enter a calculated value, and then UNcheck the "do not replace" checkbox.

Look at the "trigger a script when exiting field" example in the zippScript example file. Look at the auto-entry options for FieldA.

  • Author

that worked. thank you very much for your help!!

i don't use fm very often.

  • 2 years later...

Is there any way to do this without a plugin in version 10 or 11?

Yes, use your triggers !

( OnObjectModify )

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.