memory function

[Academie]

Good morning I wish that my collaborators did not write each time their name and first name What function is it possible to open for this to be possible?

Many Thanks

[Tom_Stevens · Accepted solution]

Have a secondary reference table with user emails & names. Then on the table you want to auto populate write something like this in the formula field:

lookup(USEREMAIL(),"The table with the emails & names", "The column with the emails", "The column with the first or last name you want to auto populate") 

[WillowMobileSys]

---

@Academie wrote:

Good morning I wish that my collaborators did not write each time their name and first name What function is it possible to open for this to be possible?

---

Please explain where the collaborators need to enter their name?

[Tom_Stevens · Accepted solution]

Have a secondary reference table with user emails & names. Then on the table you want to auto populate write something like this in the formula field:

lookup(USEREMAIL(),"The table with the emails & names", "The column with the emails", "The column with the first or last name you want to auto populate") 

[WillowMobileSys · Accepted solution]

Ok, that is great!    I would recommend you follow the concept in this Tip article.  

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Current-User-Slice-How-to-conform-your-app-aroun...

[Tom_Stevens]

Yes exactly.

[Academie]

Many Thanks i will try it

[AleksiAlkio]

One way is to have that info in Usersettings table and then read that with the initial value.