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