Copy data from a Response form feidl to Main Topic form field

HCL Domino Domino Forum
1

Hello,

I have created a discussion database and need to populated a data field on the Main Topic once a related child document (Response) has been created. Would like to pass the author field for the Response back to the related Main Topic.

I do not have any experience in Lotus Script. Do have some limited experience using @commands.

Any advise is greatly appreciated.

Thanks.

Elvis :o)

2

Subject: Copy data from a Response form feidl to Main Topic form field

In a response document the document unique id of the parent document is stored in a field called $Ref.

You could do this in formula language by using the @SetDocField function in the QuerySave event of the response document or the authors field input translation event.

@SetDocfield($Ref; “MainFieldName”; ResponseFieldName)

If you are dealing with several response documents and you want a list of authors in the main document then you will need to retrieve the values already in the field first using @GetDocField.

If you are using response to response documents then it gets more complicated as the $Ref field will refer to its parent document and not the main document. you would need to iterate up the tree until you find the main document.

3

Subject: RE: Copy data from a Response form feidl to Main Topic form field

Thank you. This is a good start for me.