Views and columns based on formula

Hi,

I have:

  • form with embedded view

  • Database is on the server

  • Database is opened by Lotus Notes

This embedded view should have “dynamic” column A. I used formula option by column value to display various values.

My goal is to display (by clicking “refresh” button) various things by relationchip with some checkboxes on the form.

For example: if checkbox “X” is selected, I display on the view in column A values of items named “X”.

For know I have some solution but it doesnt seem effective: by clicking button “refresh” I set some environment variable “VAR” on the server and my view has column based on formula, where is @osgetenvironmnentstring(“VAR”) used. Depend on @osgetenvironmnentstring(“VAR”) value I return various names of displayed items in column.

Did you know some more effective solution?

Thanks in advance,

Konrad

Subject: views and columns based on formula

It sounds like the most practical R6 solution is multiple views, loading the view based on formula, and refreshing the document as required.

Browser interfaces can be so clumsy.

Collin

KC8TKA

Subject: views and columns based on formula

Shared views can NEVER be dynamic (that’ll be available with Query Views in Notes and Domino 7 when the optional DB2 back-end is being used). Why are you not using the “Show Single Category” option? The view can be made to display a single category based on a field value on the form; no need to use environment variables or play with the selection formula.

Subject: RE: views and columns based on formula

Hi Stan,

I cant use single category option because such pseudo-dynamic columns I have three (so I have three categories). Values of three columns A, B, C should depend on checboxes X, Y, Z.

Thanks,

Konrad

Subject: RE: views and columns based on formula

You can use a single column for three values; that’s not a problem. The technique has been desribed here many times.

Subject: RE: views and columns based on formula

Thanks for help,

I will use subcategories ("" separated values) and multiple views.

Best regards,

Konrad