Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a text box at the top of my document which says welcome to the dashboard you are using version x.
The expression I am using is ='Welcome ' & OSUser() & 'you are using version ' & $(varversion)
Do you know if there is any way I can lookup OSUSer against another table (similar to vlookup) to pull up the users name rather that their ID?
Thanks,
Felim
Felim,
Attached is a .qvw that should welcome you on opening. Check the 'OnOpen' actions and the 'User' variable.
It works for me so if there's an error and all you see is 'Welcome: ' then check my spellings etc.
I've also attached the .xls file that it's driving from.
Hope that helps,
Matt - Visual Analytics Ltd
Felim,
Let me know what you're osuser() value is and I'll send you a working demo I've created.
All the best,
Matt - Visual Analytics Ltd
Felim,
Attached is a .qvw that should welcome you on opening. Check the 'OnOpen' actions and the 'User' variable.
It works for me so if there's an error and all you see is 'Welcome: ' then check my spellings etc.
I've also attached the .xls file that it's driving from.
Hope that helps,
Matt - Visual Analytics Ltd
Hi,
I have similar issue, I just want to show the name not entire log-in crediantial like domain name then user name. I want to do this is designing screen, is this possible?
= ' Welcome Mr/Ms.' OSuser() &
IF(Now() < '12:00', ' Good Morning ' , ' Hello')
and result is giving the domain/username, which I dont want.
Best Regards,
Shubham
try Subfield(OSuser(),'/',2)
Chris
my osuser() has a backslash as well as a "." between first and last so amended to cater for this:
=replace(Subfield(OSuser(),'\',2),'.',' ')
chriscammers wrote:
try Subfield(OSuser(),'/',2)
Chris