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.
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.
