Windows user name

Question

Hello

Does anyone know how I might go about accessing a Survey123 users Windows username?  I am ok with assuming the user will be using Window exclusively.

I am uploading content via the survey's media folder and I'd like to allow the user to be able to open the content.  I have found a solution thanks to a post from @DeonLengton

HTML Links for Survey123 to just about anything - https://community.esri.com/t5/arcgis-survey123-blog/html-links-for-survey123-to-just-about-anything/ba-p/894670

However, the one sticking point is that I need to hardwire the Windows username into the path of where the survey stores the content (see below).

C:\Users\<WindowsUsername>\ArcGIS\My Surveys\bec6a9f59ef347f1aca5089a1a724383\esriinfo\media

I realize that I could create a text field in the survey to allow the user to enter their username and then use this in the pathname string above, but I'm looking for a solution that does not require their input if possible.

Thanks so much.

BKS

BKSchwarz · Accepted Answer

@DougBrowning I'm afraid I could not get it to work using %USERNAME%.

So I looked into Excel and the only way to do it is to create a VBA function.

In the end I decided to make them enter their Windows username as a text field and then inserted ${username} into the pathname.  This worked.  But I was hoping to not have to ask them for their username.

Thanks Brian