Sure ... You can do a simple Set Fields action to set a
Display Only temp field as an indicator. A second filter then checks the
indicator to see if the value exists.
Example
Scenario: Regular Remedy form called FormA with
only default fields (plus a 15 char display only field called zTmpDupID).
You want to make sure users don't enter a short description
twice.
Submit version
Filter 1 On Submit
Action 1:
Set
fields Read value from FormA
Set Fields If: 'Short Description' =
$Short Description$
No Requests Match Set to
$NULL$
Any Requests Match Use First
Matching
Set zTmpDupID = $Request ID$
Modify version
Filter 1 On Modify
Action 1:
Set
fields Read value from FormA
Set Fields If: 'Short Description' =
$Short Description$ and 'Request ID' != $Request ID$
No Requests Match Set to
$NULL$
Any Requests Match Use First
Matching
Set zTmpDupID = $Request
ID$
Filter 2
If zTmpDupID != $NULL$ Show Error to prevent
save
Hope this info helps
Fred
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sullivan, Neil G CTR USAF AFRL/SNOX
Sent: Friday, October 13, 2006 8:08 AM
To: [email protected]
Subject: Duplicate Records
Listers,
Is there any way possible to use workflow to check for duplicate records in a form without using a unique index? I can't use an index because some of the values in the field will be null.
Any help is appreciated.
Neil "Sully" Sullivan
Remedy Developer/Administrator
AFRL/SNOX
Wright Patterson AFB, OH
45433
937-904-9788
__20060125_______________________This posting was submitted with HTML in it___
