AboutPaski K. Paskaradevan Expertise I have 3 + years in Lotus Notes application development. I am a CLP R5 Application Development. I can answer any question pertaining to application development.
Experience R5 CLP. In addition, I have a bachelors degree in Engineering and a MBA.
Expert: Paski K. Paskaradevan Date: 12/1/2007 Subject: Automatically complete field in form
Question I have created a form to enter user details. The three details Name, UserID and Telephone Number can all be found in a view with in another database (Coporate Address Book). I currently have it so that name field is a dialog list and "Uses an address dialog for choices". What I would like to happen is then the other feilds to be filled in automatically depending on what name has been selected. I hope this makes sence. Thank-you
Answer Hi,
There are two ways you can do this. I am going to explain this for one field. You can duplicate it for other fields.
1. Make the userID field computed and the formula is a @dblookup formula using the name entered as the key. The names field property should be set to Refresh Fields on keyword change. The disadvantage is that this will refresh the form every time you select a new name and I normally do not like this.
2. Make the names field Computed (type should still be names). Then create a button which will use @prompt and @picklist([names].....) so that when the button is clicked, the name can be picked from the CNAB. Use FIELD keyword to set the names field. In that button use the @dblookup formula to pick up the UserID and use the FIELD keyword to set the UserID field. I like this method since it does not refresh the document every time a new name is selected.
But both are ok. It is a matter of personal preference and if there are any validation formulas in other fields in the form.
