I am creating multiple responses to a main document.I want to show links of all the responses in a field in main document.I have a field called responseId in response document.And i have a view (Responsev) on the response form which has to columns first is $ref and second column have formulla @text(responseID).
I have written formula for computed for display field respLink in main document.
Please help me.
Thanks a lot.
varID:=@DbLookup(“”:“NoCache”;“”:“”;“ResponseV”;@Text(@DocumentUniqueID);2);
@For(n :=1; n<=@Elements(varID); n:= n + 1;
Tempp:=@GetDocField(varID[n];“ResponseID”);
FIELD respLink := @If(n=1;Tempp; respLink : Tempp));
@If(@IsError(respLink);“”;respLink)
ths is creating problem but if i show only single link in this field t is working fine.
Cann’t we show multiple links in single text field.
I have also tried it with richtext field to show responses
Subject: how to show multiple links to responses in single field
hi,
have you ever heared from the “embedded views”?
it’s a fine way to show all responses of an document with this special object.
Subject: how to show multiple links to responses in single field
does
@IfError(@DbLookup(“” : “NoCache”; “”; “ResponseV”; @Text(@DocumentUniqueID); 2))
work?
Subject: RE: how to show multiple links to responses in single field
Bruce,Thanks for response.
@DbLookup(“” : “NoCache”; “”; “ResponseV”; @Text(@DocumentUniqueID); 2)
this function works fine without @ifError()
But 2nd column of view is @text(docID) this is not a link this is only text string.
I have to pick value in docID field on basis of returned value of above dblookup formula.
If it return only one value @getDocField works fine but if it return multiple value then there is a problem.
I have tried with & without @for.