Retrieval of fields from view in to another form

HCL Domino Domino Forum
1

Hi all

I have to retrieve all field values in a form by just giving a value of a master field

for example.

if I provide value in employee id on form then it should fill all the corresponding values in respective fields such as name ,company name,etc (which already exist in database )

2

Subject: retrieval of fields from view in to another form

You could add some LS code to do the filling at the Exiting event of the employee field.

3

Subject: retrieval of fields from view in to another form

Hi,

Create a view with the first sorted column with the value as employee id and create other columns as per your requirement.



For Notes Client application -- you can use @DBLookup formula by referring the created view with the selected employee id as the key for getting the other values



For Web application -- Submit the form using javascript. In the WebQuerySave call an agent. In the agent, you can search the created view with the key as selected employee id to get the other field values. Finally open the same form by passing the required field values. 



To display the field values passed through url, you should create hidden fields in the form (use @URLQueryString formula )

Hope this will help you

– LJ