Jump to content

Autofil scripts


This topic is 8019 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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?

Link to comment
Share on other sites

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 ???-)

Link to comment
Share on other sites

This topic is 8019 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.