CODEWITHSUNDEEP
lotus-notes
hjh93
hjh93

Reputation: 570

Lotus Notes - Why is my view data missing?

I recently just constructed a new view for a Lotus Notes Application and tested it to be fine.

It was supposed to get field data from 2 nearly identical forms and display into the view. The fields on both forms share the same name.

The formula used in View Selection is

SELECT ContactName; CompanyName; ContactNumber; CarNo; RequestDate
--comment: These are the names used in both forms --

This worked fine yesterday. Also I made sure that each column has selected the correct field to display and I did not change any settings. However, today when I went back to check, the view is all empty.

What seems to be the cause of this?

Upvotes: 0

Views: 366

Answers (1)

Per Henrik Lausten
Per Henrik Lausten

Reputation: 21709

Your selection formula for the view is not correct. You use the name of the forms in the select statement and then add your fields as column in the view. If we assume that the forms are called FormA and FormB, then your selection formula for the view can look like this:

SELECT Form="FormA":"FormB"

Upvotes: 3

Related Questions