how do you interpet 'field' in content of a DBMS?
Answers
Answered by
1
Common Field Properties
There are several field properties that are common to all field types. Below is a list of each of these properties and their details.
Basic Field Properties
This set of properties defines the overall functionality and behaviour of the field.
Field Type
A field type defines the functionality and properties of a field. The field type cannot be updated once a field has been created. For a complete list see available field types.
Field Label
The field label is used to identify the field. The field label is shown on the summary table, add record page, edit record page and record detail page. It is always used to identify the field in exports.
Required
Fields which are required must be completed before submitting or updating a record.
Hidden
Fields which are hidden can only be seen by users with the permission to view hidden fields. For further information see setting permissions.
Locked
Fields which are locked can only have their content added or updated by users with the permission to edit locked fields. For further information see setting permissions.
Descriptive Properties
These properties are used to provide overall field definition and guidance to members while adding, updating and viewing records.
Language
The language drop-down menu only appears if multilingual support has been enabled for the site. It is used in conjunction with the display name, description, prefix and suffix fields. Select a language from the drop-down menu and complete the fields (note that they are not required). The text entered for the fields will appear in the database tool when the respective community display language has been selected. Select another language and complete the fields if multi-lingual support is desired.
Note: If fields are completed in only one language, these values will be displayed for each language the community supports.
Display Name
The display name replaces the field label on the add record, updated record, and record details page.
Hide display name on record details page
Select this option if the display name should not be shown on the record details page. This may be desired if the contents are self-describing or custom styles will be applied to the field content.
Description or Instructions
This field can be used to provide a description to members while adding a record, updating a record, or viewing the record details page. HTML markup is supported in this area.
Prefix
The prefix is a text value that will be shown before a field (i.e. $ 300). HTML markup is supported in this area.
Suffix
The suffix is a text value that will be shown after a field (i.e. 300/month). HTML markup is supported in this area.
Summary Table Properties
This set of properties is used to define how field entries appear on the summary table.
Include field in summary table by default
Select this option to have the field appear as a column in the summary table by default.
Column Header
Select from the drop-down menu whether the field label or display name should appear in the column header of the summary table.
Field Label Width
Enter a number that represents the desired column field width in the summary table, then select whether this value is represented in pixels or a percentage of the screen width. If a percentage is chosen, all other fields must use percentage as their width for this to take effect.
Maximum Size Characters
Enter the maximum number of characters that will be displayed in the summary table. Leaving this field blank will allow the full content to appear.
Allow column header to wrap
Select this value to allow the column header (field name or display label) to wrap onto multiple lines in the summary table header.
Allow cell content to wrap
Select this value to allow the field content to wrap onto multiple lines in the summary table.
Note: The column header and cell content will only wrap if there is at least one space between the characters.
Cell Alignment
Select the desired horizontal and vertical alignment in the summary table.
Field Specific Properties
Select the following links to find more information on configuring field specific properties. Only fields containing additional properties are listed.
Short Text Field
Long Text Field
Formatted Text Field
Hyperlink Field
Email Field
Boolean Field
Number Field
File Field
Select List Field
Image Field
Member Field
Foreign Key Field
There are several field properties that are common to all field types. Below is a list of each of these properties and their details.
Basic Field Properties
This set of properties defines the overall functionality and behaviour of the field.
Field Type
A field type defines the functionality and properties of a field. The field type cannot be updated once a field has been created. For a complete list see available field types.
Field Label
The field label is used to identify the field. The field label is shown on the summary table, add record page, edit record page and record detail page. It is always used to identify the field in exports.
Required
Fields which are required must be completed before submitting or updating a record.
Hidden
Fields which are hidden can only be seen by users with the permission to view hidden fields. For further information see setting permissions.
Locked
Fields which are locked can only have their content added or updated by users with the permission to edit locked fields. For further information see setting permissions.
Descriptive Properties
These properties are used to provide overall field definition and guidance to members while adding, updating and viewing records.
Language
The language drop-down menu only appears if multilingual support has been enabled for the site. It is used in conjunction with the display name, description, prefix and suffix fields. Select a language from the drop-down menu and complete the fields (note that they are not required). The text entered for the fields will appear in the database tool when the respective community display language has been selected. Select another language and complete the fields if multi-lingual support is desired.
Note: If fields are completed in only one language, these values will be displayed for each language the community supports.
Display Name
The display name replaces the field label on the add record, updated record, and record details page.
Hide display name on record details page
Select this option if the display name should not be shown on the record details page. This may be desired if the contents are self-describing or custom styles will be applied to the field content.
Description or Instructions
This field can be used to provide a description to members while adding a record, updating a record, or viewing the record details page. HTML markup is supported in this area.
Prefix
The prefix is a text value that will be shown before a field (i.e. $ 300). HTML markup is supported in this area.
Suffix
The suffix is a text value that will be shown after a field (i.e. 300/month). HTML markup is supported in this area.
Summary Table Properties
This set of properties is used to define how field entries appear on the summary table.
Include field in summary table by default
Select this option to have the field appear as a column in the summary table by default.
Column Header
Select from the drop-down menu whether the field label or display name should appear in the column header of the summary table.
Field Label Width
Enter a number that represents the desired column field width in the summary table, then select whether this value is represented in pixels or a percentage of the screen width. If a percentage is chosen, all other fields must use percentage as their width for this to take effect.
Maximum Size Characters
Enter the maximum number of characters that will be displayed in the summary table. Leaving this field blank will allow the full content to appear.
Allow column header to wrap
Select this value to allow the column header (field name or display label) to wrap onto multiple lines in the summary table header.
Allow cell content to wrap
Select this value to allow the field content to wrap onto multiple lines in the summary table.
Note: The column header and cell content will only wrap if there is at least one space between the characters.
Cell Alignment
Select the desired horizontal and vertical alignment in the summary table.
Field Specific Properties
Select the following links to find more information on configuring field specific properties. Only fields containing additional properties are listed.
Short Text Field
Long Text Field
Formatted Text Field
Hyperlink Field
Email Field
Boolean Field
Number Field
File Field
Select List Field
Image Field
Member Field
Foreign Key Field
Similar questions