Displaying Docs in a view which do not have an Attachments or Doclink inserted

Hi,

I’ve been searching the forum and it has helped me look into @DocFields and @IsAvailable, but I’m stuck and wanted some help.

I have a form which has a field called Attachments which is a Rich Text field.

This field can consist of a doclink or attachment, and sometimes just text. In a view I am wanting to see all documents which do not have a value in the Attachments field.

I have been working backwards, to see if I can get all documents with a value to display, but I’m having problems.

The code below returns “No” even when there is a doclink in the Attachments field. If I was to replace $LINKS with $FILE it works, it displays an attachment.

@If(@Contains(@DocFields;“$LINKS”);“Yes”;“No”)

Does anyone know how I can get a view to display all documents which do not have a value in the Attachments field?

Thanks,

Hayley.

Subject: Displaying Docs in a view which do not have an Attachments or Doclink inserted

Hi,

Thanks for responding. The @Attachments=0 worked, but the @Abstract([TEXONLY];“Attachments”)=0 did not work. It kept having errors with the round brackets… although the syntax looks fine. Any other suggestions? This is a in a view selection.

Thanks,

Hayley.

Subject: RE: Displaying Docs in a view which do not have an Attachments or Doclink inserted

Can you try this and check

@Abstract( [TextOnly]; 200; “”; “Attachments” )

HTH

Keshava

Subject: RE: Displaying Docs in a view which do not have an Attachments or Doclink inserted

You can’t use @Abstract in a view formula; rich text fields are not summary data, and aren’t available to view selection or column formulas.

Subject: Displaying Docs in a view which do not have an Attachments or Doclink inserted

@DocFields works in a form to find if there are links.

Can you try having this selection formula

@Abstract([TEXTONLY];“Attachments”) =“” & @attachments = 0

HTH

Keshava