Here is a fun one (NOT!!)
We have a department that depends on the number of emails received for some sort quota system. They take incoming emails and actually move them from the Inbox to various folders in the mail file.
What they just asked me to do sounds like it is not possible but I thought I would ask everyone here to toss their ideas into the ring.
I need to create a report view that shows/counts the documents in a specific set of folders while not showing/counting those in others.
Is there any script that I can use in the selection formula of a view that will only include documents in specific folders?
Remember all these documents are either Memo or Reply documents so I cannot simply select on Form.
Subject: Count documents only in specific folders
yea its pretty easy, roy. just create a button.
in the button add the code:
folder:=@prompt…OKCANCELEDIT…“please enter the name of a folder” ; “”);
they enter the name of the folder as it appears.
then…
number_of_emails:=@Elements(@dbcolumn(…folder ; 2))
@prompt([OK];“title” ; “There are “+@Text(number_of_emails)+” e-mails in the “+folder+” fodler.”);
i didnt write out all the code…i’ll let u do a little learning at the same time.
HTH
ST
Subject: RE: Count documents only in specific folders
First of all this has to be done in a view so dbcolumn is out. Second, there are dozens of folders that have to be included and dozens that are not.
The report is a view that has to list out all the emails in date order sorted by folder with counts on various categories such as “Memo”, “Reply”, “Undeliverable”, etc.
Any other ideas?
Subject: RE: Count documents only in specific folders
you cant display that info in a view. u need to create a report.
and yes, dbcolumn will work in the context i mentioned. at any rate, what you want can be done…
the next best thing would be to create come categories in the folder itself with master counter as the first column, that way each category and sub category would have a total number of documnets displayed. The user would then have to click on each folder manually to see the statistics for each one. Your categories would obviuosuy be Memo, Reply, etc…
HTH
ST
Subject: RE: Count documents only in specific folders
As I said, this has to be in one view so again your idea won’t work. The users do not want to click on each folder manually. They can already do that. They want a total from a group of folders.
It is obvious you missed the point in my first email. This has to be in a view so your dbcolumn idea will not work either.
I know I could create a report in a form, but uness you know of a way to print the view on a form, that won’t work either. It would have to be an embedded view and with 100’s or possibly 1000’s of documents, it cannot be printed (another requirement and the reason it has to be in a view).
So back to my original question, can a view be set up to display only those documents in specific folders while ignoring documents in other folders?
Subject: RE: Count documents only in specific folders
I don’t beleive there is any practicle solution for what you are looking for. You or your users will have to comprise with a per folder solution.
you cannot SELECT where folder=… this doesn’t exist. You can, however, create a report (form) where you do a dblookup against each folder and returning their documents as text in a multi-value field. This will be a pain to program and you will never be able to give those categorized statistics the view can.
ST