Autofil scripts

[deschrijver]

I am making a form for my email users.

Now i have made an calculation field in wich I achieve that iff I make a new user, the name of the user will be implemented in the email field.

For example, new users name is John Smith his email adress will be [email protected].

This is done by the calculation

Left( Voornaam, 1 )

&"."

&RightWords(Achternaam , 1 )

&"@"

&InternetDomein

But nuw I also have edresses for departments.

For example the department prepress the email adres will be [email protected]

Now I want to complete the calculation that if the user is prepress the email will be as above.

How do I make this calculation in this field?

[PinnWal]

I would change the "If" statement to a "case" statement. Now I would simply add more conditions to the calculation.

For Example:

Case(Category="Prepress", emailcalc=etc...

Category="Admin", emailcalc=etc...,

yada yada yada)

I hope this solves your problem, if it doesn't then I apologize in advance for my stupidity -)

Later,

Paul -)