Automating Custom Forms

[Simon Monckton]

I have created a custom contact form in OL2000 and
wondered if there was a way of automating the population
of one user defined field based on the content of another
field without using the form code.

Can this be done from the field properties via validation
formulae?

Any help would be much appreciated

Simon

 

[Sue Mosher [MVP-Outlook]]

Yes, but with a value formula, not a validation formula.

 

[Guest]

Sue,

Thanks for the prompt response!

I am hoping to create boolean agruments and else if
statements and was curious as to the syntax.

Can I use the following;

If item.userproperties.find("FieldName").value = "value"
then item.userproperties.find("ThisField").value = "AAA"
else if.... etc

Regards
Simon Monckton

 

[Sue Mosher [MVP-Outlook]]

You cannot use VBScript code like you have below to build a formula. If you
use the formula editor, you'll see the available functions and field names.
In your case it might be:

IIf([FieldName] = "value", "AAA", "somethingelse")

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers