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
.
You can add special values to three types of screens on your app: a form, an edit screen or an add screen. There are three type of special values available on Glide:
Each of these special values can be added to your app to gather additional data about a submission. However, they won't be displayed in your screen.
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.
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.