Jump to content

Recommended Posts

Posted

Can anyone assist me in creating a rule which will allow me to remove spaces and/or special characters?

 

I've got a rule which auto-populates an email address by combining the first initial of the first name (FName Field) with the last name (LName Field). This works well except in instances where a last name is something like O'Reilly or De Angela.

  • 6 months later...
Posted

This is exactly what I have been looking for. Well, almost.

 

What would the complete rule on this look like? Create an email address by combining the first initial of the first name (FName Field) with the last name (LName Field) and then place "@company.com".

 

Thanks

Posted

Here's an example of how the entire rule could look:

 

var first = Left(Field("FName"),1);
var last = Field("LName");
return [first,last].filter(String).join("").replace(/\s|\'/g,"") + "@company.com";

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...