Change Notification

[ejpvi]

We have need of a notification queue, to alert people when certain records have been modified.

For instance, we used to have a shared spreadsheet (pre-filemaker) and when changes were made, someone would change the cell background to Red.

Then when someone responsible for making the change in their particular project (not part of the spreadsheet), as they looked through the spreadsheet, they would see the red, and know they needed to change it.

They would make their physical change in their project, then put the cell color back to normal in the spreadsheet.

I am hoping to implement something similiar in filemaker. Someway for someone to see that a change had been made. Then a way for them to acknowledge by turning it back to normal. It would have to be per certain designated records, because it could be any record that changes.

I heard script triggers may be good for this?

But not sure if it is overkill, maybe someone knows a simple way to do this in Filemaker, that works well.

[comment]

How about:

AcknowledgeModification.fp7.zip

[ejpvi]

impressive. I think I can work with that...

I wonder if I can apply it to individual cells of a record, instead of highlighting the entire row.

I will play around with it...

Thanks!

[ejpvi]

Regarding my previous reply... do you know a way to have a conditional formatting setting that would only highlight the specific cell that was modified?

Or will it only work for the entire record?

[comment]

It's not a problem of conditional formatting, but rather of having the required data upon which conditional formatting can be based. Your request would require tracking the modification time of each field of interest.

[ejpvi]

Lets Say I had a couple of individual fields I wanted to track.

Is there a way to do a timestamp for something that specific as opposed to the whole record?

[Lee Smith]

Take a look at UltraLog

[comment]

If it's only a few fields, you could do a modification field for each, e.g. a timestamp field auto-entering a calculation =

Let ( trigger = Somefield ; Get (CurrentTimeStamp) )

[ejpvi]

Cool, that would probably work better than what I came up with..

I made some scripts like the one you had... but made them specific to the field, made a timestamp field for that field, and then set an on exit trigger.

I think I like the auto-entry calc, better, because then I don't have to set up triggers on each layout.

Thanks.