How to capture the Create_Date timestamp and Created_By email

AppSheet AppSheet Q&A
1

Hi all,

How I handle the requirement to capture in a data source field the timestamp when the record was created [Create_Date], or by whom the record was created [Created_By]? I went through the online sources but I was not able to find something.

Thx!

Markus

2

Set the ā€œinitial valueā€ of the column. Using the codes now() and useremail() should solve, respectively.

1 Like
3

Thanks Chris for your response.
Iā€™ve checked this already and Now() works only for an update/modification, but not in case for the initial creation. Iā€™m sure I am missing something in addition.

4

My fault, Iā€™ve missed the difference between initial value and formula - it works!
Thanks for the hint

1 Like
5

Youā€™re welcome Markus!!

There are a lot of ā€˜nuancedā€™ tricks and things that are super easy to forget as you move around.

Good luck!