Just thought I'd throw out the solution I ended up
with. I created a form that contains the allowable extensions, giving the
customer the ability to modify those. I have a temp field into which the
extension for a given attachment is temporarily stored, so that it can be
compared against the extension form data. The tricky part is that Active
Link actions like Gain/Lose focus don't work against Attachment fields (only the
Pool), so I had to use Create/Modify as the trigger. Which means I might
as well use Filters.
That's where it got a little wierder. The
choice I had was to store the extension for each value in a separate field or to
create separate workflow elements for each attachment (they wanted 10)
allowed. I chose the latter, because it will make migrating their custom
HD to HD 6 easier later, and keep the HD form size from ballooning even larger
than it is. So I built Filters to 1) parse the extension, using the tip
that Stephen gave, 2) compare the extension to the data in the extension form,
and 3) return an error if there was not a match. Filters would not work,
for some reason, but identical Active Links would. The problem with the
filters appeared to be in the string parsing functionality. Normally I
would have just done that with an AL and done the rest with Filters, but to keep
the sequencing right, they all had to be one way or the other. So Active
Links were the answer.
Anyway, it works now. Thanks.
Rick
From: Action Request System discussion
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider,
Stephen
Sent: Tuesday, August 15, 2006 1:43 PM
To:
arslist@ARSLIST.ORG
Subject: Re: Filtering attachment file
types
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: arslist@ARSLIST.ORG
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.
