Have it your way! You can design data entry and display forms to suit your needs exactly. The Form Builder's Elements tab lets you add or remove form fields and set their order and layout. (To access the Form Builder, click the Customize this Form link in the Page bar when you're displaying a form.)
Whether you're creating or editing a form, the Elements tab usually displays with some of your fields already listed.
Each field name is actually a dropdown, which lets you change each field to a different one (though it's actually easier to move fields around, which you'll learn to do in a minute). At the bottom of the list of fields, are blank dropdown fields that all say Make a Selection....
To add a field, you can click one of these dropdowns and select the field you want to appear on your form (fields already on the form are grayed out in the list). However, it's unlikely that you want to add a field to the bottom of the form every time. There's an easier way. Select the field just below the spot where you want to insert the new field. (To select the field, click its icon. QuickBase highlights the field in yellow.) At the bottom of the list, click the Insert button. QuickBase inserts a Make a Selection... dropdown above the field you chose. Click the dropdown and select the field you want to add.
Tip: You don't need to be in the Form Builder to add a field. You can do so directly on the form itself! You can create a field and add it to your form at the same time. On the form itself, right-click the field above where you want to insert the new field. Within the menu that appears, select Add a field after this one.
In the Form Builder, select the field you want to remove, by clicking its icon. QuickBase highlights the selection in yellow. At the bottom of the list, click the Remove button.
Tip: You can also use the Remove this field from this form command on the right-click menu shown above.
Select the field you want to move, by clicking its icon.
At the bottom of the fields list, click the Up or Down arrow to move the field(s) you selected. QuickBase moves a field one slot at a time. Click the directional buttons as many times as you need. If you want a field to display on the same line as the field above it, turn on the Same Row checkbox to the right of the field name.
Note: The Same Row setting is not applicable for mobile QuickBase; each field appears on a separate row in the form when you are using the mobile site.
You can move multiple fields together as a group. To select several fields that are next to each other, hold down the Shift key and select all the fields you want to move. To select a group of fields that aren't located next to each other, hold down the Ctrl key and click each field you want to move. QuickBase highlights all the fields you select in yellow. Click the Up or Down button at the bottom of the list to move the fields.
When you select a field in the list, QuickBase displays some configuration options in the pane on the right.
All fields have the following options:
Use Alternate Label Text. Select this option if you want to create a custom label for the field. QuickBase automatically labels form fields with their field name. But if you turn on this checkbox, a text box appears which you can use to enter a custom label for the field.
Read-only (even when used for data-entry). Turn on this checkbox to prohibit users from entering any data in the field (even on an add or edit form). Data displays in the field, but users can't modify it.
This feature is especially useful when you're designing fields for different roles. One role might need to see some information, like "meeting venue" for example, but shouldn't be allowed to change it. (Customizable roles are not available to accounts on the QuickBase Essential plan.)
Required (when used for data-entry using this form). Turn on this checkbox to force users to complete a particular field. When you do so, QuickBase won't let a user save the record without completing the field. The form features a red asterisk next to the field, so users know that it's required. If you've already turned on the required checkbox in the field's properties page, this selection is grayed out. You cannot require File Attachment fields.
For Address fields only:
For Text - Multiple-choice fields only:
Display choices as radio buttons (instead of a dropdown). By default, choices in Text - Multiple-choice fields display in a dropdown, as shown below:
If you choose this option, you can specify that these choices appear as radio buttons on the form instead, as shown below:
Note: If you use this option, application users will not have the ability to add a new choice to the multiple choice field, regardless of whether the field's properties specify that users should be able to add new choices.
If you have multiple tables in your application, and they're related to each other, your form may contain a reference field. When reference fields appear on your form, they display as dropdowns from which users can select a record in a related master table. The format of the choices that appear here are automatically controlled by the Record Picker, which works very well for most form designers. But say you have a special report that features exactly the columns (fields) that you want to appear in this list of choices. You can tell QuickBase to use that format, instead of the Record Picker's.
Click SETTINGS on the table home page.
Click Forms to see the list of available forms, and then click the form name to open the Form Builder.
In the Element tab's field list, select the reference field.
In the pane on the right side of the Form Builder, click the When used for data entry: dropdown and select the desired report.
To tweak the appearance of the related reference field (or even the record picker's settings) click the report... link to the right of the dropdown. QuickBase opens the Report Builder (or the record picker) so you can change the format.
Save your changes.
Often, you'll want to embed a list of related records on a form. For example, when you open a project record you'd like it to show a list of all tasks linked to the project. Or maybe you'd like an invoice form to show all related work orders. For this to work, you first need to have your data set up correctly. The tables in question must be related to one another. (Project would be a master table related to Tasks, the details table, for example. Learn more about relationships.) If everything is in place, you can easily embed a report within your form. Read how.
Make sure the report you insert has no matching criteria set. If it does, you won't see the records you expect to see. OK, but how do you know which reports have matching limitations? You can see or edit a report directly from this screen. To do so, select the report from the list and click the report... link to its right. QuickBase opens the report in the Report Builder so you can make changes.
A poorly designed form often looks like a jumble of unrelated fields. QuickBase makes it easy to add instructions and organize your form in sections. Doing so provides your users some guidance and helps them understand what you expect them to do.
Use Section Headings to divide your form into easily digestible sections. Create a section for each kind of data you want users to enter. For example, you might have a "Contact information" section followed by an "Order Information" section on the same form. To insert a Section Heading, click any Make a Selection... dropdown and choose Section Heading. When you do so, QuickBase displays a Section Heading text box in the pane to the right of the field list. Use this box to type in the heading text. Insert and move a Section Heading as you would any other field. Section Headings with text are collapsible; click the icon to the left of the section heading to expand or collapse the section.
Tip: You can insert horizontal lines to separate the sections on your forms. To do so, click the Properties tab and turn on the Display horizontal rules between sections checkbox.
Use Text elements to enter text anywhere on the form. The Make a Selection... dropdown features a selection called Text. When you choose Text, QuickBase displays a large box in the pane to the right of the field list. Use this box to type in whatever text you want to display. QuickBase inserts a snippet of text in the form, just like you'd add a field.
If you want to dress up your text, and have some knowledge of HTML, QuickBase lets you insert certain HTML tags to add some pizzazz and functionality. Just select the HTML (Limited) checkbox below the text box. The tags allowed include basic formatting options like bold and italic text, and links. See the list below:
format text within paragraph
table heading cell
You can only position form field labels if you have at least one Section Heading on your form. If you don't want section heading text to appear in your form, you can still create one, but leave the box blank. When you add a section heading (or select the Section Heading element by clicking its icon), the pane on the right offers placement controls for field labels.
If you want labels to appear above fields, select the Above fields radio button within the Field labels in this section appear: section.
If you want labels to appear to the left of your fields, select to the left of fields instead. This option lets you vary the placement of field names from section to section.
Tip: If you place field labels to the left of fields, you may want to make those labels wrap. This ensures that long labels won't force your form to widen beyond the width of the browser window. To do so, click the Properties tab and turn on the Allow field labels to wrap checkbox.
Return to top
© 1999-2016 Intuit Inc. All rights reserved. Legal Notices.
Show help contents