Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
when all users are loaded from a spreadsheet
I've resolved it myself in the meantime 🙂
. . .
QVUsers:
load [Authenticated user] as UserID,
FullName as UserFullName
from [..\AllQVUsers.xlsx] (ooxml, embedded labels, table is Sheet1);
vUserName = lookup('UserFullName', 'UserID', upper(OSUser()));
I've resolved it myself in the meantime 🙂
. . .
QVUsers:
load [Authenticated user] as UserID,
FullName as UserFullName
from [..\AllQVUsers.xlsx] (ooxml, embedded labels, table is Sheet1);
vUserName = lookup('UserFullName', 'UserID', upper(OSUser()));