Ask the Expert

Edits in one view affect the other view

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: