Formula - checkbox field properties
The properties for this field type are:
Enter a name for this field. This name displays on data-entry forms and as column headings in reports.
Click Change Type to change the field type.
Some field types (List-User, Multi-select Text, and File Attachment, for example) may not be changed. The Change Type link will not be present if this is the case.
Select Show a "totals" row in reports to count the number of yes values in this field and display the result at the bottom of any reports that feature this field.
Enter the formula to generate the value this field shows. When you click the Formula text field, a Fields & Functions list appears.
Click Select a Function to open the Quickbase Formula Functions dialog box.
Select or search for the type of function you want from the list.
Click the formula that you want, then click Insert.
Select Show value as Yes or No in reports to display checkmarks () for all yes values (checkboxes selected). If you clear the Show value as Yes or No in reports, the word yes displays for selected checkboxes and the word no appears for empty (cleared or unselected) checkboxes.
These properties apply when the field appears in table and timeline reports.
Select one or more options...
Display in bold
Display the data in bold.
Display without wrapping
Prevent the data from being broken into multiple lines.
To set the permissions:
Click Restrict access by role to limit access to the data in this field.
When selected, the Role and Permission list appears.
Select either None, View, or Modify for each role.
Note: This property is not available to accounts on the Quickbase Essential plan.
Override sub-field access
Set to use the access permissions specified above in Permissions, even if the permissions are less restrictive than those of the sub-fields, which are the fields used to calculate this field's value.
Select to allow the field to be included when searching or filtering the table.
To use this field in reports:
Select Add this field to all new reports to display this field as a column when users create but don't customize reports.
When selected, automatically selects The field may be used in reports option.
Select The field may be used in reports to use this field in reports.
If you want the field to be a default column, you must select this option.
To make entries in this field available as choices in another field:
Select Values from this field may be a source for dropdown lists in other apps, then click Add App.
Select an application, then click OK.
Field help text
If you want to provide help text in association with this field, enter it in the text box. This text will display via the information () icon next to the field.
Did this page help?
© 1999-2022 Quickbase, Inc. All rights reserved. Legal Notices.