Dictionary Creator - Revision history

Dave: /* Upload Supplied Data */

2025-09-02T13:53:25Z

Upload Supplied Data

← Older revision		Revision as of 13:53, 2 September 2025
Line 357:		Line 357:
	**Device		**Device

	*By default, Golden Retriever sets all supplied coordinates to a Red map marker and completed ones as Green. You may alternately set other colors by defining them (by number) in a '''~~MapColr~~''' field in your csv file. Green is 'reserved' for completed records. Red, Blue, Purple, Yellow and Orange are currently the other colors available for the 'TO DO' map markers. These are set in the csv which contains the utility supplied data. To accomplish this, add a field (csv only and ''not'' in the Dictionary Creator) called '''MapColor''' and identify the requested color by its number:		*By default, Golden Retriever sets all supplied coordinates to a Red map marker and completed ones as Green. You may alternately set other colors by defining them (by number) in a '''MapColor''' field in your csv file. Green is 'reserved' for completed records. Red, Blue, Purple, Yellow and Orange are currently the other colors available for the 'TO DO' map markers. These are set in the csv which contains the utility supplied data. To accomplish this, add a field (csv only and ''not'' in the Dictionary Creator) called '''MapColor''' and identify the requested color by its number:
	** '''0''' - Red		** '''0''' - Red
	** '''1''' - Green (It is not recommended to use green markers)		** '''1''' - Green (It is not recommended to use green markers)

Dave at 20:08, 17 March 2025

2025-03-17T20:08:39Z

