What is a record?

What is a record?

Record is the main element of data structure. It is used to manage your information. A record contains information about a single object or entity. This information is stored in the corresponding fields of the record, each of which also has its own type.

Records are divided by type. Each type has its own set of fields that uniquely describe a particular entity or object.

Example

Suppose we need to store information about companies and their employees. To do this, we need to create two types of records: Company and Employee.

Records with type Company will contain the following fields:

  • Name (field type Text)
  • Address (field type Text)
  • Number of employees  (field type  Integer)
  • Industry (field type Single select)

Records with type Employee will contain the following fields:

  • First Name (field type Text)
  • Last Name (field type Text)
  • Date of Birth (field type  Date)
  • Position (field type Single select)
  • Phone number (field type Text)
  • Company (field type Link to record ) – field connecting records of type Employee with records of type Company.

After creating such a record structure, we can store information like this:

Records of Company type:

NameAddressNumber of employees  Industry
iTech3936 Melody Lane, Kilmarnock, VA 2248225IT
Shelly1744 Collins Street, Johnstown (Cambria), PA 15905230Retail
   

Records of Employee type:

First NameLast NameDate of BirthPositionPhone numberCompany
JasonL. Snyder9/8/1967CTO217-234-8246iTech
WhitneyJ. Savage10/4/1985CFO714-355-3069Shelly
     

You can do the the following with the records: