Table of Contents
Print Complete BookPrint This Chapter PreviousNext

2.2.7.1 Fields

There are 12 different preset fields you can create for your database. Below is a description of each field, along with a picture of the settings needed to be completed for each field.

image

Checkbox: Allows you to create one or more checkboxes. You need to give this field a name, and an optional field description. Then, each line in the options box is a different checkbox. For example, if you had the following in “Options”:
Red
Blue
Green
would give you three checkboxes to choose from when creating your entry, one for each color. If your object was red and blue, you could check both of them. When viewing the entry, you would only see the text for the options that had been checked during the creation of the entry.

image

Date: Allows users to enter a date by picking a day, month and year from a drop down list. You need to give this field a name, and an optional field description.

iimage

File: Asks users to upload a file from their computer. You need to give this field a name, and an optional field description. You can also restrict the maximum size of the file. (If it is an image file then the picture field may be a better choice. )

image

Latitude/longitude: Users can enter a geographic location, by specifying the location's latitude and longitude. For example, Sweet Briar, VA is located at 37.5614722744 latitude & -79.0859141522 longitude. You need to give this field a name, and an optional field description. Then, you need to pick a link-out service, so that when viewing the record, links are automatically generated linking to a geographic data services such as Google Earth, OpenStreetMap, GeaBios, Mapstars and more.

image

Menu: This field is used to create a dropdown list for the user when creating an entry. You need to give this field a name, and an optional field description. Then, the text entered in the “Options” area will be presented as a drop-down list for the user to choose from. Each line becomes a different option in the drop-down list.

image

Menu (Multi-select): Almost identical to the “Menu” field; however by holding down control or shift as they click, users will be able to select multiple options. (Not all users might be comfortable with this method of selection, so it may be wise to use multiple checkboxes instead.)

image

Number: Asks the user to enter a number. The number must be an integer, though it can be negative ( e.g. ...,-2,-1,0,1,2,3,...). If you enter anything else but numbers and a leading minus sign the number will be truncated or converted to zero e.g. "3.14" becomes "3", "1,000,000" becomes "1" and "six" becomes "0". You only need to give this field a name, and an optional field description.

image

Picture: The user can upload an image file from their computer. You need to give this field a name, and an optional field description. You can also set the width and height of the picture when viewed in either single or list view. You can also set a maximum size for the picture.



Radio buttons: Allows the user to choose only one of a range of options. If the user doesn't select any of these options then they will be prompted to do so and can only submit the entry when the option is chosen. You needto give this field a name, and an optional field description. Then, the text entered in the “Options” area will be presented as radiobuttons for the user to choose from. Each line becomes a different radio button.

image

Text: Users can enter text up to 60 characters in length. You need to give this field a name, and an optional field description. You may also allow terms to be autolinked to other sections of your Moodle course.

image

Textarea: Allows users to enter a long piece of text including formatting similar to that found when creating forum posts. You need to give this field a name, and an optional field description. You also need to set the width (number of columns) and height (number of rows) for your text area field.

image

URL: Asks the user to enter a URL. You need to give this field a name, and an optional field description. If you also enter a “Forced name for the link” then that text will be displayed in place of the hyperlink. For example in a database of authors you may wish people to enter the author's website. If you enter the text 'homepage' as a forced name then clicking on text "homepage" will take you to the entered URL. If you select “Autolink the URL” then the URL becomes a clickable link.

PreviousNext