Database fields - Revision history

Roal: wrong info about number format corrected

2008-05-10T09:12:59Z

wrong info about number format corrected

← Older revision		Revision as of 09:12, 10 May 2008
Line 34:		Line 34:
	=== Number ===		=== 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".		Stores a floating number. Examples:
			* -1000
			* 0
			* 0.123

	=== Picture ===		=== Picture ===
Line 60:		Line 63:

	=== Latitude/longitude ===		=== Latitude/longitude ===

	{{Moodle 1.7}}Users can enter a geographic location, by specifying the location's latitude and longitude. For example, [http://moodle.com/hq/ Moodle HQ] is at latitude -31.9545, longitude 115.877. When viewing the record, links are automatically generated linking to geographic data services such as [http://earth.google.com Google Earth], [http://www.openstreetmap.org/ OpenStreetMap], [http://www.geabios.com/ GeaBios],[http://www.mapstars.com/extern/deltaworks-holland Mapstars] and more. (The teacher can choose which of those links appear, if any.)		{{Moodle 1.7}}Users can enter a geographic location, by specifying the location's latitude and longitude. For example, [http://moodle.com/hq/ Moodle HQ] is at latitude -31.9545, longitude 115.877. When viewing the record, links are automatically generated linking to geographic data services such as [http://earth.google.com Google Earth], [http://www.openstreetmap.org/ OpenStreetMap], [http://www.geabios.com/ GeaBios],[http://www.mapstars.com/extern/deltaworks-holland Mapstars] and more. (The teacher can choose which of those links appear, if any.)

Tsala: see also

2008-02-11T09:54:15Z

see also

← Older revision		Revision as of 09:54, 11 February 2008
Line 2:		Line 2:

	A '''field''' is a named unit of information. Each entry in a [[Database module\|database]] can have multiple fields of multiple types e.g. a text field called 'favourite color' which allows you to type in your favourite shade, or a menu called 'state' that lets you choose one from a list of the 50 that make up the United States of America. By combining several fields with appropriate names and types you should be able to capture all the relevant information about the items in your database.		A '''field''' is a named unit of information. Each entry in a [[Database module\|database]] can have multiple fields of multiple types e.g. a text field called 'favourite color' which allows you to type in your favourite shade, or a menu called 'state' that lets you choose one from a list of the 50 that make up the United States of America. By combining several fields with appropriate names and types you should be able to capture all the relevant information about the items in your database.


	== Field name and description ==		== Field name and description ==
Line 59:		Line 60:

	=== Latitude/longitude ===		=== Latitude/longitude ===
	{{Moodle 1.7}}		{{Moodle 1.7}}Users can enter a geographic location, by specifying the location's latitude and longitude. For example, [http://moodle.com/hq/ Moodle HQ] is at latitude -31.9545, longitude 115.877. When viewing the record, links are automatically generated linking to geographic data services such as [http://earth.google.com Google Earth], [http://www.openstreetmap.org/ OpenStreetMap], [http://www.geabios.com/ GeaBios],[http://www.mapstars.com/extern/deltaworks-holland Mapstars] and more. (The teacher can choose which of those links appear, if any.)
	Users can enter a geographic location, by specifying the location's latitude and longitude. For example, [http://moodle.com/hq/ Moodle HQ] is at latitude -31.9545, longitude 115.877. When viewing the record, links are automatically generated linking to geographic data services such as [http://earth.google.com Google Earth], [http://www.openstreetmap.org/ OpenStreetMap], [http://www.geabios.com/ GeaBios],[http://www.mapstars.com/extern/deltaworks-holland Mapstars] and more. (The teacher can choose which of those links appear, if any.)
			==See also==

	[~~[Category~~:~~Teacher]]~~		*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=86927 Time stamp for database entries?] forum discussion
	~~[[Category:Database]~~]

	[[ru:Поля]]		[[ru:Поля]]
	[[fr:Champs]]		[[fr:Champs]]
	[[ja:データベースフィールド]]		[[ja:データベースフィールド]]

