Method to get user's name

AppSheet AppSheet Q&A
,
1

Since the USERNAME() function is depreciated, are there any other methods to get a user’s name related to their email? Most of the apps I’m building are internal facing for our staff, and we’re all on Google Workspace.

The workaround I’ve done in the past is to have a user directory spreadsheet that is updated on a schedule which includes both email and name, but this requires extra resources to maintain all of these directory spreadsheets.

Is a better method to call an App Script (similar to the method in the link below), or is there some better practice?

https://stackoverflow.com/questions/37738050/how-can-i-get-a-users-name-from-their-email

2

Sad news.

I think you should make a userstable by somehow exporting your list of emails made through workspace

3 Likes
3

Thanks SkrOYC

Yeah, I was also thinking of a single usertable with all of the data I could need, but I don’t think I’ll be able to convince my org to do something like that.