Automatic Time Stamp

[LAl]

Every time a user enters a new form entry I need a date/time stamp to automatically log. Any way to do this like in google forms?  

[James_Burns · Accepted solution]

Add a field for the timestamp and set the initial value to NOW().

[James_Burns · Accepted solution]

Add a field for the timestamp and set the initial value to NOW().

[LAl]

Would I add this as a virtual column? or would it make more sense to add an additional column to the source table? 

[Tommy62 · Accepted solution]

Empfehle dies als erste Spalte in der Quelltabelle.

[LAl]

Right, so when the user makes an entry in the app the NOW() function will auto stamp correct?

[James_Burns]

You can't use a virtual column as that will not retain the value over time. So you would have to add it as a field in the source data. When a row is added to the table the NOW() setting as the initial value will capture the timestamp.