Jump to content

excluding field from auto-Enter function


This topic is 7774 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 7774 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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