Ray: /* Checkbox */

2008-02-10T14:37:43Z

Checkbox

← Older revision		Revision as of 14:37, 10 February 2008
Line 13:		Line 13:
	Allows one or more checkboxes. Each line in the options box is a different checkbox. The text entered is what will be the case if the checkbox is checked e.g. 'valid' for something that can be valid or not. This word will appear beside the checkbox on entry, and then by itself when viewing if the box has been checked. If you wish to ensure that the user actively selects one of the options you can use [[Database_fields#Radio buttons\|radio buttons]] instead		Allows one or more checkboxes. Each line in the options box is a different checkbox. The text entered is what will be the case if the checkbox is checked e.g. 'valid' for something that can be valid or not. This word will appear beside the checkbox on entry, and then by itself when viewing if the box has been checked. If you wish to ensure that the user actively selects one of the options you can use [[Database_fields#Radio buttons\|radio buttons]] instead

	Multiple ~~checboxes~~ could be used, for example, in a movie database that has Horror, Comedy, Western etc. checkboxes for different film genres, and you would be able to check more than one in the case of Horror-Comedies or Comedy-Westerns. The [[Database_fields#Menu (multi-select)\|menu (multi-select)]] field also achieves this, but clicking multiple checkboxes is usually a more obvious interface.		Multiple checkboxes could be used, for example, in a movie database that has Horror, Comedy, Western etc. checkboxes for different film genres, and you would be able to check more than one in the case of Horror-Comedies or Comedy-Westerns. The [[Database_fields#Menu (multi-select)\|menu (multi-select)]] field also achieves this, but clicking multiple checkboxes is usually a more obvious interface.

	=== Date ===		=== Date ===

Ray: /* Checkbox */

2008-02-10T14:37:14Z

Checkbox

← Older revision		Revision as of 14:37, 10 February 2008
Line 13:		Line 13:
	Allows one or more checkboxes. Each line in the options box is a different checkbox. The text entered is what will be the case if the checkbox is checked e.g. 'valid' for something that can be valid or not. This word will appear beside the checkbox on entry, and then by itself when viewing if the box has been checked. If you wish to ensure that the user actively selects one of the options you can use [[Database_fields#Radio buttons\|radio buttons]] instead		Allows one or more checkboxes. Each line in the options box is a different checkbox. The text entered is what will be the case if the checkbox is checked e.g. 'valid' for something that can be valid or not. This word will appear beside the checkbox on entry, and then by itself when viewing if the box has been checked. If you wish to ensure that the user actively selects one of the options you can use [[Database_fields#Radio buttons\|radio buttons]] instead

	Multiple checboxes could be ~~use~~, for example, in a movie database that has Horror, Comedy, Western etc. checkboxes for different film genres, and you would be able to check more than one in the case of Horror-Comedies or Comedy-Westerns. The [[Database_fields#Menu (multi-select)\|menu (multi-select)]] field also achieves this, but clicking multiple checkboxes is usually a more obvious interface.		Multiple checboxes could be used, for example, in a movie database that has Horror, Comedy, Western etc. checkboxes for different film genres, and you would be able to check more than one in the case of Horror-Comedies or Comedy-Westerns. The [[Database_fields#Menu (multi-select)\|menu (multi-select)]] field also achieves this, but clicking multiple checkboxes is usually a more obvious interface.

	=== Date ===		=== Date ===

Mits: ja link

2007-12-12T20:52:20Z

ja link

← Older revision		Revision as of 20:52, 12 December 2007
Line 1:		Line 1:
	~~[[ru:Поля]]~~
	{{Databases}}		{{Databases}}

Line 65:		Line 64:
	[[Category:Teacher]]		[[Category:Teacher]]
	[[Category:Database]]		[[Category:Database]]

			[[ru:Поля]]
	[[fr:Champs]]		[[fr:Champs]]
			[[ja:データベースフィールド]]

Rcollman: /* Checkbox */ correct link

2007-09-11T11:12:19Z

Checkbox: correct link

← Older revision		Revision as of 11:12, 11 September 2007
Line 14:		Line 14:
	Allows one or more checkboxes. Each line in the options box is a different checkbox. The text entered is what will be the case if the checkbox is checked e.g. 'valid' for something that can be valid or not. This word will appear beside the checkbox on entry, and then by itself when viewing if the box has been checked. If you wish to ensure that the user actively selects one of the options you can use [[Database_fields#Radio buttons\|radio buttons]] instead		Allows one or more checkboxes. Each line in the options box is a different checkbox. The text entered is what will be the case if the checkbox is checked e.g. 'valid' for something that can be valid or not. This word will appear beside the checkbox on entry, and then by itself when viewing if the box has been checked. If you wish to ensure that the user actively selects one of the options you can use [[Database_fields#Radio buttons\|radio buttons]] instead

	Multiple checboxes could be use, for example, in a movie database that has Horror, Comedy, Western etc. checkboxes for different film genres, and you would be able to check more than one in the case of Horror-Comedies or Comedy-Westerns. The [[~~Fields~~#Menu (multi-select)\|menu (multi-select)]] field also achieves this, but clicking multiple checkboxes is usually a more obvious interface.		Multiple checboxes could be use, for example, in a movie database that has Horror, Comedy, Western etc. checkboxes for different film genres, and you would be able to check more than one in the case of Horror-Comedies or Comedy-Westerns. The [[Database_fields#Menu (multi-select)\|menu (multi-select)]] field also achieves this, but clicking multiple checkboxes is usually a more obvious interface.

	=== Date ===		=== Date ===

Rcollman: /* Checkbox */ correct link

2007-09-11T11:11:11Z

Checkbox: correct link

← Older revision		Revision as of 11:11, 11 September 2007
Line 12:		Line 12:
	=== Checkbox ===		=== Checkbox ===

	Allows one or more checkboxes. Each line in the options box is a different checkbox. The text entered is what will be the case if the checkbox is checked e.g. 'valid' for something that can be valid or not. This word will appear beside the checkbox on entry, and then by itself when viewing if the box has been checked. If you wish to ensure that the user actively selects one of the options you can use [[~~Fields~~#Radio buttons\|radio buttons]] instead		Allows one or more checkboxes. Each line in the options box is a different checkbox. The text entered is what will be the case if the checkbox is checked e.g. 'valid' for something that can be valid or not. This word will appear beside the checkbox on entry, and then by itself when viewing if the box has been checked. If you wish to ensure that the user actively selects one of the options you can use [[Database_fields#Radio buttons\|radio buttons]] instead

	Multiple checboxes could be use, for example, in a movie database that has Horror, Comedy, Western etc. checkboxes for different film genres, and you would be able to check more than one in the case of Horror-Comedies or Comedy-Westerns. The [[Fields#Menu (multi-select)\|menu (multi-select)]] field also achieves this, but clicking multiple checkboxes is usually a more obvious interface.		Multiple checboxes could be use, for example, in a movie database that has Horror, Comedy, Western etc. checkboxes for different film genres, and you would be able to check more than one in the case of Horror-Comedies or Comedy-Westerns. The [[Fields#Menu (multi-select)\|menu (multi-select)]] field also achieves this, but clicking multiple checkboxes is usually a more obvious interface.

Tsala: Fields moved to Database fields

2007-08-25T09:36:20Z

Fields moved to Database fields

← Older revision		Revision as of 09:36, 25 August 2007
(No difference)

Dobrovolsky at 08:31, 24 March 2007

2007-03-24T08:31:43Z

← Older revision		Revision as of 08:31, 24 March 2007
Line 1:		Line 1:
			[[ru:Поля]]
	{{Databases}}		{{Databases}}

Electrolinux: French version link

2006-09-28T10:38:17Z

French version link

← Older revision		Revision as of 10:38, 28 September 2006
Line 64:		Line 64:
	[[Category:Teacher]]		[[Category:Teacher]]
	[[Category:Database]]		[[Category:Database]]
			[[fr:Champs]]