Get the actual user in custom widget

I found a workaround solution because I don’t think its possible through the Grist plugin api to get the user directly.

To get the user name and user email from a custom widget:

  1. Add a trigger formula to a column user.Name or user.Email (apply to new records)
  2. use the plugin api to create a new record in that table onload
  3. then read the row to get the values