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?
Solved! Go to Solution.
Add a field for the timestamp and set the initial value to NOW().
Empfehle dies als erste Spalte in der Quelltabelle.
Add a field for the timestamp and set the initial value to NOW().
Would I add this as a virtual column? or would it make more sense to add an additional column to the source table?
Empfehle dies als erste Spalte in der Quelltabelle.
Right, so when the user makes an entry in the app the NOW() function will auto stamp correct?
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.
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |