To return the current or a specific user
There is not much to say about this function; it just returns the name or email of the current user. That's it. Wait, you can check if a specific user is using the database right now!
In combination with the field type User you can show specific records only to specific users.
user()To return the current user.
Result: Olaf Scholz (if Olaf Scholz is currently using the database)
user(myUsername)To return a user. There is no return if the given username doesn't match the name of any member of the workspace (team).
Result: No return, i.e. an empty field, if Boris Johnson is not a member of the workspace (team)
user() = user("Olaf Scholz") or user() = user("Emmanuel Macron")
Result: Yes (if the current user is Olaf Scholz or Emmanuel Macron)
Choose the User field and select Olaf Scholz.
user() = 'Assigned to'
Return: Yes (with the User field Assigned to having the value Olaf Scholz)
If added in the field Readable if in the table settings, you'll only see the records assigned to Olaf Scholz only in case you are Olaf Scholz.