Difference between revisions of "SAM V2:Multiple Choice Fields"

From AMACWiki
Jump to: navigation, 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.
 
|-
 
|-
|password
+
|option_values
|The password for the user.
+
|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.
 
|-
 
|-
|user_name
 
|The login name for the user.
 
 
|}
 
|}

Latest revision as of 14: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.

Back to SAM V2 Tables

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.