I need a form modified in a database, in such that changes to that form appear as log at the end of the form. Any field change must trigger an entry to the change log at the end of the document. Screnshots of a real example will be provided, along with the template of the database in question. The form is used to track the job search process. This is needed for auditability with the employment security commission ( for NON US residents, these people control whether or nor an unemployed person receives benefits -- cash ). Changes that are logged to this area must fit on one line. There is no maximum # of lines to be displayed, although 50 might be reasonable cap, since these forms may be printed. From the example screenshot given, the time may be trimmed to time, w/o time zone. The name of the person executing the change may be trimmed to first name. One example of HOW to do this is here: [url removed, login to view],289483,sid4_gci490482,[url removed, login to view]
1. The template, returned with the modifications as requested to the form in question ( called "Opportunity" ) 2. Modification of the form called "Opportunity" (aka Job ) in that it: A. Logs all changes to any field in a subform or table at the end of the form B. Each change to the form is displayed in this subform or table on a single line ( using 9pt mono fonts is OK ) C. The change recorded is sufficiently verbose to be understood by a non-technical english speaker ( example: On 07/01/2000 Rob changed the field Status from 'Resume Sent' to 'Interviewed' D. For fields that are not precise ( ie: a text or rich text field ) the description of the event in the log indicates that a change was actually made. ( example: On 07/01/2000 Rob changed the Job Description field ) E. All work to be done without using AGENTS F. Logging changes occurs on the save of the document G. Any special instructions for moving this form & code as needed between test and production templates 3. The end result must approximate the result given in an example JPG to be attached. Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
Must be capable of executing across all existing Lotus Domino platforms: (1) Win32 (2) UNIX (3) Linux Must work when translated by the Domino HTTP engine for web display and editing