Lookup response doc field

HCL Domino Domino Forum
1

Have a view for lookup with SELECT Form = “Parent” | @IsResponseDoc View SelectionThis column has a number field which grabs a number field of parent document and sorted & categorized.

2nd column also sorted and grabs a number field of child/response doc.

Now I can lookup first column but cant grab 2nd column which is a field of child/response doc.

I can see the number if i run the view but cant use @Dblookup with a key value, which is inherited from parent number field.

Num := @Subset(@DbLookup(“” : “NoCache”; “”:“”; “AutoNum”;No_nu; 2); 1);

@If(@IsError(Num); 1; Num + 1)

Always returns “Incorrect data type …Text expected” as its a computed number field of Child doc.

Please help.

Thanks in advance

2

Subject: Lookup response doc field

Please modify the FL code as below and have a try on that.

Num := @Subset(@DbLookup(“” : “NoCache”; “”:“”; “AutoNum”;No_nu; 2); 1);

Num1 := @ToNumber(Num) + 1;

@If(@IsError(Num); 1; @Text(Num1))

3

Subject: Lookup response doc field