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.

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.

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

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:

www.thehomecomputerdoctor.com/sample_files/auditTracking.zip

Michael Myett

Michael Myett wrote:

>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:
>
>www.thehomecomputerdoctor.com/sample_files/auditTracking.zip
>
>Michael Myett

Certainly simpler than the scripting I suggested.

I will certainly keep this in mind.

Matt