Data validation is usually better handled with filters instead of active links.
That being said, the general approach is
1st form:
Add (or identify) a scratch character field (scratch_char)
1st filter
On submit, on modify, on merge
Run if: [leave blank]
1st action
Set fields from 2nd_form
Set fields if: 2nd_form_field = 1st_form_field
Set scratch_char = request_id
Multi-match = use first
No match = set to NULL
2nd filter
On submit, on modify, on merge
Run if: scratch_char = $NULL$
1st action
Error message
Else 1st action
Set fields
Scratch_char = null
Note that you may want to be more restrictive on the 1st filter set fields if
qualification -- it's usually similar to the search criteria of the menu
attached to 1st_field_form.
HTH,
--Phil
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Christine
Sent: Thursday, October 28, 2010 14:42
To: [email protected]
Subject: Validating an ACTL Run-If statement against a search type menu value
I have a field on one form that utilizes a search type menu (which
references a field on another form). I need to create an ACTL for the
first form where the Run If statement says 'If field value is ABC or
XYZ" where ABC or XYZ is a field value on the second form.
The Search-type menu has more options than ABC or XYZ.
Does anyone have an example of how I can validate the chosen field
value on the first form against the multiple field value entries on
the second form?
ARS 7.1.00 Patch 002
Incident 7.0.03 Patch 007
Thanks,
Christine
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
