Visual Tutorials | Joule | How do I set up fields in a database activity?

Visual Tutorials » Joule » How do I set up fields in a database activity?

Once you have created a database and save its preference you'll need to designate some fields that will be part of your database.
A field is a named unit of information that can be displayed in different formats.The field definitions create the basic structure of the database and determine what kind of information students can enter into your database.

Turn on editing mode.

Click here to learn how.

Create a database and save its preferences

Click here to learn how.

Define Database fields

Select a type of field

* Checkbox: To select options from a set and mark them in a checkbox.

* Date: To enter a date by selecting day, month, and year from a drop-down list.

* File: To uploads a file of any type from their computer. ( Use the field pictures for images)

* Latitude/longitude: To enter a geographic location by specifying the location’s latitude and longitude. Links will be automatically generated to geographic data services such as Google Maps, Google Earth, or Multimap.

* Menu: To select an option from a drop-down menu. Enter each option on a different line in the options text field.

* Menu (multiselect): To select multiple options from a drop-down menu (by holding down the Control or Shift).

* Number: To enter a number (positive, negative, or zero).

* Picture: To upload an image file from their computer.

* Radio buttons: To select just one option from a list.

* Text: To enter text up to 60 characters in length..

* Textarea: to enter text longer than 60 characters in length and/or include HTML formatting.

* URL: to enter a URL. Selecting “Autolink the URL” will make the URL a clickable link, and entering a forced name for the link means that the name will be used for the hyperlink.

Repeat the procedure and add more fields if needed

After finishing adding the fields, It is then optional to edit the database templates

Templates allow you to control the visual layout of information when listing, viewing or editing database entries. It is a similar to the technique used to mail merge letters in word processors such as Open Office Writer or Microsoft Word.