Merry Christmas :)
I wonder if someone can help : I have a form, and when I create a document using this form, I have a hidden computed field (linksLookup) in which I want to look up to a view (viewLookup) by key (refNo), and return all entries in the third column of the view where the reference number is the same as that on my form. These will be HTML links to documents.
The view contains 3 columns :
Column 1 : Refno
Column 2 : Name
Column 3 : Link
so basically, if the reference no. on my form was "ABC-123" I want my computed field to contain the data in column 3 of view where column 1 = "ABC-123"...
It is not working at the moment (I get an error because I am error trapping - see below).. I think this maybe because I am using a DBLookup, and there are multiple entries?
Can anyone advise how they would go about this?
Here is the code in my hidden field:
links := @DbLookup("":"NoCache"; "";"viewLookup"; refNo; 3);
return:= @If(!@IsError(links); links; "Error") ;