Technical Documentation

Show a record

 
Submit data …
ID 429
Category string: field
Required no
Element $zz['fields'][n]['foreign_key_field_name']
Description

Normally, zzform uses maintable.id_field as WHERE maintable.id_field = id_value for subtables. This variable allows to set a different key_field_name, e. g. if you use table aliases

Description de
Example
Default value
Mother ID $zz['fields'][n] | [10]
Relation
Updated 27 Jun 2011 11:58:37
IDCategoryReq.Element Action
388booleanno$zz['fields'][n]['exclude_from_search'] search will do no operations in this fieldShow
474string: HTMLno$zz['fields'][n]['explanation_top'] same as explanation, this will show up above the form element, not below.

Relations: $zz['fields'][n]['explanation']

Show
475string: HTMLno$zz['fields'][n]['explanation'] explanation how to fill in values in this field, will only be shown in edit or insert modeShow
643booleanno$zz['fields'][n]['export_no_html'] Export (e. g. CSV export) will be text only, HTML formattings are strippedShow
786booleanno$zz['fields'][n]['export'] Exclude field from exportShow
685stringno$zz['fields'][n]['f_field_name'] INTERNAL USE ONLY

Relations: $zz['fields'][n]['field_name']

Show
408integerno$zz['fields'][n]['factor'] factor for avoiding doubles as database fields

Relations: number

Show
11string: fieldyes$zz['fields'][n]['field_name'] Database field name; required, if field value shall be shown or changed in the output. Not all fields of a table have to be defined, the undefined fields will be ignored by the script.

Relations: $zz['fields'][n]

Show
994integerno$zz['fields'][n]['field_sequence'] If you like a different order of your fields than the order in the definition file, you can set a sequence here. It is even possible to mix the main table and subtables if form_display for the subtable is set to 'lines'Show
621arrayno$zz['fields'][n]['fielddefs'] In combination with 'values', 'fielddefs' allows to change some $zz['fields']-settings for individual detail records where values are preset. The first numerical index of the field definition corresponds to the numerical index of the corresponding value, the second index corresponds to the field index that shall be changed.

Relations: subtable; $zz['fields'][n]['values']

Show
364arrayno$zz['fields'][n]['fields'] List of fields which are used to create an identifier (`$zz['fields'][n]['type'] = 'identifier'`). If field_name of identifier-field is part of the array, the identifier won't be changed later on (write_once). Corresponding values of ID fields may be used writing `field_id[value]`. The fields are used in the same order as in the array. vars which will be passed to function or identifier, might be in form like "select_id[field_name_from_select]" as well, this refers to a field "select_id" with an associated sql-query and returns the value of the "field_name_from_select" of the query instead. Values from subtables will have a table_name. or table. prefix. first value is chosen if more than one (more than one record not recommended!). {0,4} or {4} ... will call a substr()-function to return just a part of the field value if identifier must not be changed after set, include field_name of identifier in list Show
172string: fieldno$zz['fields'][n]['fields'][n]['detail_key'] inserts in field id_field from different detail_recordShow
847booleanno$zz['fields'][n]['for_action_ignore'] field will be ignored when action is determined

Relations: $zz['fields'][n]['def_val_ignore']

Show
429string: fieldno$zz['fields'][n]['foreign_key_field_name'] Normally, zzform uses maintable.id_field as WHERE maintable.id_field = id_value for subtables. This variable allows to set a different key_field_name, e. g. if you use table aliases

Relations: subtable

Show
198stringno$zz['fields'][n]['form_display'] - vertical (default vertical view as in standard form) - horizontal: shows detail records in list view - set: show detail records like set with radio buttons; works only with a detail table just with detail_table_id, foreign_key of main table and some other ID. - inline: only works with 1 subrecord, show subfields as if they're part of the main record

Relations: select; subtable

Show
35string: functionno$zz['fields'][n]['format'] Formats in form view text content of field with this markup language (e. g. Markdown), function of the same name must lie inside zzform-folder

Relations: text; memo

Show
976integerno$zz['fields'][n]['formatting_spaces'] sets numbers of maximal spaces that are allowed; on saving a record, all spaces are removedShow
399string: functionno$zz['fields'][n]['function'] function which will be called to change input value `function($vars, $field_name);` $vars = POST vars of fields defined in an array in $zz['fields'][n]['fields'] $field_name = $zz['fields'][n]['field_name']

Relations: hidden

Show
810stringno$zz['fields'][n]['geo_display_behind'] will display coordinate behind coordinate field, possible values are dec, dms, deg, dm

Relations: number

Show
811stringno$zz['fields'][n]['geo_format'] output of coordinate, possible values are dec, dms, deg, dm

Relations: number

Show

916 records total

in