Technical Documentation

IDCategoryReq.Element Action
684booleanno$zz['fields'][n]['unique'] if field value is unique, it can be used for where-clauses and will show only one record in display mode, without add new recordShow
960booleanno$zz['fields'][n]['update_on_detail_update'] Updates this field in main record if there were updates, inserts or deletions in one of the detail records

Relations: timestamp

Show
848booleanno$zz['fields'][n]['use_as_label'] In combination with e. g. tick_for_save, this field's value will be enclosed in a label for the checkbox

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

Show
411integerno$zz['fields'][n]['cols'] number of cols in textarea

Relations: memo

Show
860integerno$zz['fields'][n]['decrease_level'] Decreases numerical value for class name 'leveln' by this value (1 ... n)

Relations: $zz['list']['hierarchy']['display_in']

Show
428integerno$zz['fields'][n]['detail_key_index'] Show
426integerno$zz['fields'][n]['detail_value'] copies value from other fieldShow
408integerno$zz['fields'][n]['factor'] factor for avoiding doubles as database fields

Relations: number

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
976integerno$zz['fields'][n]['formatting_spaces'] sets numbers of maximal spaces that are allowed; on saving a record, all spaces are removedShow
190integerno$zz['fields'][n]['max_records']

Relations: subtable

Show
940string: SQLno$zz['fields'][n]['max_records_sql'] SQL query to get the maximum number of detail records

Relations: subtable

Show
460integerno$zz['fields'][n]['maxlength'] maxlength, if not set will be taken from databaseShow
714integerno$zz['fields'][n]['min_records_required']

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

Show
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

348 records total

in