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.

Featured Replies

I know there are various pros and cons for using field validations over script triggers when validating data, but...

In a solution I'm currently working on, it will go to the user with a set of fixed pre-entered preference data in a couple of tables and layouts, to which the user can add to. Edits and deletions are only permitted on the user added records, not the original pre-entered data. A flag "userentered" set to 0 on the pre-entered, and set to 1 on user entered data.

This is easy to use in the field validation section, only allowing changes when userentered=1.

However the stock validation button is clumsy using the "revert" language and doesn't offer other custom dialog options. So I've been experimenting with OnObectEnter (I can't see which other trigger is better to use), on the fields. Now when a user clicks into a field on a record where userentered<>0, the trigger script shows a message indicating that it can't be edited, but offers more options to add or duplicate for a user defined record based on the original (rather than a dull "revert" button).

There is nowhere else in the system these type of "preference" records can be edited, it'll be a locked down runtime version, fully secured, so any odd batch edits/changes are of a concern, and in addition a full set of custom menus are provided trapping for default all new, dupe, delete etc with scripts.

Are there better ways to achieve this? I've tried OnObjectSave, but that still saves any changes regardless of whether it exits with true or false (am I missing something here?). Ideally I'm looking for a trigger similar to a VB/VBA OnModify / OnChange event...

See if this helps:

http://sixfriedrice.com/wp/the-onobjectvalidate-trigger/

  • Author

Perfect, great example too, thank-you Fitch!

Moved to OnObjectValidate and kept the rule for validation in the field validation. I use an OnObjectValidate script to check the value of the userentered flag, and if it's <>1, if shows an more friendly error with options and then reverts the field back.

This is much more friendly than my original OnObjectEnter, as it also allows the user to copy the text from the fields if required, definitely a great addition when moving from v10 to v11!

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.