Difference between revisions of "SAM V2:Multiple Choice Fields"
Jump to navigation
Jump to search
(New page: The multiple choice fields table is one of the administrative tables in SAM V2. It is used to specify the list of values that appear in the drop-down multiple choice fields when adding or...) |
|||
| Line 2: | Line 2: | ||
Records in the multiple choice fields table can be viewed and edited, but cannot be added or deleted. | Records in the multiple choice fields table can be viewed and edited, but cannot be added or deleted. | ||
The option values must be input as a comma-separated list and should not contain extra blank spaces. | |||
[[SAM V2#Tables|Back to SAM V2 Tables]] | [[SAM V2#Tables|Back to SAM V2 Tables]] | ||
| Line 12: | Line 14: | ||
!Field | !Field | ||
!Description | !Description | ||
|- | |||
|field_name | |||
|The name of the field in the table that is a multiple choice field. | |||
|- | |- | ||
|last_update | |last_update | ||
|Date the records was last updated. | |Date the records was last updated. | ||
|- | |- | ||
| | |option_values | ||
|The | |The list of multiple choice values for the field. The option values must be input as a comma-separated list and should not contain extra blank spaces. | ||
|- | |||
|table_name | |||
|The name of the table that contains the field. | |||
|- | |- | ||
|uid | |uid | ||
| Line 25: | Line 33: | ||
|User who last modified the record. | |User who last modified the record. | ||
|- | |- | ||
|} | |} | ||
Latest revision as of 15:13, 20 June 2008
The multiple choice fields table is one of the administrative tables in SAM V2. It is used to specify the list of values that appear in the drop-down multiple choice fields when adding or editing records.
Records in the multiple choice fields table can be viewed and edited, but cannot be added or deleted.
The option values must be input as a comma-separated list and should not contain extra blank spaces.
Fields
The fields of the permission table are:
| Field | Description |
|---|---|
| field_name | The name of the field in the table that is a multiple choice field. |
| last_update | Date the records was last updated. |
| option_values | The list of multiple choice values for the field. The option values must be input as a comma-separated list and should not contain extra blank spaces. |
| table_name | The name of the table that contains the field. |
| uid | Unique ID# of the record. |
| updated_by | User who last modified the record. |