← Older revision		Revision as of 20:08, 17 March 2025
Line 114:		Line 114:
	The Date Picker field will open up a calendar screen where the user can select a date. This is different from the automatic timestamp field for each record.		The Date Picker field will open up a calendar screen where the user can select a date. This is different from the automatic timestamp field for each record.
	======Formula======		======Formula======
	With the formula field you can enter an equation string that is evaluated in the app. To reference another field in the dictionary use the format <code>~~Field Name~~</code>.		With the formula field you can enter an equation string that is evaluated in the app. To reference another field in the dictionary use the format <code>"~~Field Name~~"</code> (The quotes are important as ~~Field Name~~ will be replaced by the current value of the field).

	{\| class="wikitable" style="margin:auto"		{\| class="wikitable" style="margin:auto"

Jeff: /* Default Search Field */

2023-02-15T21:40:08Z

Default Search Field

← Older revision		Revision as of 21:40, 15 February 2023
Line 29:		Line 29:
	If this setting is left blank (in the Dictionary Creator) simple map pins will be used.		If this setting is left blank (in the Dictionary Creator) simple map pins will be used.
	[[File:AppMapStyles.jpg\|thumb\|none]]		[[File:AppMapStyles.jpg\|thumb\|none]]

			It is possible for the mobile app user to temporarily change the label by using the search function for the field they wish to see on the map labels. The labels will reflect the most recent field used for the search during the current session. The next time the user opens the dictionary the labels will revert back to the default set in the Dictionary Creator.

	===Field for Device Map===		===Field for Device Map===

Jeff: /* Default Search Field */

2023-02-15T21:35:23Z

Default Search Field

← Older revision		Revision as of 21:35, 15 February 2023
Line 22:		Line 22:
	By default all dictionaries will be shown in the mobile app in alphabetical order. Normally this works but if you wish to specify the order manually the number you enter here will dictate the order shown when selecting a dictionary in the app.		By default all dictionaries will be shown in the mobile app in alphabetical order. Normally this works but if you wish to specify the order manually the number you enter here will dictate the order shown when selecting a dictionary in the app.
	===Default Search Field===		===Default Search Field===
	~~When searching online records the~~ user has ~~the~~ option ~~of which field~~ to search. ~~Any of~~ the ~~dictionary fields may be~~ set as the default search ~~field~~. To make things more efficient the most common search field can be set here (i.e. Pole Number).		The mobile app user has an option to search the existing collected records right from the device. While any field can be used for the search, the administrator has the option to set the default field for the search. To make things more efficient the most common search field can be set here (i.e. Pole Number).
			[[File:DC DictOptions.png\|thumb\|none]]

			A second use of this setting is for the map labels on the mobile app. Common fields used for this are the pole number or circuit number.

			If this setting is left blank (in the Dictionary Creator) simple map pins will be used.
			[[File:AppMapStyles.jpg\|thumb\|none]]

	===Field for Device Map===		===Field for Device Map===
	In the [[https://wiki.goldenretrieverapp.com/index.php?title=Data_Management#Databases_Summary_Page Databases Summary Page]] it is possible to view on a map, the most recent record's GPS location for each device. By setting an inspector name instead of the id of the device, any change in phone/tablet will not effect this maps functionality.		In the [[https://wiki.goldenretrieverapp.com/index.php?title=Data_Management#Databases_Summary_Page Databases Summary Page]] it is possible to view on a map, the most recent record's GPS location for each device. By setting an inspector name instead of the id of the device, any change in phone/tablet will not effect this maps functionality.

Dave: /* Formula */

2022-08-12T13:31:31Z

Formula

← Older revision		Revision as of 13:31, 12 August 2022
Line 105:		Line 105:
	The Date Picker field will open up a calendar screen where the user can select a date. This is different from the automatic timestamp field for each record.		The Date Picker field will open up a calendar screen where the user can select a date. This is different from the automatic timestamp field for each record.
	======Formula======		======Formula======
	With the formula field you can enter an equation string that is evaluated in the app. To reference another field in the dictionary use the format <code>[Field Name]</code>.		With the formula field you can enter an equation string that is evaluated in the app. To reference another field in the dictionary use the format <code>~~Field Name~~</code>.

	{\| class="wikitable" style="margin:auto"		{\| class="wikitable" style="margin:auto"

Dave: /* Formula */

2022-08-08T21:46:06Z

Formula

← Older revision		Revision as of 21:46, 8 August 2022
Line 226:		Line 226:
	\| pyt(a, b) \|\| Alias for hypot.		\| pyt(a, b) \|\| Alias for hypot.
	\|-		\|-
	\| pow(x, y) \|\| Equivalent to x^y~~. For consistency with JavaScript's Math object.~~		\| pow(x, y) \|\| Equivalent to x^y
	\|-		\|-
	\| atan2(y, x) \|\| Arc tangent of x/y. i.e. the angle between (0, 0) and (x, y) in radians.		\| atan2(y, x) \|\| Arc tangent of x/y. i.e. the angle between (0, 0) and (x, y) in radians.

Dave: /* Formula */

2022-08-08T21:45:35Z

Formula

← Older revision		Revision as of 21:45, 8 August 2022
Line 258:		Line 258:
	\| false \|\| Logical false value		\| false \|\| Logical false value
	\|}		\|}
			<br><br>

	======Picklist - Multiple Selection======		======Picklist - Multiple Selection======

Dave: /* Formula */

2022-08-08T21:45:18Z

Formula

← Older revision		Revision as of 21:45, 8 August 2022
Line 107:		Line 107:
	With the formula field you can enter an equation string that is evaluated in the app. To reference another field in the dictionary use the format <code>[Field Name]</code>.		With the formula field you can enter an equation string that is evaluated in the app. To reference another field in the dictionary use the format <code>[Field Name]</code>.

	{\| style="margin:auto"		{\| class="wikitable" style="margin:auto"
	\|+ Operator Precedence		\|+ Operator Precedence
	\|-		\|-

Dave: /* Formula */

2022-08-08T21:44:56Z

Formula

← Older revision		Revision as of 21:44, 8 August 2022
Line 107:		Line 107:
	With the formula field you can enter an equation string that is evaluated in the app. To reference another field in the dictionary use the format <code>[Field Name]</code>.		With the formula field you can enter an equation string that is evaluated in the app. To reference another field in the dictionary use the format <code>[Field Name]</code>.

	{\| ~~class="wikitable"~~ style="margin:auto"		{\| style="margin:auto"
	\|+ Operator Precedence		\|+ Operator Precedence
	\|-		\|-

Dave: /* Formula */

2022-08-08T21:44:40Z

Formula

@@ Line 243: / Line 243: @@
 |-
 | if(c, a, b) || Function form of c ? a : b. Note: This always evaluates both <code>a</code> and <code>b</code>, regardless of whether <code>c</code> is true or not. Use <code>c ? a : b</code> instead if there are side effects, or if evaluating the branches could be expensive.
 |}