Rick,
In a Filter use a Set Fields to set a Character
field to the value of the LOWER(Attachment Field). This should populate
the Character field with the filename and other info. Fortunately, the
filename is the last item in the semi-colon delimited list.
In the next filter check for: NOT
( 'Filename' LIKE "%.xls" OR 'Filename' LIKE "%.doc" OR 'Filename' LIKE
"%.etc")
If true, then display an error
message.
Regarding the attachment form, you can use drag-n-drop
with it. Create a display only form with an attachment pool and one
attachment field. This form can be accessed by a button from many
different forms.
Users would drag a file into the attachment pool as
usual. Then they would click a button to Save it. The Save button would push the
attachment to your attachment form and then clear the attachment pool on the DO
form waiting for the next file.
HTH
Stephen
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Tuesday, August 15, 2006 4:07 PM
To: [email protected]
Subject: Filtering attachment file types
I'm trying to only allow
certain file types (.xls, .doc, etc.) in an attachment field, and not seeing how
to do that. My attempts to use a Filter to do a wildcard search on the
various field types is not doing what I think it should. Has anyone
conquered this yet?
I think might have more
control over file types if I went to an attachment form, but then I'd lose
the drag and drop functionality that the users probably want more than they want
the file type limitations.
