Look up OSUser() from list and return value

[danm84306]

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

[evan_kurowski]

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)

[danm84306 · Accepted solution]

Worked like a charm! Thank you!

[#4]

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

[evan_kurowski]

Dan McDonald wrote:

Worked like a charm! Thank you!

Haha!  You are correct sir.