Record types
Every record in a project is one of its record types. Each type has its own list under Records, its own fields, and a column in exports so every row says which type it is.
Built in types
Every project has these, and they can’t be deleted:
- Participants: people who join and take part. Their record is made when they join.
- Team roles: Owners, Admins, Curators, Data entry and Billing contacts. Each member’s record is the type for their role. If their role changes, their record keeps its values and shows the new role’s fields.
Give them the fields you need. An admin might have a job title, and data entry staff who are clinicians might have a site, hospital and department.
Your own types
Add a type for anything else you keep data about: the trainings you run, each session of them, the teams in a staff survey, the sites in a service evaluation.
Adding a record type
When you create a project, the second step asks what you want to keep data about. You can add more later from Setup > Record types > Add a record type.
Pick a preset or choose Something else, name it yourself and pick an icon for it. You can change the icon later with Edit. The presets come with the fields people usually need:
- Trainings: topic, who it’s for, provider, format and learning objectives.
- Sessions: the training or event it belongs to, start and end, location, format, facilitators, how many signed up and how many attended, and a status.
- Events: start and end, venue, format, expected and actual attendance.
- People: email, role, organisation and team. Use this for people who don’t sign in, such as facilitators, managers or attendees. Your team and participants have their own records already, so they aren’t People.
- Teams: department, number of people and team lead.
- Sites: address and region.
- Samples: when it was collected, what kind it is and the site.
A project can have up to 30 record types of its own.
Choosing a type’s fields
Open a type from Setup > Record types to see its fields in order. From there you can:
- Add a new field, and tick any other types that should use it too.
- Add a field you already have, so the same field is shared across types. A facilitator field can sit on both workshops and events.
- Move fields up and down to set the order they appear in.
- Remove a field from the type. Values already recorded are kept, and the field stays on any other type that uses it.
The data dictionary lists every field in the project and which types use it. Change that from the field’s page under Used by.
Links between records
A link field points at records of another type. A session links to its training, so the training’s page lists every session under Linked records, and a session can link to several facilitators.
Preset links appear as soon as both types are in the project. If you add People after Sessions, sessions get their facilitators field then.
To add your own link, create a field, choose Link to a record as its type, then choose what it links to and whether it can link to more than one.
Other field types for record types
- Date and time: when something happens, such as a session’s start.
- List: several short items, such as a training’s learning objectives. Each item keeps its identity when you reword it.
Both work on any field, not only on record types.
Removing a record type
One of your own types can be deleted once it has no records. Fields only it used go with it, and shared fields stay on the other types. If a field links to it, remove that field first.