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.

excluding field from auto-Enter function

Featured Replies

There are many text fields in the FMP5 layout including a field called "last modifier" which can records the last modifier's name of each record automatically. Besides, there were some check box fields.

Can i write a script so that FMP5 will not treat "check & uncheck the check boxes" as a modification and keep the last modifier's name unchange?

Here's a quick method to make a "last modified by" field that works only on specific fields. Set up a stored calculation (rather than an autoenter) field with the following formula:

Status(CurrentUserName) & Left(TextField01 & TextField02 &...TextField99,0)

Changing the contents of any of TextField01 through TextField99 will cause this formula to recalculate the current user name, even though none of these fields will have any other effect on the calculation. You can do a similar thing to record the modification date and time etc.

Note, if the total amount of text in these fields exceeds 64000 characters (per record), then this formula needs to be modified a bit.

You can't modify the way FM's built in modification routine works. The best you can do is to implement an modification tracking scheme or you own. -bd

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.