Data Types

The following table lists the data types used in the SimplyWork platform.

Type	Example	Description
Integer	1, 17, 5678	Whole numbers with no fractional component
Float	1.23, 10.50, 100.00	Decimal numbers with a fractional component
Boolean	1 (true), 0 (false)	True or False; at a lower level the true/false are stored as 1/0
List	First item Second item Third item	A list of string/text values
Date	2022-03-28	A date (formatting available using Masks)
Time	14:02	A time (formatting available using Masks)
Datetime	2022-03-28 14:02	A date and time combined
String	The name of something	Text, generally of any length
Lookup	-> Department	Link to a row in another table
Child	[{..}, {..}, ..]	Used with tables and forms to create child stores, where by a row/entry in the child store is then composed of a list of field with any of the above field types
Child Item	{..}	An embedded record within a parent record, such as address or geo
Text	Memo..	A longer version of String, usually a note or memo format
Color	component	Color field with an associated selector
Signature	component	Component to capture signatures from a user
Address	132 W Wisonsin Ave, Neenah, WI 54956	Child component that accepts an address and geocodes into its components
Image	component	Container to hold uploaded images
Timestamp	2023-11-07 07:45:12	Read-only field that captures the current system time
Author	Mick Mouse	Read-only field that captures the current user
Location	{..} lat lng Number Street City State State Country Zipcode FullAddress	Read-only Child Item field that captures the current geo information of the user (generally only available on mobile devices)
Comment	[{..}, {..}, ..] Time Employee Comment	Pre-built Child field containing a list of comment entries
Rich Text	Memo..with Style	Like a Text field but with formatting, color and other document features
Event	{..} Title AllDay StartTime StopTime Description	Child field containing the attributes necessary for calendar-type apps