Differences

This shows you the differences between two versions of the page.

Link to this comparison view

field type - time [2016/09/14 14:19] (current)
Line 1: Line 1:
 +====== Time ======
 +The time field stores a time.  Internally, the stored value for is time field the number of seconds elapsed from 12:00 AM UTC to the stored time. In the interface, this time appears in 12-hour format. ​  The display of this field is affected by [[Timezone and Locale|Timezone and Locale]] settings.
  
 +
 +===== How to Create =====
 +  - Click the {{:​presentation-layer:​field-plus.png|}} to add a field in your [[Form|form]].
 +  - Choose "New Field"
 +  - Select the table you wish to add the field to. Most of the time, this will be the current [[Table|table]] you are on, called the current [[Context|context]].
 +  - Select a field name and click "​Choose Type".
 +  - Choose "​Time"​ from the list of field types.
 +  - You can continue adding fields or click the "​Select"​ button to finish adding.
 +
 +===== Features =====
 +Field features can be edited by clicking on the orange field icon {{:​time.png|}} when the [[Presentation Layer|presentation layer]] is displayed. ​
 +
 +==== Field Label ====
 +  * [[Field Setting - Field Label|Field Label]]
 +  * [[Field Setting - Display Alternate Label]] (affects this form only)
 +
 +==== Grid Appearance ====
 +
 +  * [[Field Setting - Column Span|Column Span]]
 +  * [[Field Setting - Row Span|Row Span]]
 +  ​
 +==== Tooltip ====
 +  * [[Field Setting - Tooltip|Tooltip]]
 +  * [[Field Setting - Descriptive Text|Descriptive Text]]
 +  * [[Field Setting - Display Alternate Descriptive Text|Display Alternate Descriptive Text]] (affects this form only)
 +  ​
 +==== Field Format ====
 +  * [[Application Setting - Time Format for all Date Time and Time Fields|Time Format for all Date Time and Time Fields]]
 +  * [[Field Setting - Specify a Time Format|Specify a Date Format]]
 +  * [[Field Setting - Specify Alternate Time Format|Specify Alternate Date Format]] (affects this form only)
 +
 +==== Block Association ====
 +  * [[Field Setting - Temporary Block Association|Temporary Block Association]]
 +  * [[Field Setting - Global Block Association|Global Block Association]]
 +
 +==== Default Value ====
 +  * [[Field Setting - Default Value|Default Value]]
 +
 +==== Regionalization ====
 +  * [[Field Setting - Regionalization|Regionalization]]
 + 
 +==== Validation ====
 +   * [[Field Setting - Required|Required]]
 +
 +==== Audit History ====
 +  * [[Field Setting - Audit This Field|Audit This Field]] ​
 +  * [[Field Setting - Show Audit History|Show Audit History]]
 +
 +==== View Only ====
 +  * [[Field Setting - View Only|View Only]]
 +
 +===== Field parts =====
 +The Time Field has three interface parts, but only one storage part.
 +
 +Interface Parts
 +
 +  * Hour
 +  * Minute
 +  * AM/PM
 +Storage Part
 +
 +  * Timestamp (Seconds from 12:00 AM UTC to the stored time)
 +  ​
 +===== Output formats =====
 +The time field has only one output format, which returns the full field (e.g. 12:34 PM)
 +
 +
 +===== Acceptable inputs =====
 +Though a Time is stored internally as a number, when interacting with the Field on a page, you must input a time.  Setting the hour and minute are done by typing a number into the hour and minute Field Parts. ​ There is no validation on these parts, though only two characters are allowed in each part.  Entering non-real times is allowed, though, and is handled by adjusting the time by however many hours or minutes exceed 24 or 60, respectively. ​ For example, if 45:75 AM is entered and saved into a Date and Time Field, it would adjust the value to 10:15 PM.  Selecting AM or PM is done by using the AM/PM drop-down.
 +
 +Setting With Actions
 +
 +When setting the Time Field through actions, two different input formats may be used.  As with other Field types, the stored value from another Time Field may be used to save into a Time Field. ​ Since the stored value for these Fields is a timestamp, any timestamp value may also be used to save into a Time Field (may be calculated from an expression or extracted from a Date & Time or Date Field).
 +
 +In addition to this, the text output of the Time Field (e.g. 4:23 AM) may also be used to save into the Time Field.  ​
 +
 +===== Filters =====
 +The time field cannot be filtered.
 +
 +===== Internationalization and Browser Settings =====
 +Date and Time settings should change automatically in non-US countries. For more information,​ read the [[Field Setting - Regionalization|Regionalization Field Settings]] page, or if you need to change your settings manually to simulate being in another country, [[Browser Settings - Date and Time|try out these settings]].
field type - time.txt ยท Last modified: 2016/09/14 14:19 (external edit)
Copyright WorkXpress, 2019