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
I was maknig a bigger deal out of this than it was. Luckily I only had
to test that it was not two of the available entries. So the usual
(('fieldname' != DEF) or ('fieldname' != MNO) worked out.
I don't know if this would be appropriate nder a more complicated
scenario.
Thanks all just for
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
Also, you could add another field to your 'search menu' form to designate
(say Yes/No) as to whether you want to validate that item. Then either
include that field in your setfields qualification. That would allow you
to adjust the match via data and not have to change the code if XYZ
becomes
Christine,
Typically, using two not equals and an OR doesn't do what you expect.
If your field contains XYZ, then the first clause ( != ABC) is true, and
the whole statement is true. Same goes for when the field is ABC, then the
other side is true. Consider either of the following two
5 matches
Mail list logo