Technical Documentation

IDCategoryReq.Element Action
189integerno$zz['fields'][n]['min_records']

Relations: subtable

Show
939string: SQLno$zz['fields'][n]['min_records_sql'] SQL query to get the minimum number of detail records

Relations: subtable

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

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

Show
412integerno$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

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

Relations: memo

Show
416integerno$zz['fields'][n]['show_hierarchy_subtree'] ID of top hierarchy value, if not set NULL will be used

Relations: select; $zz['fields'][n]['show_hierarchy']

Show
423integerno$zz['fields'][n]['size_select_too_long'] if set, this will be the size of input if a select is not shown but input field instead

Relations: select

Show
405integerno$zz['fields'][n]['size'] Maximum length of characters that may be entered in input field, size of input field, standard for number 16, for time 8 and for all other fields 32 (or maxlength if smaller)Show
569integerno$zz['fields'][n]['upload_field'] For hidden or other fields (which ... ?), says which field is the upload field from which a certain value, defined in 'upload_value', shall be taken

Relations: hidden

Show
278mixedno$zz['fields'][n]['default_image'] in case path leads to no existing image, use this as a default_image (full path only). Might be as well an Array with a path in the standard path styleShow
978mixedno$zz['fields'][n]['group_dependent_tables'] string with one or array of table names for tables that are directly dependent on field content (foreign key, another table joined) if this table is in sort order before the immediate foreign table

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

Show
929mixedno$zz['fields'][n]['separator_before'] - true: will put a separation before this field, to improve form layout. - column_begin, column, column_end: put form in two columns - text bla blubb: will put bla blubb below `<hr>`-Separator

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

Show
465mixedno$zz['fields'][n]['separator'] - true: will put a separation behind this field, to improve form layout. - column_begin, column, column_end: put form in two columns - text bla blubb: will put bla blubb below `<hr>`-SeparatorShow
570mixedno$zz['fields'][n]['upload_value'] Value which will be written to database and taken from uploaded file. Possible values * basics: - filetype: filetype of original file - title: modified filename (without ending, underscores replaced with space, ucfirst() etc.) - filename: filename without extension and web compatible * images: - width: width of original image - height: height of original image - modified[width] - modified[height] * from $_FILES - name: original filename of uploaded file - type - tmp_name - error - size: filesize * more - type_ext: mimetype + extension, e. g. application/octet-stream/dwg - exif[DateTimeOriginal] - ext: file extension - sha1_source_file - modified[filetype] - exif[YResolution] - modified[exif][YResolution] - exif[YResolution] - modified[exif][YResolution] - upload[size] - modified[size] - md5 - md5_source_file - sha1 - sha1_source_file - increment_on_change (adds 1 to a version no. if file changed) - exif[DateTime] - exif[FileName] - exif[FileSize] - ... Good combinations of values are (in case first value is not set, second will be tried): - array('exif[COMPUTED][Width]', 'upload[width]') - array('exif[COMPUTED][Height]', 'upload[height]') - array('channels', 'exif[SamplesPerPixel]') - array('bits', 'exif[BitsPerSample][0]')

Relations: hidden; $zz['fields'][n]['upload_field']

Show
354stringno$zz['fields'][n]['access'] access on record basis `show`: makes a subrecord not editable, just viewable

Relations: $zz['access']

Show
420stringno$zz['fields'][n]['add_details'] add detail records in different table, attention: current input will not be saved. Field gets ID #zz_add_details_x_y_z where x is table no [0...n], y is for subtable no [0 if main table, else 0...n] z is field number in zz-array

Relations: select

Show
437string: HTMLno$zz['fields'][n]['add_details_target'] HTML: target attribute for add_details link (target="")Show
409stringno$zz['fields'][n]['auto_value'] increment | ... // 1 will be added and inserted in 'default'

Relations: number

Show
431stringno$zz['fields'][n]['calculation'] hours | sum (only supported modes)

Relations: calculated

Show
919stringno$zz['fields'][n]['character_set'] Character sets for search fields (if different collations among the database are used and table name is an alias); used for checking search query partsShow

916 records total

in