SugarCRM module fields definition snippets

en_us.lang.php

<?php

$app_list_strings['my_select_options']['value_1'] = 'Label 1';
$app_list_strings['my_select_options']['value_2'] = 'Label 2';
$app_list_strings['my_select_options']['value_3'] = 'Label 3';

?>

vardefs-checkbox.php

<?php
    'my_boolean_field' => array (
      // COMMON ATTRIBUTES
      'name'                      => 'my_boolean_field',
      'vname'                     => 'LBL_MY_BOOLEAN_FIELD',
      'required'                  => false,
      'type'                      => 'bool',
      'massupdate'                => 0,
      'comments'                  => '',
      'help'                      => '',
      'importable'                => 'true',
      'duplicate_merge'           => 'disabled',
      'duplicate_merge_dom_value' => '0',
      'audited'                   => false,
      'reportable'                => true,
      'size'                      => '20',
       
      // CHECKBOX
      'len'                       => '255',
    ),
?>

vardefs-dropdown.php

<?php
    'my_select_field' => array (
      // COMMON ATTRIBUTES
      'name'                      => 'my_select_field',
      'vname'                     => 'LBL_MY_SELECT_FIELD',
      'required'                  => false,
      'type'                      => 'enum',
      'massupdate'                => 0,
      'default'                   => '1',
      'comments'                  => '',
      'help'                      => '',
      'importable'                => 'true',
      'duplicate_merge'           => 'disabled',
      'duplicate_merge_dom_value' => '0',
      'audited'                   => false,
      'reportable'                => true,
      'size'                      => '20',

      // DROP DOWN
      'len'                       => 100,
      'options'                   => 'my_select_options',
      'studio'                    => 'visible',
      'dependency'                => false,
    ),
?>

vardefs-float.php

<?php
    'my_float_field' => array (
      // COMMON ATTRIBUTES
      'name'                      => 'my_float_field',
      'vname'                     => 'LBL_MY_FLOAT_FIELD',
      'required'                  => false,
      'type'                      => 'varchar',
      'massupdate'                => 0,
      'comments'                  => '',
      'help'                      => '',
      'importable'                => 'true',
      'duplicate_merge'           => 'disabled',
      'duplicate_merge_dom_value' => '0',
      'audited'                   => false,
      'reportable'                => true,
      'size'                      => '20',

      // FLOAT FIELD
      'len'                       => '18',
      'enable_range_search'       => false,
      'precision'                 => '8',
    ),
?>

vardefs-integer.php

<?php
    'my_integer_field' => array (
      // COMMON ATTRIBUTES
      'name'                      => 'my_integer',            // Field Name
      'vname'                     => 'LBL_MY_INTEGER_FIELD',  // System Label
      'required'                  => false,                   // Required Field
      'type'                      => 'int',                   // Data Type
      'massupdate'                => 0,                       // 
      'comments'                  => '',                      // Comment Text
      'help'                      => '',                      // Help Text
      'importable'                => 'true',                  // Importable : 'true', 'false', 'required'
      'duplicate_merge'           => 'disabled',              // Duplicate Merge : 'enabled', 'disabled'
      'duplicate_merge_dom_value' => '0',                     // 
      'audited'                   => false,                   // Audit
      'reportable'                => true,                    // 
      'size'                      => '20',                    // 

      // INTEGER 
      'len'                       => '255',                   // Max Size
      'enable_range_search'       => false,                   // 
      'disable_num_format'        => '',                      // 
    ),
?>

vardefs-multiselect.php

<?php
    'my_multiselect_field' => array (
      // COMMON ATTRIBUTES
      'name'                      => 'my_multiselect_field',
      'vname'                     => 'LBL_MY_MULTISELECT_FIELD',
      'required'                  => false,
      'type'                      => 'multienum',
      'massupdate'                => 0,
      'comments'                  => '',
      'help'                      => '',
      'importable'                => 'true',
      'duplicate_merge'           => 'disabled',
      'duplicate_merge_dom_value' => '0',
      'audited'                   => false,
      'reportable'                => true,
      'size'                      => '20',

      // MULTISELECT 
      'options'                   => 'my_multiselect_options',
      'studio'                    => 'visible',
      'isMultiSelect'             => true,
    ),
?>

vardefs-textarea.php

<?php
    'my_text_field' => array (
      // COMMON ATTRIBUTES
      'name'                      => 'my_text_field',
      'vname'                     => 'LBL_MY_TEXT_FIELD',
      'required'                  => false,
      'type'                      => 'text',
      'massupdate'                => 0,
      'comments'                  => '',
      'help'                      => '',
      'importable'                => 'true',
      'duplicate_merge'           => 'disabled',
      'duplicate_merge_dom_value' => '0',
      'audited'                   => false,
      'reportable'                => true,
      'size'                      => '20',

      // TEXTAREA
      'studio'                    => 'visible',
      'rows'                      => '3',
      'cols'                      => '20',
    ),
?>

vardefs-textfield.php

<?php
    'my_string_field' => array (
      // COMMON ATTRIBUTES
      'name'                      => 'my_string_field',
      'vname'                     => 'LBL_MY_STRING_FIELD',
      'required'                  => false,
      'type'                      => 'varchar',
      'massupdate'                => 0,
      'comments'                  => '',
      'help'                      => '',
      'importable'                => 'true',
      'duplicate_merge'           => 'disabled',
      'duplicate_merge_dom_value' => '0',
      'audited'                   => false,
      'reportable'                => true,
      'size'                      => '20',

      // TEXT FIELD
      'len'                       => '255',
    ),
?>