Skip to main content


Create a Child Worksheet

In this tutorial, we will learn 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."

Step 1​

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

alt text

Step 2​

Create a Child Worksheet​

Click on "Create Child."

alt text

Step 3​

Name the Worksheet​

Name the new worksheet to "Student Details."

alt text

Step 4​

Confirm Creation​

Click "Create" to finalize the new worksheet.

alt text

Step 5​

View the Child Worksheet​

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

alt text

Step 6​

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

Step 7​

Add Age Field and Confirm​

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

alt text

Step 8​

Add Records​

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

alt text

Step 9​

Add Student to Grade One​

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

alt text

Step 10​

Enter Student Details​

Input the details for a student, for example, Divya with an age of 6.

alt text

Step 11​

Save Record​

Save the student record.

alt text

Step 12​

Add Additional Students​

Click "Add" to include more students.

alt text

Step 13​

Enter Details for Additional Students​

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

alt text

Step 14​

Review and Rename Parent Field​

Check the attached parent field and rename it if necessary.

alt text

Step 15​

Confirm Renaming​

Parent Field is system generated Name, Rename it to your choice.

alt text

Step 16​

Customize view of parent field​

Select which fields of Parent Sheet "School Grades" to display in the worksheet. In this case lets choose Name Field only which says Grade Names. You can choose more than one field and it will be joined with space in between fields for view purpose. For Ex. "Grade-1 15" means name field and No. of student field showing together with a space in between. To simplify you can just choose Name for your reference.

alt text

Step 17​

Update Columns​

Click "Update" to finalize the column display.

alt text

Step 18​

Review the Worksheet​

Grade one 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't enter all 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. Child worksheet is useful when you need to create more than one record for certain data in this case school grades. Other examples could be Employees as parent and salaries as one child, timesheet as another child. One parent sheet can have more than one child sheet.

alt text