I am making a program that travels to different authoritie for approval or rejection. I have made views on the department names. As per the department field, approval authority is decided and doclink is send to that approver.
Now my problem:
I am using formula language, and when I delete records in one view, the other view also deletes the record. If I add some fields, blank records are also added in the other view.
You should adjust the "selection formula" for each of the views to show only documents whose "department" field contains a value appropriate for that particular view. For example, the view selection for a Sales view might be.. "SELECT @UpperCase(department_field) = "SALES" where department_field is the field you use to store the department name.
Tip** I use the @UpperCase function to ensure that the pattern match is case-insensitive as is usually required for selection formulas
This was first published in January 2002