Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

Tool Tip showing last modification


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

Recommended Posts

Posted

Hi Dana,

Firstly, you should have a field that contains information about "Last_Change_Date" for a record, then in Set tooltip, enter this:

Get (AccountName) & " " & [TableName::Last_Change_Date]

Hope it helps...

Posted

Thanks Henry,

I was trying to avoid creating a second field for every field in my layout. I was hoping that there was a custom function that could be created and added to each field that would note the modifications to only that field.

Ex. Field 1 was modified and tooltip would read "John Smith 2/29/08." Field 2 was not modified and would show "Bob Johnson 1/1/08." Field 3 has never been modified so it would have a blank tooltip.

Posted

Hi Dana,

Ex. Field 1 was modified and tooltip would read "John Smith 2/29/08." Field 2 was not modified and would show "Bob Johnson 1/1/08." Field 3 has never been modified so it would have a blank tooltip.

So, will you actually save the "date" of modification into a field?

I am not sure that the tooltip can actually save all your "modification_date" without having a field to keep their records...

Posted

That's what I was crossing my fingers for. If it's not possible then I'll have to see if they would settle for a single field with the modification log. It's just something that an employee asked me about and I didn't have an answer as to whether or not a tooltip was capable of that.

It's one of those "wants" but not necessarily a need.

Posted

If is only a matter of knowing who changed the fields and when, look at the Audit Tracking files that have been discussed in the past.

Check out this file Link to see what I mean.

HTH

Lee

Posted

That may work. I'll have to take a look at in depth. I know that it will work for other areas that we need a history for the data.

Thanks Lee.

  • 3 years later...

This topic is 4937 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.