As an optional addition you can store icons of the most common document formats
that you can display instead of the paperclip. I did this creating small icons:
Create icons:
- open windows explorer
- go to a folder with different document types
- do View > List
- press PrntScrn
- open an image editor (like Paint)
- convert the icons to JPGs
- save them as PDF.JPG, DOC. JPG, XLS.JPG etc
- import them as Image Resources in the database
- in the multi value computed for display text field with seperator 'New Line
put the formula:
DB:=@ReplaceSubstring(@ReplaceSubstring(@Subset(@DbName; -1);" ";"+");"\\";"/");
AN:=@AttachmentNames;
@If(!@Attachments; @Return(""); "");
"<a href=/$File/" + AN + "><IMG SRC=/"+DB+"/"+@Right(AN;3)
+".jpg?OpenImageResource border=\"0\" >" +AN + "</a>"
off course, insert scare brackets before and after HTML code.
Very nice.
As an optional addition you can store icons of the most common document formats that you can display instead of the paperclip. I did this creating small icons:
Create icons: - open windows explorer - go to a folder with different document types - do View > List - press PrntScrn - open an image editor (like Paint) - convert the icons to JPGs - save them as PDF.JPG, DOC. JPG, XLS.JPG etc
- import them as Image Resources in the database
- in the multi value computed for display text field with seperator 'New Line put the formula:
DB:=@ReplaceSubstring(@ReplaceSubstring(@Subset(@DbName; -1);" ";"+");"\\";"/"); AN:=@AttachmentNames; @If(!@Attachments; @Return(""); ""); "<a href=/$File/" + AN + "><IMG SRC=/"+DB+"/"+@Right(AN;3) +".jpg?OpenImageResource border=\"0\" >" +AN + "</a>" off course, insert scare brackets before and after HTML code.