Database and Form design in ActivityInfo
Welcome to the course “Database and Form design in ActivityInfo”. This is a compilation of various sessions for professionals interested in designing databases and forms in the platform.
These are free training sessions provided by the ActivityInfo team.
Are these sessions for me?
- Are you responsible for designing an information management/data collection system for your project or organization?
- Do you want to understand key functionalities that will help you build more advanced databases?
Then, get started with these sessions!
Working with related data
During this one hour session, we discuss best practices for managing related data in ActivityInfo. We will look into key features related to reference data including the latest developments in the platform. In summary, we discuss:
- Subforms versus reference forms: context, common cases and best practices
- Formulas and reference fields
- Record overviews with Reverse reference fields
- Duplicating reference datasets for quicker database creation
Enhancing data entry efficiency
During this session, we look at how you can ensure efficient data entry using a variety of functionalities available in form design in ActivityInfo.
In summary, we discuss:
- Relevance rule and formulas
- Validation rules and formulas
- *Subsections for organizing data entry forms
- Unique field constraints versus Key fields
- Default values and the Read Only property
- NOW function and timestamps
- Locking data entry