I have an application that welcomes the user by using their first name in a welcome message. I use the following formula to extract their first name from their username:
The problem I have now is that someone has joined our company with a two word firstname. Now the formula only returns the first word of her firstname which she does not like. I have been able to manipulate the formula to return both words of her first name but then this does not work for everyone else.
I've tried using @Name([G];@Username) which according to designer help will return the "given" name but it doesn't seem to work.
Anyone with any ideas?