Selection in field

[soha1902]

Hi All,

I have 2 list box in my dashboard ID and Name. I added one sheet level trigger on Activate Sheet event. please see below image:

I am matching OS user name with ID and selecting that ID in ID list box. but as per my requirement I need to match OS user name with Name and I need to select that name in Name list box.

Please find sample qvw in attachment.

Please help.

Thanks.

[Gysbert_Wassenaar]

Add another action to select the possible values in the Name listbox. Optionally add yet another action to clear the selection in the ID field.

[soha1902]

I tried to implement but not getting the desired output. Can you please explain in detail.

Thanks

[rubenmarin]

Hi Soha, I can't see your OsUser(), I see mine, but try with this:

=Subfield(OSUser(), '\', -1)

[Gysbert_Wassenaar · Accepted solution]