Extracting custom properties of Notes Attachment using @formula

[agaasenb]

Hi,

'm trying to extract custom properties of a Notes Attachment(Word, Excel etc.)
using a Notes formula and store this in a field(in this case a Verity field)

Example of a custom property is: AuthorID

I've tried the following:

@If(@Attachments>0;@GetDocField($Ref;"Authorid");"AG")
(explanation:If Attachment, copy DocField(AuthorID) to Authorid else copy
AG to AuthorID' as test)

@If(@Attachments>0;@GetDocField(@_document_UniqueID);"Authorid");"AG")
If Attchment, copy DocField(AuthorID) to Authorid else copy AG to AuthorID

@If(@Attachments>0;@GetField(@_document_UniqueID);"Authorid");"AG")

Can't get this to work. Am I overlooking something ?
FYI:Lotus Notes script language can NOT be used!

Thanks for every help/suggestion

Arthur

 

[pmonett]

What you are trying to do is use Field Exchange on an attachment - but that can only be done with an embedded object on which you can use OLE. Attachments cannot be examined to extract information other than file name and file size.

Open the Designer Help db and look for "field" & "exchange" to find the necessary documentation to get you started.

Pascal.