--- title: "Field properties: QBL v0.11" slug: "field-properties-qbl-v011" updated: 2025-12-08T19:43:45Z published: 2026-01-11T05:00:01Z canonical: "help.quickbase.com/field-properties-qbl-v011" excludeFromSearch: true --- > ## Documentation Index > Fetch the complete documentation index at: https://help.quickbase.com/llms.txt > Use this file to discover all available pages before exploring further. # Field properties: QBL v0.11 > [!WARNING] > Important > > This version of QBL is no longer supported. Learn more about [QBL versions](https://help.quickbase.com/v1/docs/about-qbl-versions). This article contains information about QBL objects. QBL objects are the supported Quickbase schema elements you see textually represented in the YAML file generated by Quickbase when you [export a solution](https://developer.quickbase.com/operation/exportSolution). Each object has associated properties. The following tables list information about the properties of each object. See general information about [fields as QBL objects](/v1/docs/quickbase-fields-as-qbl-objects). ## Address fields In Quickbase, address fields include 6 subfields. Each subfield is also listed in this section. ### Address properties | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | Format | True | | One of: International, United States | | InputWidth | False | 60 | Any integer | | DefaultMapType | False | Road | One of: Road, Satellite, Hybrid, Terrain | | Street1 | True | | [Street1](/v1/docs/field-properties-qbl-v011#street1-properties) | | Street2 | True | | [Street2](/v1/docs/field-properties-qbl-v011#street2-properties) | | City | True | | [City](/v1/docs/field-properties-qbl-v011#city-properties) | | State | True | | [State](/v1/docs/field-properties-qbl-v011#state-properties) | | PostalCode | True | | [PostalCode](/v1/docs/field-properties-qbl-v011#postal-code-properties) | | Country | True | | [Country](/v1/docs/field-properties-qbl-v011#country-properties) | | Label | True | | Any string | | IsBold | False | False | true or false | | DisplayWithoutWrapping | False | False | true or false | | HelpText | False | "" | Any string | | IsSearchable | False | False | true or false | | AllowedInReports | False | True | true or false | | AddToAllNewReports | False | False | true or false | | RolePermissions | False | | | ### Street1 properties This QBL object does not have any properties. ### Street2 properties This QBL object does not have any properties. ### City properties This QBL object does not have any properties. ### State properties | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | Options | False | Default | Array of items of type: Any string Any string | ### Postal Code properties This QBL object does not have any properties. ### Country properties | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | Options | False | Default | Array of items of type: Any string Any string | ## Checkbox fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | Label | True | - | Any string | | IsRequired | False | False | true or false | | AllowDataCopy | False | True | true or false | | IsBold | False | False | true or false | | DisplayWithoutWrapping | False | False | true or false | | HelpText | False | "" | Any string | | IsSearchable | False | False | true or false | | AllowedInReports | False | True | true or false | | AddToAllNewReports | False | False | true or false | | SnapshotSourceLookupField | True | - | Reference to Field | | SharedWith | False | [] | Array of items of type: Any string | | RolePermissions | False | - | | | DefaultValue | False | Unchecked | One of: Unchecked, Checked | | ShowAsCheckmark | False | True | true or false | | DoesTotal | False | False | true or false | ## Currency fields | Property | Description | Required | Default | Allowed Values | | --- | --- | --- | --- | --- | | IsAuditable | | False | False | true or false | | InputOptions | - | False | - | - | | InputType | | False | UserInput | One of: UserInput, FromList | | ListChoices | | True | - | Array of items of type: Any string | | AllowCreateChoices | | False | False | true or false | | IsUnique | | False | False | true or false | | Label | | True | - | Any string | | IsRequired | | False | False | true or false | | AllowDataCopy | | False | True | true or false | | IsBold | | False | False | true or false | | DisplayWithoutWrapping | | False | False | true or false | | HelpText | | False | "" | Any string | | IsSearchable | | False | False | true or false | | AllowedInReports | | False | True | true or false | | AddToAllNewReports | | False | False | true or false | | SnapshotSourceLookupField | | True | - | Reference to Field | | SharedWith | | False | [] | Array of items of type: Any string | | RolePermissions | | False | - | | | Units | | False | "" | Any string | | Width | | False | 10 | Any integer | | DoesTotal | | False | True | true or false | | DoesAverage | | False | False | true or false | | TreatBlankAsZero | | False | True | true or false | | DefaultValue | | False | "" | One of: "", Any string | | DecimalPlaces | Leave blank for floating point | False | 2 | One of: FloatingPoint, "", Any integer | | DefaultSortOrder | | False | Ascending | One of: Ascending, Descending | | SeparatorStart | | False | 3 | One of: 3, 4 | | OverrideSubFieldAccess | | False | False | true or false | | NumberFormat | | False | - | - | | SeparatorStyle | Whether to use a comma or dot/period as the decimals separator e.g. 766.12 vs 766,12. The other will automatically be used for separating integer digit groupings, if grouped integers are chosen (see SeparatorPlaces). | False | CommaGroupingPeriodDecimal | One of: CommaGroupingPeriodDecimal, PeriodGroupingCommaDecimal | | SeparatorPlaces | | False | 3 | One of: none, 2, 3 | | CurrencySymbol | | False | $ | Any string | | CurrencySymbolPosition | | False | Between | One of: Before, Between, After | ## Date fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | IsUnique | False | False | true or false | | Label | True | - | Any string | | IsRequired | False | False | true or false | | AllowDataCopy | False | True | true or false | | IsBold | False | False | true or false | | DisplayWithoutWrapping | False | False | true or false | | HelpText | False | "" | Any string | | IsSearchable | False | False | true or false | | AllowedInReports | False | True | true or false | | AddToAllNewReports | False | False | true or false | | SnapshotSourceLookupField | True | - | Reference to Field | | SharedWith | False | [] | Array of items of type: Any string | | RolePermissions | False | - | | | ShowMonthAsAlpha | False | False | true or false | | HideCurrentYear | False | False | true or false | | ShowDayOfWeek | False | False | true or false | | DefaultIsToday | False | False | true or false | | DefaultSortOrder | False | Ascending | One of: Ascending, Descending | ## Date created fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | Label | False | Date Created | Any string | ## Date modified fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | Label | False | Date Modified | Any string | ## Date/time fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | IsUnique | False | False | true or false | | Label | True | | Any string | | IsRequired | False | False | true or false | | AllowDataCopy | False | True | true or false | | IsBold | False | False | true or false | | DisplayWithoutWrapping | False | False | true or false | | HelpText | False | "" | Any string | | IsSearchable | False | False | true or false | | AllowedInReports | False | True | true or false | | AddToAllNewReports | False | False | true or false | | SnapshotSourceLookupField | True | | Reference to Field | | SharedWith | False | [] | Array of items of type: Any string | | RolePermissions | False | | | | ShowMonthAsAlpha | False | False | true or false | | HideCurrentYear | False | False | true or false | | ShowDayOfWeek | False | False | true or false | | ShowTimeZone | False | False | true or false | | ShowTime | False | True | true or false | | DefaultIsNow | False | False | true or false | | DefaultSortOrder | False | Ascending | One of: Ascending, Descending | ## Duration fields | Property | Description | Required | Default | Allowed Values | | --- | --- | --- | --- | --- | | IsAuditable | | False | False | true or false | | Label | | True | | Any string | | IsRequired | | False | False | true or false | | AllowDataCopy | | False | True | true or false | | IsBold | | False | False | true or false | | DisplayWithoutWrapping | | False | False | true or false | | HelpText | | False | "" | Any string | | IsSearchable | | False | False | true or false | | AllowedInReports | | False | True | true or false | | AddToAllNewReports | | False | False | true or false | | SnapshotSourceLookupField | | True | | Reference to Field | | SharedWith | | False | [] | Array of items of type: Any string | | RolePermissions | | False | | | | TreatBlankAsZero | Treat blank as zero in calculations | False | True | true or false | | DoesTotal | Display a total of this field in reports | False | False | true or false | | DoesAverage | Display an average of this field in reports | False | True | true or false | | DefaultValue | | False | "" | Any string | | DecimalPlaces | Leave blank for floating point | False | FloatingPoint | One of: FloatingPoint, "" Any integer | | DisplayUnits | | False | Smart Units | One of: HH::MM, HH:MM:SS, :MM, :MM:SS, Smart Units, Weeks, Days, Hours, Minutes, Seconds | | AddFieldToAllNewReports | Add this field to all new reports | False | True | true or false | ## Email fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | IsUnique | False | False | true or false | | Label | True | | Any string | | IsRequired | False | False | true or false | | AllowDataCopy | False | True | true or false | | Comments | False | "" | Any string | | IsBold | False | False | true or false | | DisplayWithoutWrapping | False | False | true or false | | HelpText | False | "" | Any string | | IsSearchable | False | False | true or false | | AllowedInReports | False | True | true or false | | AddToAllNewReports | False | False | true or false | | SnapshotSourceLookupField | True | | Reference to QB::Field::Lookup | | SharedWith | False | [] | Any string | | RolePermissions | False | | | | DefaultValue | False | "" | Any string | | DefaultDomain | False | "" | Any string | | SortByDomain | False | False | true or false | | EnableEmailAll | False | False | true or false | | LinkText | False | "" | Any string | | DisplayAs | False | FullEmailAddress | One of: FullEmailAddress, OmitDomain, OmitAfterUnderscore | ## File attachment fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | RevisionsToKeep | False | 3 | Any string | | AllowPromoteVersion | False | True | true or false | | UseNewBrowserWindow | False | True | true or false | | AllowOpenAccess | False | False | true or false | | LinkText | False | "" | Any string | | ShowAsImages | False | True | true or false | | Label | True | | Any string | | IsRequired | False | False | true or false | | IsBold | False | False | true or false | | DisplayWithoutWrapping | False | False | true or false | | HelpText | False | "" | Any string | | IsSearchable | False | False | true or false | | AllowedInReports | False | True | true or false | | AddToAllNewReports | False | False | true or false | | SharedWith | False | [] | Array of items of type: Any string | | RolePermissions | False | | | ## Last modified by fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | Label | False | Last Modified By | Any string | ## List user fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | Label | True | | Any string | | IsRequired | False | False | true or false | | AllowDataCopy | False | True | true or false | | IsBold | False | False | true or false | | DisplayWithoutWrapping | False | False | true or false | | HelpText | False | "" | Any string | | IsSearchable | False | False | true or false | | AllowedInReports | False | True | true or false | | AddToAllNewReports | False | False | true or false | | SnapshotSourceLookupField | True | | Reference to Field | | SharedWith | False | [] | Array of items of type: Any string | | RolePermissions | False | | | | *Choices | False | | - | | UserSet | False | Default | One of: Default Array of items of type: Any string | | AllowCreateChoices | False | False | true or false | | AllowInviteExternalUser | False | False | true or false | | DefaultValue | False | "" | One of: CurrentUser | *If you have "from list" and the list contains users that are not registered in the realm you are creating/updating, the unregistered users will disappear from the list of choices. ## Lookup fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | Lookup | False | | | | Relationship | True | | Reference to [QBL: Relationships - child](/v1/docs/relationship-properties-qbl-v011#child-relationships) | | TargetField | True | | Reference to Field | | TargetFieldType | True | | Any string | | OverrideSubFieldAccess | False | False | true or false | | DisplayAsLinkToParent | False | False | true or false | ## Multi-select text fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | InputOptions | False | | | | InputType | False | FromList | One of: UserInput, FromList | | ListChoices | True | | Array of items of type: Any string | | AllowCreateChoices | False | True | true or false | | ChoiceOrder | False | AsEntered | One of: AsEntered, Alphabetical | | Label | True | | Any string | | IsRequired | False | False | true or false | | AllowDataCopy | False | True | true or false | | IsBold | False | False | true or false | | DisplayWithoutWrapping | False | False | true or false | | HelpText | False | "" | Any string | | IsSearchable | False | False | true or false | | AllowedInReports | False | True | true or false | | AddToAllNewReports | False | False | true or false | | SnapshotSourceLookupField | True | | Reference to Field | | SharedWith | False | [] | Array of items of type: Any string | | RolePermissions | False | | | | DefaultValue | False | "" | Any string | ## Number fields | Property | Description | Required | Default | Allowed Values | | --- | --- | --- | --- | --- | | IsAuditable | | False | False | true or false | | InputOptions | | False | | | | InputType | | False | UserInput | One of: UserInput, FromList | | ListChoices | | True | | Array of items of type: Any string | | AllowCreateChoices | | False | False | true or false | | IsUnique | | False | False | true or false | | Label | | True | | Any string | | IsRequired | | False | False | true or false | | AllowDataCopy | | False | True | true or false | | IsBold | | False | False | true or false | | DisplayWithoutWrapping | | False | False | true or false | | HelpText | | False | "" | Any string | | IsSearchable | | False | False | true or false | | AllowedInReports | | False | True | true or false | | AddToAllNewReports | | False | False | true or false | | SnapshotSourceLookupField | | True | | Reference to Field | | SharedWith | | False | [] | Array of items of type: Any string | | RolePermissions | | False | | | | Units | | False | "" | Any string | | Width | | False | 10 | Any integer | | DoesTotal | | False | True | true or false | | DoesAverage | | False | False | true or false | | TreatBlankAsZero | | False | True | true or false | | DefaultValue | | False | "" | One of: "" Any string | | DecimalPlaces | Leave blank for floating point | False | FloatingPoint | One of: FloatingPoint, "" Any integer | | DefaultSortOrder | | False | Ascending | One of: Ascending, Descending | | SeparatorStart | | False | 4 | One of: 3, 4 | | OverrideSubFieldAccess | | False | False | true or false | | NumberFormat | | False | | | | SeparatorStyle | Whether to use a comma or dot/period as the decimals separator e.g. 766.12 vs 766,12. The other will automatically be used for separating integer digit groupings, if grouped integers are chosen (see SeparatorPlaces). | False | CommaGroupingPeriodDecimal | One of: CommaGroupingPeriodDecimal, PeriodGroupingCommaDecimal | | SeparatorPlaces | | False | 3 | One of: none, 2, 3 | ## Percent fields | Property | Description | Required | Default | Allowed Values | | --- | --- | --- | --- | --- | | IsAuditable | | False | False | true or false | | InputOptions | | True | | | | InputType | | True | | One of: UserInput, FromList | | ListChoices | | True | | Array of items of type: Any string | | AllowCreateChoices | | False | False | true or false | | IsUnique | | False | False | true or false | | Label | | True | | Any string | | IsRequired | | False | False | true or false | | AllowDataCopy | | False | True | true or false | | Comments | | False | "" | Any string | | IsBold | | False | False | true or false | | DisplayWithoutWrapping | | False | False | true or false | | HelpText | | False | "" | Any string | | IsSearchable | | False | False | true or false | | AllowedInReports | | False | True | true or false | | AddToAllNewReports | | False | False | true or false | | SnapshotSourceLookupField | | True | | Reference to QB::Field::Lookup | | SharedWith | | False | [] | Array of items of type: Any string | | RolePermissions | | False | | | | Units | | False | "" | Any string | | Width | | False | 10 | Any integer | | DoesTotal | | False | True | true or false | | DoesAverage | | False | False | true or false | | TreatBlankAsZero | | False | True | true or false | | DefaultValue | | False | "" | One of: "" Any string | | DecimalPlaces | Leave blank for floating point | False | FloatingPoint | One of: FloatingPoint, "" Any integer | | DefaultSortOrder | | False | Ascending | One of: Ascending, Descending | | SeparatorStart | | False | 4 | One of: 3, 4 | | OverrideSubFieldAccess | | False | False | true or false | | NumberFormat | | False | | | | SeparatorStyle | Whether to use a comma or dot/period as the decimals separator e.g. 766.12 vs 766,12. The other will automatically be used for separating integer digit groupings, if grouped integers are chosen (see SeparatorPlaces). | False | CommaGroupingPeriodDecimal | One of: CommaGroupingPeriodDecimal, PeriodGroupingCommaDecimal | | SeparatorPlaces | | False | 3 | One of: none, 2, 3 | ## Phone number fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | Label | True | | Any string | | IsRequired | False | False | true or false | | AllowDataCopy | False | True | true or false | | IsBold | False | False | true or false | | DisplayWithoutWrapping | False | False | true or false | | HelpText | False | "" | Any string | | IsSearchable | False | False | true or false | | AllowedInReports | False | True | true or false | | AddToAllNewReports | False | False | true or false | | SnapshotSourceLookupField | True | | Reference to Field | | SharedWith | False | [] | Array of items of type: Any string | | RolePermissions | False | | | | DefaultValue | False | "" | Any string | | HasExtension | False | True | true or false | | IsInternational | False | False | true or false | | DefaultCountry | False | US | One of: AF, AL, DZ, AS, AD, AO, AI, AG, AR, AM, AW, AC, AU, AT, AZ, BS, BH, BD, BB, BY, BE, BZ, BJ, BM, BT, BO, BA, BW, BR, IO, VG, BN, BG, BF, BI, KH, CM, CA, CV, BQ, KY, CF, TD, CL, CN, CX, CC, CO, KM, CD, CG, CK, CR, CI, HR, CU, CW, CY, CZ, DK, DJ, DM, DO, EC, EG, SV, GQ, ER, EE, SZ, ET, FK, FO, FJ, FI, FR, GF, PF, GA, GM, GE, DE, GH, GI, GR, GL, GD, GP, GU, GT, GG, GN, GW, GY, HT, HN, HK, HU, IS, IN, ID, IR, IQ, IE, IM, IL, IT, JM, JP, JE, JO, KZ, KE, KI, XK, KW, KG, LA, LV, LB, LS, LR, LY, LI, LT, LU, MO, MK, MG, MW, MY, MV, ML, MT, MH, MQ, MR, MU, YT, MX, FM, MD, MC, MN, ME, MS, MA, MZ, MM, NA, NR, NP, NL, NC, NZ, NI, NE, NG, NU, NF, KP, MP, NO, OM, PK, PW, PS, PA, PG, PY, PE, PH, PL, PT, PR, QA, RE, RO, RU, RW, BL, SH, KN, LC, MF, PM, VC, WS, SM, ST, SA, SN, RS, SC, SL, SG, SX, SK, SI, SB, SO, ZA, KR, SS, ES, LK, SD, SR, SJ, SE, CH, SY, TW, TJ, TZ, TH, TL, TG, TK, TO, TT, TN, TR, TM, TC, TV, VI, UG, UA, AE, GB, US, UY, UZ, VU, VA, VE, VN, WF, EH, YE, ZM, ZW, AX | ## Predecessor fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | Label | True | | Any string | | IsRequired | False | False | true or false | | AllowDataCopy | False | True | true or false | | IsBold | False | False | true or false | | DisplayWithoutWrapping | False | False | true or false | | HelpText | False | "" | Any string | | IsSearchable | False | False | true or false | | AllowedInReports | False | True | true or false | | AddToAllNewReports | False | False | true or false | | SnapshotSourceLookupField | True | | Reference to Field | | SharedWith | False | [] | Array of items of type: Any string | | RolePermissions | False | | | | DefaultValue | False | "" | Any string | | StartDate | False | Default | One of: Default, Reference to [QBL: Work date fields](/v1/docs/field-properties-qbl-v011#work-date-fields) | | EndDate | False | Default | One of: Default, Reference to [QBL: Work date fields](/v1/docs/field-properties-qbl-v011#work-date-fields) or [QBL: Work date - formula fields](/v1/docs/formula-field-properties-qbl-v011#work-date-formula-fields) | ## Rating fields | Property | Description | Required | Default | Allowed Values | | --- | --- | --- | --- | --- | | IsAuditable | | False | False | true or false | | InputOptions | | True | | | | InputType | | True | | One of: UserInput, FromList | | ListChoices | | True | | Array of items of type: Any string | | AllowCreateChoices | | False | False | true or false | | IsUnique | | False | False | true or false | | Label | | True | | Any string | | IsRequired | | False | False | true or false | | AllowDataCopy | | False | True | true or false | | IsBold | | False | False | true or false | | DisplayWithoutWrapping | | False | True | true or false | | HelpText | | False | "" | Any string | | IsSearchable | | False | False | true or false | | AllowedInReports | | False | True | true or false | | AddToAllNewReports | | False | True | true or false | | SnapshotSourceLookupField | | True | | Reference to Field | | SharedWith | | False | [] | Array of items of type: Any string | | RolePermissions | | False | | | | Units | | False | "" | Any string | | Width | | False | 10 | Any integer | | DoesTotal | | False | False | true or false | | DoesAverage | | False | True | true or false | | TreatBlankAsZero | | False | False | true or false | | DefaultValue | | False | "" | Any string | | DecimalPlaces | Leave blank for floating point | False | 1 | One of: FloatingPoint, "" or Any integer | | DefaultSortOrder | | False | Ascending | One of: Ascending, Descending | | SeparatorStart | | False | 4 | One of: 3, 4 | | OverrideSubFieldAccess | | False | False | true or false | | NumberFormat | | False | | | | SeparatorStyle | Whether to use a comma or dot/period as the decimals separator e.g. 766.12 vs 766,12. The other will automatically be used for separating integer digit groupings, if grouped integers are chosen (see SeparatorPlaces). | False | CommaGroupingPeriodDecimal | One of: CommaGroupingPeriodDecimal, PeriodGroupingCommaDecimal | | SeparatorPlaces | | False | 3 | One of: none, 2, 3 | ## Record ID fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | Label | False | Record ID# | Any string | ## Record owner fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | Label | False | Record Owner | Any string | ## Reference fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | Reference | False | | | | Relationship | True | | Reference to QB::Relationship::Child | | Proxy | True | | Reference to Field | | DisplayType | True | | Any string | | ConditionalValues | True | | | | FilterField | True | | Reference to Field | | MatchField | True | | Reference to Field | | DisplayAsLinkToParent | False | False | true or false | | UseRecordPickerForGridEdit | False | False | true or false | ## Reference proxy fields This QBL object does not have any properties. ## Report link fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | FieldRelationship | False | | | | Source | False | Default | One of: Default, Reference to Field | | Target | False | Default | One of: Default, Unsupported, Reference to Field or Field | | MatchValuesExactly | False | True | true or false | | UseNewWindow | False | False | true or false | | LinkText | False | "" | Any string | | Label | True | | Any string | | AllowedInReports | False | True | true or false | | AddToAllNewReports | False | False | true or false | | IsSearchable | False | False | true or false | | IsBold | False | False | true or false | | DisplayWithoutWrapping | False | False | true or false | | HelpText | False | "" | Any string | | SharedWith | False | [] | Array of items of type: Any string | | RolePermissions | False | | | ## Rich text fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | IsUnique | False | False | true or false | | Label | True | | Any string | | IsRequired | False | False | true or false | | AllowDataCopy | False | True | true or false | | IsBold | False | False | true or false | | DisplayWithoutWrapping | False | False | true or false | | HelpText | False | "" | Any string | | IsSearchable | False | False | true or false | | AllowedInReports | False | True | true or false | | AddToAllNewReports | False | False | true or false | | SnapshotSourceLookupField | True | | Reference to Field | | SharedWith | False | [] | Array of items of type: Any string | | RolePermissions | False | | | | MaxLength | False | 0 | Any integer | | DefaultValue | False | "" | Any string | | EditHistory | False | | | | Enable | False | False | true or false | | ExpandedHistory | False | False | true or false | | PrependHistory | False | False | true or false | | UseFullName | False | True | true or false | | IncludeTime | False | False | true or false | | IncludeTimeZone | False | False | true or false | | Width | False | 40 | Any integer | | Height | False | 6 | Any integer | | AllowMentions | False | False | true or false | ## Summary fields | Property | Description | Required | Default | Allowed Values | | --- | --- | --- | --- | --- | | Summary | | False | | | | ReferenceField | The foreign key field in the child table that establishes the table to table relationship. | True | | Reference to QB::Field::Reference | | FieldToSummarize | | True | | Reference to Field | | DisplayType | | True | | Any string | | Function | | True | | One of: Count, Total, Average, Maximum, Minimum, StdDeviation, CombinedText, DistinctCount, AnyRelatedRecords | | DrillDownReport | | False | None | One of: Default, None Any integer | | Query | | False | "" | Any string | | DisplayAsLinkToChildren | | False | False | true or false | | OverrideSubFieldAccess | | False | False | true or false | | EvaluateOnlyOnChange | | False | False | true or false | Note: The field caching property is not supported ## Text fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | IsUnique | False | False | true or false | | InputOptions | True | - | Nested Property | | InputType | True | - | One of: UserInput | | ListChoices | True | - | Array of items of type: Any string | | AllowCreateChoices | False | True | true or false | | ChoiceOrder | False | AsEntered | One of: AsEntered, Alphabetical | | Label | True | - | Any string | | IsRequired | False | False | true or false | | AllowDataCopy | False | True | true or false | | IsBold | False | False | true or false | | DisplayWithoutWrapping | False | False | true or false | | HelpText | False | "" | Any string | | IsSearchable | False | False | true or false | | AllowedInReports | False | True | true or false | | AddToAllNewReports | False | False | true or false | | SnapshotSourceLookupField | True | Reference to Field | Reference to Field | | SharedWith | False | [] | Array of items of type: Any string | | RolePermissions | False | | | | MaxLength | False | 0 | Any integer | | DefaultValue | False | "" | Any string | | EditHistory | False | | | | Enable | False | False | true or false | | ExpandedHistory | False | False | true or false | | PrependHistory | False | False | true or false | | UseFullName | False | True | true or false | | IncludeTime | False | False | true or false | | IncludeTimeZone | False | False | true or false | | Width | False | 40 | Any integer | ## Text - multi-line fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | InputOptions | True | | | | InputType | True | One of: UserInput, FromList | | | ListChoices | True | Array of items of type: Any string | | | AllowCreateChoices | False | False | true or false | | ChoiceOrder | False | AsEntered | One of: AsEntered, Alphabetical | | Label | True | Any string | | | IsRequired | False | False | true or false | | AllowDataCopy | False | True | true or false | | IsBold | False | False | true or false | | DisplayWithoutWrapping | False | False | true or false | | HelpText | False | "" | Any string | | IsSearchable | False | False | true or false | | AllowedInReports | False | True | true or false | | AddToAllNewReports | False | False | true or false | | SnapshotSourceLookupField | True | Reference to Field | | | SharedWith | False | [] | Array of items of type: Any string | | RolePermissions | False | Documentation coming soon | | | MaxLength | False | 0 | Any integer | | DefaultValue | False | "" | Any string | | EditHistory | False | | | | Enable | False | False | true or false | | ExpandedHistory | False | False | true or false | | PrependHistory | False | False | true or false | | UseFullName | False | True | true or false | | IncludeTime | False | False | true or false | | IncludeTimeZone | False | False | true or false | | Height | False | 6 | Any integer | | Width | False | 40 | Any integer | ## Text - multiple choice fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | IsUnique | False | False | true or false | | InputOptions | True | | | | InputType | True | One of: UserInput, FromList | | | ListChoices | True | Array of items of type: Any string | | | AllowCreateChoices | False | True | true or false | | ChoiceOrder | False | AsEntered | One of: AsEntered, Alphabetical | | Label | True | Any string | | | IsRequired | False | False | true or false | | AllowDataCopy | False | True | true or false | | IsBold | False | False | true or false | | DisplayWithoutWrapping | False | False | true or false | | HelpText | False | "" | Any string | | IsSearchable | False | False | true or false | | AllowedInReports | False | True | true or false | | AddToAllNewReports | False | False | true or false | | SnapshotSourceLookupField | True | Reference to Field | | | SharedWith | False | [] | Array of items of type: Any string | | RolePermissions | False | | | | MaxLength | False | 0 | Any integer | | DefaultValue | False | "" | Any string | | EditHistory | False | | | | Enable | False | False | true or false | | ExpandedHistory | False | False | true or false | | PrependHistory | False | False | true or false | | UseFullName | False | True | true or false | | IncludeTime | False | False | true or false | | IncludeTimeZone | False | False | true or false | ## Time of day fields | Property | Description | Required | Default | Allowed Values | | --- | --- | --- | --- | --- | | IsAuditable | | False | False | true or false | | IsUnique | | False | False | true or false | | Label | | True | | Any string | | IsRequired | | False | False | true or false | | AllowDataCopy | | False | True | true or false | | IsBold | | False | False | true or false | | DisplayWithoutWrapping | | False | False | true or false | | HelpText | | False | "" | Any string | | IsSearchable | | False | False | true or false | | AllowedInReports | | False | True | true or false | | AddToAllNewReports | | False | False | true or false | | SnapshotSourceLookupField | | True | | Reference to Field | | SharedWith | | False | [] | Array of items of type: Any string | | RolePermissions | | False | | | | DefaultValue | | False | "" | Any string | | DisplayAs | | False | HH:MM | One of: HH:MM, HH:MM:SS | | Use24HourClock | | False | False | true or false | | ShowTimeZone | | False | False | true or false | | DecimalPlaces | Leave blank for floating point | False | FloatingPoint | One of: FloatingPoint, "" Any integer | ## URL fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | IsUnique | False | False | true or false | | Label | True | | Any string | | IsRequired | False | False | true or false | | AllowDataCopy | False | True | true or false | | IsBold | False | False | true or false | | DisplayWithoutWrapping | False | False | true or false | | HelpText | False | "" | Any string | | IsSearchable | False | False | true or false | | AllowedInReports | False | True | true or false | | AddToAllNewReports | False | False | true or false | | SnapshotSourceLookupField | True | | Reference to Field | | SharedWith | False | [] | Array of items of type: Any string | | RolePermissions | False | | | | LinkText | False | "" | Any string | | DefaultValue | False | "" | Any string | | Abbreviate | False | False | true or false | | DisplayAsButton | False | False | true or false | | ButtonColor | False | default | Any string | | EmbedAsIframe | False | False | true or false | | IframeWidth | False | default | One of: default Any integer | | IframeHeight | False | default | One of: default Any integer | | Target | False | SamePage | One of: SamePage, NewWindow, Popup | ## User fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | IsUnique | False | False | true or false | | Label | True | N/A | Any string | | IsRequired | False | False | true or false | | AllowDataCopy | False | True | true or false | | IsBold | False | False | true or false | | DisplayWithoutWrapping | False | True | true or false | | HelpText | False | "" | Any string | | IsSearchable | False | False | true or false | | AllowedInReports | False | True | true or false | | AddToAllNewReports | False | False | true or false | | SnapshotSourceLookupField | True | N/A | Reference to Field | | SharedWith | False | [] | Array of items of type: Any string | | RolePermissions | False | | | | *Choices | False | | | | UserSet | False | Default | One of: Default Array of items of type: Any string | | AllowCreateChoices | False | False | true or false | | AllowInviteExternalUser | False | False | true or false | | DefaultValue | False | "" | Any string | | DisplayAs | False | FirstNameLastName | One of: FirstNameLastName, LastNameFirstName, UserName | *If you have "from list" and the list contains users that are not registered in the realm you are creating/updating, the unregistered users will disappear from the list of choices. ## Work date fields | Property | Required | Default | Allowed Values | | --- | --- | --- | --- | | IsAuditable | False | False | true or false | | IsUnique | False | False | true or false | | Label | True | N/A | Any string | | IsRequired | False | False | true or false | | AllowDataCopy | False | True | true or false | | IsBold | False | False | true or false | | DisplayWithoutWrapping | False | False | true or false | | HelpText | False | "" | Any string | | IsSearchable | False | False | true or false | | AllowedInReports | False | True | true or false | | AddToAllNewReports | False | False | true or false | | SnapshotSourceLookupField | True | N/A | Reference to Field | | SharedWith | False | [] | Array of items of type: Any string | | RolePermissions | False | | | | ShowMonthAsAlpha | False | False | true or false | | HideCurrentYear | False | False | true or false | | ShowDayOfWeek | False | False | true or false | | DefaultIsToday | False | False | true or false | | DefaultSortOrder | False | Ascending | One of: Ascending, Descending | ## Unsupported fields QB::Field::Unsupported is a placeholder used to represent Fields in an Application that are not supported in the exported QBL version. An example of this is the [vCard field](/v1/docs/setting-up-a-vcard-field). Unsupported fields will be ignored during Create and Update API actions. If you are updating an application with Unsupported fields (like vCard) and don't have a QB::Field::Unsupported for that field's ID in the template being published, the field will be deleted from the target application. | Property | Description | Required | Default | Allowed Values | | --- | --- | --- | --- | --- | | Label | Label of the unsupported Field when it was exported. This property is ignored during Create and Update actions. | True | N/A | Any string | | Explanation | Unsupported Fields might be exported with an explanation of why it's unsupported when possible. This property is ignored during Create and Update actions. | False | "" | Any string |