Technical Documentation

ID Category Req. Element Action
378 value no foreign_key Field is foreign_key (only possible for subtables), must be set once for each subtable (unless it's a translation subtable)

Relations: subtable

853 value no geo_point SQL POINT field with latitude and longitude as binary

Relations: $zz['fields'][n]['geo_format']; $zz['fields'][n]['text_field']; $zz['fields'][n]['list_concat_fields']

389 value no hidden hidden field

Relations: $zz['fields'][n]['value']; $zz['fields'][n]['function']

370 value yes id unique ID field of record

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

368 value no identifier textual identifier for a record, unique, will be put together from 'fields'

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

393 value no image displays an image

Relations: $zz['fields'][n]['path']; $zz['fields'][n]['default_image']

908 value no ip Stores IPv4 and IPv6 addresses in a VARBINARY(16) field
382 value no ipv4
905 value no list_function display field; list_function will be called for display with parameters $field, $value and $line
385 value no mail email address, will be checked for validity and hyperlinked in list
715 value no mail+name Validates input of e. g. "Master X" <x@example.org> and allows input of multiple e-mail addresses, separated by comma or semicolon

Relations: mail

372 value no memo Will show textarea (multiple lines)

Relations: $zz['fields'][n]['format']; $zz['fields'][n]['rows']; $zz['fields'][n]['cols']; $zz['fields'][n]['rows_max']; $zz['fields'][n]['list_format']

367 value no number Number, will be checked for validity. Basic calculation is allowed, e. g. `4+5` will save `9` into the database (+, -, \, *). Decimal commas are replaced (if unambiguous) with dots

Relations: $zz['fields'][n]['number_type']; $zz['fields'][n]['unit']; $zz['fields'][n]['factor']; $zz['fields'][n]['auto_value']

381 value no option field to choose an option, won't be saved to database

Relations: $zz['fields'][n]['type_detail']; $zz['fields'][n]['options']

390 value no password password input, will be saved as hash

Relations: $zz_conf['hash_password']

391 value no password_change change a password (enter old, enter new twice, md5 encoded)

Relations: password; $zz['fields'][n]['sql_password_check']

377 value no predefined INTERNAL USE only

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

369 value no select Lets user select a value from different data sources: foreign database table, ENUM or SET values.

Relations: $zz['fields'][n]['sql']; $zz['fields'][n]['display_field']; $zz['fields'][n]['show_values_as_list']; $zz['fields'][n]['set']; $zz['fields'][n]['enum']; $zz['fields'][n]['sql_where']; $zz['fields'][n]['sql_without_id']; $zz['fields'][n]['sql_ignore']; $zz['fields'][n]['show_hierarchy_subtree']; $zz['fields'][n]['show_hierarchy']; $zz['fields'][n]['key_field_name']; $zz['fields'][n]['show_hierarchy_use_top_value_instead_NULL']; $zz['fields'][n]['add_details']; $zz['fields'][n]['path_sql']; $zz['fields'][n]['hide_novalue']; $zz['fields'][n]['size_select_too_long']

376 value no subtable subrecord with foreign key which can be edited together with main record. when linking tables (subtables, details), special care has to be taken that the key field names are alike

Relations: $zz['fields'][n]['table_name']; $zz['fields'][n]['form_display']; $zz['fields'][n]['class_add']; $zz['fields'][n]['records_depend_on_upload']; foreign_key; $zz['fields'][n]['foreign_key_field_name']

366 value no text standard input, one line text field, maxlength from VARCHAR-value if applicable, else size=32

Relations: $zz['fields'][n]['format']; $zz['fields'][n]['subselect']['list_format']; $zz['fields'][n]['size']

Export (CSV Excel)

916 records total

in