I want to record columns (such as my rating of files) about such as xls, ppts, docs web pages I have downloaded, pics on my PC
once i have this i can then use the filters to find the documents and then look at the through hyperlinks and then add information into columns or print the documents
So I need a s/sheet that will allow me to keep a list of all my files in a directory and sub directories (excluding some extensions)
and the folder, full path, file name, create date/ modified date and a hyperlink) and allow me to fill in comments and additional fields such as client, what state, my rating of the document, notes
I would also like to
- filter the s/sheet columns
- not delete files from the s/sheet accidently , but i want to be able to do it
- not accidently delete columns, but i want to be able to do it
- use filters
- exclude some extensions
- search the contents of the files so i can see what files match
- delete or rename a file through windows, but i want the file marked as missing if i have filled in any data about it, i still might delete it though
- at some stage maybe move it from C:\ to D:\ or to
To make life harder the same file name may exist in multiple folder and i would like these flagged and either have some easy way of renaming them OR saying they are the same as another file
once i have this i can then use the filters to find the documents and then look at the through hyperlinks and then add information into columns or print the documents
So I need a s/sheet that will allow me to keep a list of all my files in a directory and sub directories (excluding some extensions)
and the folder, full path, file name, create date/ modified date and a hyperlink) and allow me to fill in comments and additional fields such as client, what state, my rating of the document, notes
I would also like to
- filter the s/sheet columns
- not delete files from the s/sheet accidently , but i want to be able to do it
- not accidently delete columns, but i want to be able to do it
- use filters
- exclude some extensions
- search the contents of the files so i can see what files match
- delete or rename a file through windows, but i want the file marked as missing if i have filled in any data about it, i still might delete it though
- at some stage maybe move it from C:\ to D:\ or to
To make life harder the same file name may exist in multiple folder and i would like these flagged and either have some easy way of renaming them OR saying they are the same as another file