Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Solution for auto Email Name Generation (format)


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

Recommended Posts

  • Newbies

Am trying to have the email addresses for my 'Users' table auto create per the format that this customer uses. Of course everyone does things differently!

I created radio buttons for these options:

1. <firstname><lastname>

2. <lastname><firstname>

3. <firstinitial><lastname>

4. <firstname>

5. <lastname>

6. <initials>

Am not sure where to start on the If/Then script. Want the applicable result of the radio button selection to pull the appropriate format of the name fields & append them to the customer's &"@"&<domain name>. The result of course will be their proper email address.

Anyone done this yet, or have any ideas?

Kent Barnard, MCSE(NT/2K Gold)/CCNA/CCEA

ACS, Inc. (Macon, Georgia)

Link to comment
Share on other sites

You could create a calc (text) field to deliver the required email address combination - from your radio button field. In the following example, the radio button field is called "NameOption" and the choices are 1 to 6.

Substitute(Substitute(

Case(

NameOption = 1, FirstName & LastName & "@" & DomainName,

NameOption = 2, lastName & FirstName & "@" & DomainName,

NameOption = 3, Left(FirstName,1) & LastName & "@" & DomainName,

NameOption = 4, FirstName & "@" & DomainName,

NameOption = 5, LastName & "@" & DomainName,

NameOption = 6, Left(FirstName,1) & Left(LastName,1) & "@" & DomainName,

"Error")," ",""),"P","")

where the P in the last line is the backwards paragraph thingo. The substitute parts of the calc will eliminate any spaces and carriage returns from the email address. If the user has not provided a name, then you will get "Error" in the email address - so you can easily do a Find for that.

Link to comment
Share on other sites

This topic is 7861 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
×
×
  • Create New...

Important Information

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