1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
5 <class>CustomField
</class>
6 <name>civicrm_custom_field
</name>
7 <comment>Stores info about an extended (custom) property (data and form field info).
</comment>
10 <labelField>label
</labelField>
12 <add>civicrm/admin/custom/group/field/add?reset=
1&action=add
&gid=[custom_group_id]
</add>
13 <update>civicrm/admin/custom/group/field/update?action=update
&reset=
1&id=[id]
&gid=[custom_group_id]
</update>
14 <preview>civicrm/admin/custom/group/preview?reset=
1&fid=[id]
</preview>
15 <delete>civicrm/admin/custom/group/field/delete?reset=
1&id=[id]
</delete>
16 <move>civicrm/admin/custom/group/field/move?reset=
1&fid=[id]
</move>
20 <type>int unsigned
</type>
21 <title>Custom Field ID
</title>
22 <required>true
</required>
23 <comment>Unique Custom Field ID
</comment>
31 <autoincrement>true
</autoincrement>
34 <name>custom_group_id
</name>
35 <type>int unsigned
</type>
36 <title>Custom Group ID
</title>
37 <required>true
</required>
38 <comment>FK to civicrm_custom_group.
</comment>
41 <table>civicrm_custom_group
</table>
42 <keyColumn>id
</keyColumn>
43 <labelColumn>title
</labelColumn>
47 <label>Custom Group
</label>
51 <name>custom_group_id
</name>
52 <table>civicrm_custom_group
</table>
55 <onDelete>CASCADE
</onDelete>
60 <title>Custom Field Name
</title>
62 <comment>Variable name/programmatic handle for this field.
</comment>
68 <title>Custom Field Label
</title>
70 <required>true
</required>
71 <localizable>true
</localizable>
72 <comment>Text for form field label (also friendly name for administering this custom property).
</comment>
76 <name>data_type
</name>
78 <title>Data Type
</title>
80 <required>true
</required>
81 <comment>Controls location of data storage in extended_data table.
</comment>
83 <callback>CRM_Core_BAO_CustomField::dataType
</callback>
88 <label>Data Type
</label>
92 <name>html_type
</name>
94 <title>HTML Type
</title>
96 <required>true
</required>
97 <comment>HTML types plus several built-in extended types.
</comment>
99 <callback>CRM_Core_SelectValues::customHtmlType
</callback>
103 <label>Field Input Type
</label>
108 <name>default_value
</name>
110 <title>Custom Field Default
</title>
112 <comment>Use form_options.is_default for field_types which use options.
</comment>
116 <name>is_required
</name>
117 <title>Custom Field Is Required?
</title>
119 <comment>Is a value required for this property.
</comment>
124 <name>is_searchable
</name>
125 <title>Allow Searching on Field?
</title>
127 <comment>Is this property searchable.
</comment>
132 <name>is_search_range
</name>
134 <title>Search as a Range
</title>
135 <comment>Is this property range searchable.
</comment>
143 <required>true
</required>
145 <comment>Controls field display order within an extended property group.
</comment>
149 <name>help_pre
</name>
151 <title>Custom Field Pre Text
</title>
152 <localizable>true
</localizable>
153 <comment>Description and/or help text to display before this field.
</comment>
157 <name>help_post
</name>
159 <title>Custom Field Post Text
</title>
160 <localizable>true
</localizable>
161 <comment>Description and/or help text to display after this field.
</comment>
167 <title>Custom Field Formatting
</title>
169 <comment>Optional format instructions for specific field types, like date types.
</comment>
173 <name>attributes
</name>
175 <title>Custom Field Attributes
</title>
177 <comment>Store collection of type-appropriate attributes, e.g. textarea needs rows/cols attributes
</comment>
181 <name>javascript
</name>
183 <title>Custom Field Javascript
</title>
185 <comment>Optional scripting attributes for field.
</comment>
189 <name>is_active
</name>
191 <title>Custom Field Is Active?
</title>
192 <comment>Is this property active?
</comment>
199 <title>Field is Viewable
</title>
201 <comment>Is this property set by PHP Code? A code field is viewable but not editable
</comment>
205 <name>options_per_line
</name>
206 <type>int unsigned
</type>
207 <title>Field Options Per Line
</title>
208 <comment>number of options per line for checkbox and radio
</comment>
211 <name>text_length
</name>
212 <type>int unsigned
</type>
213 <title>Field Length
</title>
214 <comment>field length if alphanumeric
</comment>
218 <name>start_date_years
</name>
220 <title>Field Start Date
</title>
221 <comment>Date may be up to start_date_years years prior to the current date.
</comment>
225 <name>end_date_years
</name>
227 <title>Field End Date
</title>
228 <comment>Date may be up to end_date_years years after the current date.
</comment>
232 <name>date_format
</name>
234 <title>Field Data Format
</title>
236 <comment>date format for custom date
</comment>
239 <callback>CRM_Core_SelectValues::getDatePluginInputFormats
</callback>
243 <name>time_format
</name>
244 <type>int unsigned
</type>
245 <title>Field Time Format
</title>
246 <comment>time format for custom date
</comment>
249 <callback>CRM_Core_SelectValues::getTimeFormats
</callback>
253 <name>note_columns
</name>
254 <type>int unsigned
</type>
255 <title>Field Note Columns
</title>
256 <comment>Number of columns in Note Field
</comment>
260 <name>note_rows
</name>
261 <type>int unsigned
</type>
262 <title>Field Note Rows
</title>
263 <comment>Number of rows in Note Field
</comment>
267 <name>column_name
</name>
269 <title>Field Column Name
</title>
271 <comment>Name of the column that holds the values for this field.
</comment>
275 <name>option_group_id
</name>
276 <type>int unsigned
</type>
277 <title>Field Option Group ID
</title>
278 <comment>For elements with options, the option group id that is used
</comment>
280 <label>Field Option Group
</label>
284 <table>civicrm_option_group
</table>
285 <keyColumn>id
</keyColumn>
286 <labelColumn>title
</labelColumn>
290 <name>option_group_id
</name>
291 <table>civicrm_option_group
</table>
294 <onDelete>SET NULL
</onDelete>
297 <name>serialize
</name>
298 <type>int unsigned
</type>
299 <title>Serialize
</title>
301 <comment>Serialization method - a non-zero value indicates a multi-valued field.
</comment>
303 <callback>CRM_Core_SelectValues::fieldSerialization
</callback>
306 <required>true
</required>
312 <title>Field Filter
</title>
314 <comment>Stores Contact Get API params contact reference custom fields. May be used for other filters in the future.
</comment>
318 <name>in_selector
</name>
320 <title>Field Display
</title>
322 <comment>Should the multi-record custom field values be displayed in tab table listing
</comment>
326 <name>UI_label_custom_group_id
</name>
327 <fieldName>label
</fieldName>
328 <fieldName>custom_group_id
</fieldName>
329 <unique>true
</unique>
333 <name>UI_name_custom_group_id
</name>
334 <fieldName>name
</fieldName>
335 <fieldName>custom_group_id
</fieldName>
336 <unique>true
</unique>