Skip to main content


Create a Child Worksheet

This tutorial will teach us how to create a Child worksheet for student details. Our scenario is based on a school with 9 grades, each with a varying number of students. The parent worksheet contains information on each grade name and the number of students in each grade. The objective is to create a child worksheet named "Student Details," containing the Name and Age of each student. This child worksheet will be linked to the parent worksheet "School Grades."

In the "School Grades" worksheet, click the small arrow to proceed.

alt text

Create a Child Worksheet​

Click "Create Child."

alt text

Name the Worksheet​

Name the new worksheet to "Student Details."

alt text

Confirm Creation​

Click "Create" to finalize the new worksheet.

alt text

View the Child Worksheet​

The "Student Details" worksheet will open, displaying a parent field linked to "School Grades."

alt text

Add Fields to the Child Worksheet​

Begin adding additional fields to the "Student Details" worksheet. Add a field for the student's name and save it.

alt text

Add Age Field and Confirm​

Ensure that the "Name" and "Age" fields are added.

alt text

Add Records​

To add records to the child worksheet, click "Add."

alt text

Add Student to Grade One​

Add a student to grade one, which has 15 students.

alt text

Enter Student Details​

Input the details for a student, such as Divya, at age 6.

alt text

Save Record​

Save the student record.

alt text

Add Additional Students​

Click "Add" to include more students.

alt text

Enter Details for Additional Students​

Add details for another student in grade one, specifying an age of 5.

alt text

Review and Rename Parent Field​

Check the attached parent field and rename it if necessary.

alt text

Confirm Renaming​

Parent Field is a generated Name. Edit it to your choice.

alt text

Customize view of parent field​

Select which Parent Sheet "School Grades" fields to display in the worksheet. Let's choose Name Field only, which says Grade Names. You can select more than one field, which will be joined with space between fields for view purposes. For example, "Grade-1 15" means a name field and no. of student fields showing together with a space between them. To simplify, you can choose a Name for your reference.

alt text

Update Columns​

Click "Update" to finalize the column display.

alt text

Review the Worksheet​

Grade 1 now shows details for two students but can contain up to 15 records. These records are stored in the child worksheet "Student Details," linked to "School Grades." You can only enter some 15 records in 'School Grades' because it only allows one record per grade. That's why we use the child sheet 'Student Details' to store more records for all 15 students in grade 1, one by one. A child worksheet is useful when you need to create more than one record for specific data, such as school grades. Other worksheet examples could be Employees as parents, salaries as one child, and timesheets as another. And it is important to note that a Parent Sheet can have more than 1 Child Sheet.

alt text