Best way to show view?

HCL Domino Domino Forum
1

Hello everybody,

as mentioned before I am very new to Lotus Designer. On the suggestion of this forum I have now puchased Sams Teach Yourself Lotus Notes and Domino Development in 21 days, which I am finding very useful. many Thanks.

My question today is this:

I have a simple Application that displays Job Vacancies on our new Intranet. A simple form holds the details for each job and I have made a view to show any jobs that the closing date for has not yet passed. I have done this using the formula

SELECT (ClosingDate > @Yesterday)

this works OK at displaying the correct documents but has the annoying habit of showing the refresh button in the top left all the time. Looking in the help files I can see that when using @today or @yesterday this is a known Lotus bug/supposed to happen. But for our users it means at least one phone call every day or so with the question “I keep hitting refresh but nothing happens!..”

Can anybody suggest a way that I can display all job vacancies that are active but without the ‘refresh button’ problem.

Many thanks for any help you can offer to me.

with best wishes

John Finch

2

Subject: best way to show view?

The only real solution is to base your selection on a stable field value. Create a computed field on your form with a formula something like:

@If(ClosingDate = “”;“”;ClosingDate<@Yesterday;“”;“1”)

To refresh the view, you actually refresh the documents overnight with an agent. The agent’s formula will be very similar:

FIELD SelectFlag := @If(ClosingDate = “”;“”;ClosingDate<@Yesterday;“”;“1”)

Now your view selection formula will be simply:

SELECT (SelectFlag = “1”)