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:
Name | Address | Number of employees | Industry |
iTech | 3936 Melody Lane, Kilmarnock, VA 22482 | 25 | IT |
Shelly | 1744 Collins Street, Johnstown (Cambria), PA 15905 | 230 | Retail |
… |
Records of Employee type:
First Name | Last Name | Date of Birth | Position | Phone number | Company |
Jason | L. Snyder | 9/8/1967 | CTO | 217-234-8246 | iTech |
Whitney | J. Savage | 10/4/1985 | CFO | 714-355-3069 | Shelly |
… |
You can do the the following with the records: