I have a field that contains users (from the user table) and I want to populate a different field with user data like their names, emails and so on. I tried using formulas, but that gave me empty strings.
For example, user field is G8 of type “select user”, so I used the formula “G8” in the new field of type “free text” hoping to get the user name, but I got blanks. And, yes, I did click on “apply this formula to all saved records”.
Is there a way to do that?