Fellow listers, I have a request to log all changes made to a form entry to
a master log form. The initial form has over a hundred fields. Is there a
more elegant way of doing this other than to write a filter for each field
that would write the changes to a diary field then push the diary field to
the master log? When creating a notify action of a filter, there is a
selection that includes changed fields. How is this done? Can this action
be utilized? Any ideas would be greatly appreciated.

Thanks

On Fri, 22 Dec 2000 06:37:02 -0500, Madden, John Mr NISA-SM/GMSI
wrote:


Have you looked at the "write to log" filter action?

>**
>
>Fellow listers, I have a request to log all changes made to a form entry to
>a master log form. The initial form has over a hundred fields. Is there a
>more elegant way of doing this other than to write a filter for each field
>that would write the changes to a diary field then push the diary field to
>the master log? When creating a notify action of a filter, there is a
>selection that includes changed fields. How is this done? Can this action
>be utilized? Any ideas would be greatly appreciated.
>
>Thanks
>
>
>

--
Regards

Dave Saville
Second star to the right and straight on 'til morning
(Capt. James T. Kirk quoting Peter Pan)

Hi,

I guess withouth API/Other programming the only way to acomplish this is to
create filter per field.
However you'd consider that it is not likelly to include all the changes in
a notification (other than e-mail) because the limit of notification lenght.

Nicky Madjarov
Intellico Solutions, Inc.

1507 Hermitage Pk. Dr.
Hermitage, TN 37076
Phone: (615) 883 7591
Mobil : (201) 747 8672
Pager: 2017478672@mobile.att.net
e-mail: nickym@intellicosolutions.net
http://www.intellicosolutions.net
----- Original Message -----
From: "Dave Saville"
To:
Sent: Friday, December 22, 2000 6:14 AM
Subject: Re: Log all changes


> **
>
> On Fri, 22 Dec 2000 06:37:02 -0500, Madden, John Mr NISA-SM/GMSI
> wrote:
>
>
> Have you looked at the "write to log" filter action?
>
> >**
> >
> >Fellow listers, I have a request to log all changes made to a form entry
to
> >a master log form. The initial form has over a hundred fields. Is there
a
> >more elegant way of doing this other than to write a filter for each
field
> >that would write the changes to a diary field then push the diary field
to
> >the master log? When creating a notify action of a filter, there is a
> >selection that includes changed fields. How is this done? Can this action
> >be utilized? Any ideas would be greatly appreciated.
> >
> >Thanks
> >
> >
> >

>
> --
> Regards
>
> Dave Saville
> Second star to the right and straight on 'til morning
> (Capt. James T. Kirk quoting Peter Pan)
>
>
>

>

John,

I have done this before. I called it the "dynamic audit trail". Basically,
it entails a separate form with all of the fields listed in it, and another
separate form to hold the diary information.

If you want more information, e-mail me off-list...


Best Regards,

Ann Zbylut
Process Automation Engineer
GE Capital ITS
Enterprise Management
Work (916) 569-5263
Pager (888) 437-5810


-----Original Message-----
From: Madden, John Mr NISA-SM/GMSI [mailto:john.madden@HQDA.ARMY.MIL]
Sent: Friday, December 22, 2000 3:37 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Log all changes


**

Fellow listers, I have a request to log all changes made to a form entry to
a master log form. The initial form has over a hundred fields. Is there a
more elegant way of doing this other than to write a filter for each field
that would write the changes to a diary field then push the diary field to
the master log? When creating a notify action of a filter, there is a
selection that includes changed fields. How is this done? Can this action
be utilized? Any ideas would be greatly appreciated.

Thanks

John,

You can create a Set Field action to set the changes to a Diary Field on
Create or Modify of the record. You can do this with either a Active
Link or Filter but a Filter is best.

Depending on when and what data needs to be set into the (diary field) let's
call this the Audit Log field , you will create Run If qualifications to
control
when the process (Set Fields) actions will occur.

So if you have 100 fields and a field called Name changed then a
qualification
would pick this up and the Set the Audit Log with a data time stamp and any
text
you wanted to be placed in the Audit Log indicating that the Name field was
changed
and by whom with a date/time stamp of course.

In general terms, though not advised, you could create on very long
qualification
and if ANY of the fields changed you could Set a general message to the
Audit Log
that a record modification has occurred.

I would guess that you will land somewhere between the two extremes.

Hope this helps.


Regards...Gidd



-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Madden, John Mr
NISA-SM/GMSI
Sent: Friday, December 22, 2000 3:37 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Log all changes


**

Fellow listers, I have a request to log all changes made to a form entry to
a master log form. The initial form has over a hundred fields. Is there a
more elegant way of doing this other than to write a filter for each field
that would write the changes to a diary field then push the diary field to
the master log? When creating a notify action of a filter, there is a
selection that includes changed fields. How is this done? Can this action
be utilized? Any ideas would be greatly appreciated.

Thanks