Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Advanced solution is below, for intermediate just imagine the interface tools aren't there.
Also, the way this was designed, if people have the same initials (for example AG), the first person gets AG@domain.com and the next guy gets AG1@domain.com, etc.
My solution.
Workflow
Formula Tool 1
First Name = Uppercase(GetWord([Name], 0))
Last Name = Uppercase(GetWord([Name], 1))
Initial = Left([First Name], 1) + Left([Last Name], 1)
Multi-Row Formula
SerNo = IF IsEmpty([Row-1:Initial]) AND IsEmpty([Row+1:Initial]) THEN Null()
ELSE [Row-1:SerNo] + 1 ENDIF
Formula Tool 2
SerNo2 = IF [SerNo] = 0 THEN "" ELSE ToString([SerNo]) ENDIF
Email Address = [Initial] + [SerNo2] + "@organizationname.com"
App
Comment
The proposed solution is:
AG1@organizationname.com
AG2@organizationname.com
...
But I think the numbering should be:
AG@organizationname.com
AG1@organizationname.com
...
because in the real world, the second person will join after the first person got his email address.
At that time, the first person should get an email address without serial number.
