I have added authorship column using the default options provided by Grist - thanks, it was quick to get these columns set up in a consistent way - thought it would have been better if there was a way to specify which default columns I want for every new table (Created by/at, Last updated by/at).
The problem I have is this - my grist user.name is Siraj Samsudeen, however in the user table, I use a short version of the name - Siraj. I want the Created by to a Reference to my custom user table - but the problem I have is that I only have the email ID of the user and I do not have an easy way to get the user associated with that email. What formula column should I set up so that I will get the Grist Default userName in my custom user table.
The workaround I tried was to use user.email to populate Created by, and it is showing my email ID, but I want it to show my current user name (this method is resilient to changes in User name, in case the user changes his user name in Grist). I can link to the email ID in my custom user table - but would this work properly with the trigger formula.
Any ideas on how to do this properly is appreciated.