Fields

A database is made up of fields that can store information.

There is a wide range of field options available in the controlroom.co database system, all with customisable behaviour both within controlroom.co and in any website intergation.

Once you have added fields you can simply drag and dop them to reorder.

Options common to all fields:

  • Label
    • This text appears above or beside the field to identify it.
  • Label style
    • Options are bold, italic or CSS heading styles 1 to 6.
  • Width
    • The width of each field is relative to the size of the page.
    • ‘Normal’ width occupies half the available area on a computer screen and full width of a mobile screen
    • ‘Small’ is half normal width and ‘tiny’ is half small width.
    • ‘Large’ is three quarters width on a desktop screen and full width on mobile.
    • ‘Full’ is 100% width on all screens.
  • The ‘float’ option allows field less than full width to sit alongside eachother.
  • Initial value
    • This is the contents of the field by default, before the user adds any data.
    • The type of content you can enter for initial value is outlined below.
  • Compulsory
    • A compulsory field needs to be filled out before the form can be submitted or saved
  • Unique
    • Check this box to prevent more than one record having the same value for this field
    • You might use this for an email field to ensure no douplicates in a database
  • Show in index
    • This field value will be used in the database record listing so you can identify the record
    • You might want to use this for ‘name’ or ‘company name’
  • Field name
    • This is used in the source code to identify the field
    • It needs to be unique in any database
  • Action
    • The field can be completed automatically based on the data entered in other fields
    • Possible actions are
      • Hide field until
        • The field will be hidden from view until the selection condition is met
      • Check
        • This is a checkbox field that will be checked automatically when selected action occurs
      • Insert date
        • This is a date field, and the current date will be added when the selected action occurs
    • ‘when’ options are:
      • continually, meaning at any time
      • field is empty, meaning this action only occurs if the field has no current value
    • the conditions for this actions to occur are
      • if record matches
        • select a saved search
        • if a record is included in a search then the selected action is taken
      • or x is checked
        • select a checkbox field
        • when this field is checked the action will be taken