Technical Documentation

ID Category Req. Element Action
436 boolean no $zz['fields'][n]['null_string'] Field value might be 0 or '', won't be set to NULL => output = ''

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

435 boolean no $zz['fields'][n]['null'] Field value might be 0 or '', won't be set to NULL => output = 0

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

398 string no $zz['fields'][n]['number_type'] - 'longitude' | 'latitude', for entering geo information - 'currency' for money - 'bytes' for bytes, for displaying MB, GB, TB etc. - 'number' for numbers, formatted with thousands_separator and decimal_point

Relations: number

427 array no $zz['fields'][n]['options'] Together with enum-array; values from enum-array will have to be set as pairs. E. g. enum-value proportional will be an array in options, first is key which will be added to image, second is corresponding value: ['options'] = array('proportional' => array('key' => 'value')); existing keys will be overwritten
617 string no $zz['fields'][n]['order'] different field name for ORDER BY, e. g. if a table name is needed in case of ambiguous field names or for mixed alpha-numerical strings without preceding zeros
648 string no $zz['fields'][n]['path_json_base'] base for JSON link, will be prepended

Relations: image; $zz['fields'][n]['path_json_request']

647 array: path no $zz['fields'][n]['path_json_request'] requests image filename via JSON request

Relations: image

421 string: SQL no $zz['fields'][n]['path_sql'] only if this sql query is needed for constructing the extension of a file path; sql-query which will be used if this field's display_value is set as fieldxx in path to get a correct extension for file conversions

Relations: select

184 array no $zz['fields'][n]['path'] values: - `root` DOCUMENT_ROOT or path to directory, will be used as a prefix to check whether file_exists or not - `webroot` alternative for DOCUMENT_ROOT on URL basis of the webserver - `fieldXX` will add corresponding field value, - `stringXX` will add string value, (string1 will be weblink to file, parallel to root) - `webstringXX` same as string, but applied only to web path, not to file path - `modeXX`: functions that will be applied to all field_values - last `stringXX` or `fieldXX`: this must consist of the fileextension only (with or without .) e. g. array('field1' => 'fieldname_bla', 'string1' => '/', 'field2' => 'fieldname_blubb') etc. - as an alternative, `extension` can be used instead of fieldXX - `x_field[2]XX` = similar to field, but for 2x image - `x_field[1.5]XX` = similar to field, but for 1.5x image - `x_extension[2]XX` = similar to extension, but for 2x image - `x_webfield[2]XX` = similar to webfield, but for 2x image
709 string: function no $zz['fields'][n]['post_validation'] Function that will be called with field value and field name as parameters directly after validation of a field; returned values will be saved in 'extra' to let other records access values later

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

464 string: HTML no $zz['fields'][n]['prefix'] adds prefix-string to form view

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

616 integer no $zz['fields'][n]['read_options'] Index of field on which options depend

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

200 boolean no $zz['fields'][n]['records_depend_on_upload']
986 boolean no $zz['fields'][n]['remove_local_hostname'] per default, the hostname of the local server will be removed starting with http:// or https://. this setting disables this behaviour
741 array no $zz['fields'][n]['replace_values'] replaces submitted value with a different value (e. g. if you ask for some date in a field when somebody has done something and the answer is "no" but you just want to get the date)
618 boolean no $zz['fields'][n]['required'] field requires an input (same behaviour as NOT NULL, but allow flexible table definition)
412 integer no $zz['fields'][n]['rows_max'] max number of rows in textarea (textarea might expand if text is edited to approximately the numbers of rows needed to display all text without scroll bar)

Relations: memo

202 integer no $zz['fields'][n]['rows'] number of rows in textarea, will be expanded if a record is edited to approximately the needed length

Relations: memo

802 string: SQL no $zz['fields'][n]['search_between']
619 string: SQL no $zz['fields'][n]['search'] if a field does not appear without an alias or appears ambiguous in the SQL query for 'list' view, here you can define the exact field name or field combination that will be used for search

Export (CSV Excel)

348 records total

in