Hi Rick,
To do this you can use a few functions to chop the last say
6 chars from the end of the attachment name. You can then look for the
first occurrence of a full stop, note its position and then take the remaining
characters being the file extension. You then have a
filter that checks for your file extension.
You can use a few zTmp display only fields to
hold the values of the following
RIGHT([Field_Name], 6)
get last 6 chars
STRSTR(Field_Name,.)
find position of full stop (X)
SUBSTR([Field_Name],(X))
leaves you with file extension
If you have multiple attachment fields, use a filter guide
to step through the fields until you find an attachment that is forbidden and
then throw an error.
Lettuce know how you get on.
Rgds,
Dave
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: 15 August 2006 21:07
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.
____________________________________________________________________________________
Rick
Cook • Remedy Approved Consultant •
Denali Advanced Integration • (253)
278-4112
--
No virus found in this incoming message.
Checked by AVG
Free Edition.
Version: 7.1.405 / Virus Database: 268.10.10/419 - Release
Date: 15/08/2006
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.10.10/419 - Release Date: 15/08/2006
