Lookup formula issues.

Posted on 2010-01-12
Medium Priority
Last Modified: 2013-12-18
Have a form which has a subform for points of contact for various depts. There are about 15 computed fields which initially worked perfect. Because they might need to reassign these to another user due to vacation they needed to be editable. When I changed them over to editable only one of the fields pulled in the name properly. The rest get no data at all. I have checked the field properties and they are identical. What would make one formula to work when none of the others get any data.   Any ideas?

This formula is working  @DbLookup("": "NoCache";"";"poc";agency_num;2;[FailSilent])
This formula is not working  @DbLookup("": "NoCache";"";"poc";agency_num;3;[FailSilent])

Question by:jforget1
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 46

Accepted Solution

Sjef Bosman earned 1000 total points
ID: 26299003
Would the formerly computed fields perhaps have an Evaluation or Validation formula that is incorrect?

Suggesting the following change, for debugging purposes only:

      @Prompt([OK]; "agency_num"; agency_num);
      x:= @DbLookup("": "NoCache";"";"poc";agency_num;3)
      @Prompt([OK]; "x"; x);

The view poc, is it sorted, and is agency_num indeed an index in that view? If agency_num is numeric, is the first column in the view also numeric? Always?
LVL 19

Assisted Solution

madheeswar earned 1000 total points
ID: 26299782
If my understanding is right, you changed the Computed fields to Editable. If it is the case then, the DBLookup won't work for editable fields. You need to make the editable fields as Dialoglist/checbox/radiobutton type. Else, display a picklist (use @Picklist) and from the selection of the document in the picklist, you can capture other values to the editable fields.
Alternatively, you can use Lotus Script as well.

Author Comment

ID: 26303960
Figured this one out, was pulling the values from a PickList. I had rem'ed some of those out. I am just going to add the code to pull all, the values to this code.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

766 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question