$$return

HCL Domino Domino Forum
1

hi all ,

I have 2 forms.

In one of the forms, i have a field called “company” (editable text).

In the other form , i have a field $$return.

Can i display the value of company field using the $$ return field.

Any responces greatly appreciated!

Thanks,

Jay.

2

Subject: You can do a @dblookup to lookup the second document to get the company field

You will need to have a view that is suitable for looking up data (sorted by some sort of key) to be able to access the seond document. Then just use a @dblookup to lookup the data.

Howard

3

Subject: i do have a @dblookup

Yes , i do have a view(called jobposting) and used @dblookup to it.It goes like this:

companyname :=@DbLookup “Notes”:“NoCache”;“”:" databasename";“jobposting”;company;“company”);

@Return("

Your job application to “+ companyname+” has been sucessfully submitted.


When i am using the above statement, all the entries of the view column “company” are diaplayed. What if i want to display just the first entry of the company column.

thanks,

Jay

4

Subject: Why not just use:

@Return("

Your job application to “+ company +” has been sucessfully submitted.


5

Subject: RE: Why not just use:

Yes, life’s so easy.

6

Subject: No

No No… that doesnt work. The $$return fieldand the company field are in different forms.

The values that are entered in the company field are stored in the company column (in view.)

The problem is i want to retrieve ONLY the first entry from the company column in the view.

When i use @dblookup, its displaying all the entries in the company column instead of displaying just the first one.

is ther any way of doing this?

thanks,

Jay

7

Subject: @Subset

I think you are looking for @Subset. Assign the DBlookup to a temp value and then do an @Subset to the temp value, something like this:

CompanyLU := @Dblookup(etc) ;

@Subset(CompanyLU ; 1)

Hope that is what you are looking for.