27Jun22 1555 Capturing USER ID

[Techuke]

27Jun22 1555 I want to show the ID of the person who most recently worked on a job record in my prototype app.  It is not deployed. USERMAIL (), USER (), etc don't work. Anyone out there with ideas? Thank you !

[Suvrutt_Gurjar]

You may want to elaborate your requirement.

In general, if you place the USEREMAIL() in the app formula of the [Email] column, it will capture the email of the person who has latest edited the record.

[Techuke]

27Jun22 1749 Thank you very much @Suvrutt_Gurjar .. when I place USEREMAIL () in the app formula of the eMail column, it causes all my JOBS sheet rows to be assigned my eMail - although three of us are using the app and modifying the JOBS

[Suvrutt_Gurjar · Accepted solution]

When one of those three people will edit a row, their USEREMAIL() will be captured. It sounds you are testing with just your own ID.

[Techuke]

27Jun22 18915 That is true @Suvrutt_Gurjar .. I am testing just with my own ID !! Thank you, solved !! Much appreciated.

[Suvrutt_Gurjar]

Great. Do test well as per your requirement.