topic Re: Look up OSUser() from list and return value in Water Cooler

Look up OSUser() from list and return value

danm84306 — Thu, 14 Aug 2014 18:11:13 GMT

Hello,

I am looking for the proper expression to look up the OSUser() value from a table list to return the proper
name value. For example, if the OSUser()= ADMIN\frizzo the expression would return the value "Frank" from the table.

Table

ADMIN\frizzo, Frank

Re: Look up OSUser() from list and return value

evan_kurowski — Thu, 14 Aug 2014 18:19:19 GMT

If your two column table above had the field names:

NTName, Name

ADMIN\frizzo, Frank

You could enter this expression in a text box to return Frank:
=Only({<NTName={$(=OSUser())}>} Name)

Re: Look up OSUser() from list and return value

danm84306 — Thu, 14 Aug 2014 18:23:25 GMT

Worked like a charm! Thank you!

Re: Look up OSUser() from list and return value

Thu, 14 Aug 2014 18:39:54 GMT

You can use wildmatch. Lets say your table is like below:

Table:

Col1, Col2

CompanyName\C8724, Frank

CompanyName\C9823, Mary

Then on the front end you can just create a straight table

Dim: Col2

Exp: If( Wildmatch(Upper(Col1),OSUser()),Col2)

Then you can hide the expression in Presentation tab

Re: Look up OSUser() from list and return value

evan_kurowski — Thu, 14 Aug 2014 19:53:05 GMT

Dan McDonald wrote:

Worked like a charm! Thank you!

Haha! You are correct sir.