Special Values
When a user Adds or Edits an item or submits a Form, Glide can submit additional data about their submission, like the date and time of the user’s submission or the user’s email address. These are called Special Values.
If we add the Current Date/Time special value, we don’t see anything in the app but we do see the value listed on the right under the Columns section.
We can then choose which column we want the date and time submitted to or create one for it and bind the Date Time value to that column. Now when a user submits data — whether through editing a list item or adding a new list item — our new column will be populated by the date and time that that user submitted the information.
Glide will always be able to work out what time and date it is for the user's device, but Glide will only have access to the user's email if you have set your app's sign in to be Public with Email or Allowed Email List (or if they’ve already been prompted to sign in by another action like Favorite). Otherwise, it will just stay empty. It won't prompt the user to sign in.
Two things to note about Special Values:
If another user edits that item again, then the Special Value column data will be overwritten, so you will only ever see the last edited special values.
Special values only work the add or edit screen. If you haven’t enabled editing or adding items and a user changes an editable component, Glide won’t be able to populate your sheet with the date & time or the user’s email.
Special values and column values are both relevant to the use of Forms, so make sure you understand both of them.
