April 25, 200124 yr 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?
April 26, 200124 yr 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.
April 26, 200124 yr 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