Can one track a change in filed data tracked who chaged a field value?

#1

Have several fields on a layout that I want to track modifications to
each field, not just a record. I only need the most current change, not
every change.

For example, Filed A conntains "Yes". If some deletes the "Yes"" value
or changes it to "No" is there a way to automatically (through a
calculation or script) determine this and then capture the user that
changed the data perhaps using the Get (Account Name) function?

Thanks is advance.

#2

Bubba wrote:

Quote:

Have several fields on a layout that I want to track modifications to each
field, not just a record. I only need the most current change, not every
change.

For example, Filed A conntains "Yes". If some deletes the "Yes"" value or
changes it to "No" is there a way to automatically (through a calculation
or script) determine this and then capture the user that changed the data
perhaps using the Get (Account Name) function?

Thanks is advance.

Sounds like a job for EventScript (free plugin can trigger script on
change to field).

Script could record change in a log field.

See http://www.softs4humans.com

Matt

#3

Bubba wrote:

Quote:

Have several fields on a layout that I want to track modifications to
each field, not just a record. I only need the most current change, not
every change.

For example, Filed A conntains "Yes". If some deletes the "Yes"" value
or changes it to "No" is there a way to automatically (through a
calculation or script) determine this and then capture the user that
changed the data perhaps using the Get (Account Name) function?

Thanks is advance.

This can be done with a calculation using the evaluate function.

I made a sample file that can be downloaded here:

http://www.thehomecomputerdoctor.com...itTracking.zip

Michael Myett

#4

Michael Myett wrote:

Quote:

Bubba wrote:
Have several fields on a layout that I want to track modifications to
each field, not just a record. I only need the most current change, not
every change.

For example, Filed A conntains "Yes". If some deletes the "Yes"" value
or changes it to "No" is there a way to automatically (through a
calculation or script) determine this and then capture the user that
changed the data perhaps using the Get (Account Name) function?

Thanks is advance.

This can be done with a calculation using the evaluate function.

I made a sample file that can be downloaded here:

http://www.thehomecomputerdoctor.com...itTracking.zip

Michael Myett

Certainly simpler than the scripting I suggested.

I will certainly keep this in mind.

Matt

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Can one track a change in filed data tracked who chaged a field value?

comp.databases.filemaker comp.databases.filemaker

Can one track a change in filed data tracked who chaged a field value? - 08-24-2005 , 08:08 PM

Re: Can one track a change in filed data tracked who chaged a field value? - 08-24-2005 , 09:33 PM

Re: Can one track a change in filed data tracked who chaged a fieldvalue? - 08-24-2005 , 11:00 PM

Re: Can one track a change in filed data tracked who chaged a field value? - 08-25-2005 , 06:02 AM