Jump to content

locking text data field at a future date to prevent modification


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

Recommended Posts

  • Newbies

Hi, I'm using filemaker 3 on a Powermac 7300 under 7.55.

I'm gradually learning scriptology.

I am creating a database, where I can keep track of people and write encounter notes about each person.

For security reasons, I would like to lock the text fields to not allow any modification after a certain time or date (i.e. no field modification on a note about a client after 24 hours or after I click a button shortcut). The field is a text field that I have typed about a client.

I know that this is possible, as I have seen commercial demos with this feature, based on FM3. I can't find a reference as to how to do this.

Thanks in advance. [email protected]

Link to comment
Share on other sites

How about having two fields:

TextEntry (text)

TextCalc (calculation, text) = TextEntry

Put the TextCalc field on top of the TextEntry field (make it opaque). Create a script:

If (Date < LockDate) <--- use your own criteria

Go to field (TextEntry)

Else

Go to field ()

End If

Make sure TextEntry is not in the tab order.

-bd

Link to comment
Share on other sites

This topic is 8309 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
×
×
  • Create New...

Important Information

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