# Tie Student to Parent User

**URL:** https://community.glideapps.com/t/tie-student-to-parent-user/71040
**Category:** Ask for Help
**Created:** [February 21, 2024, 11:03pm UTC](https://community.glideapps.com/t/tie-student-to-parent-user/71040 "2024-02-21T23:03:49Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![tkd\_hayden](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tkd_hayden/32/67200_2.png) [@tkd\_hayden](https://community.glideapps.com/u/tkd_hayden)
#### Post date: [February 21, 2024, 11:03pm UTC](https://community.glideapps.com/t/tie-student-to-parent-user/71040/1 "2024-02-21T23:03:49Z")

</div>

I’m new to Glide and working through figuring everything out. I was told that the best way to setup my system for what we want is to have an Admin input student/child info and then have people sign up for the app and tie them to one or more child/students.

This would allow for parent, aunt, teacher all to be able to input data for a single child and a parent to be able to be tied to multiple children as well.

Now my question is…how do I go about setting up the connection? Is there a way to pass on the unique Row ID for the student in a sign up email? Is there an easier way to tie a child to a parent as well as other?

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 22, 2024, 12:09am UTC](https://community.glideapps.com/t/tie-student-to-parent-user/71040/2 "2024-02-22T00:09:02Z")

</div>

Do those children have emails themselves? Will they ever log into the app?

---

<div class="post-metadata">

### Author: ![tkd\_hayden](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tkd_hayden/32/67200_2.png) [@tkd\_hayden](https://community.glideapps.com/u/tkd_hayden)
#### Post date: [February 22, 2024, 12:25am UTC](https://community.glideapps.com/t/tie-student-to-parent-user/71040/3 "2024-02-22T00:25:50Z")

</div>

No, they will not have emails or log in. But we may have multiple parents or family members who want to input info for each child.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 22, 2024, 12:34am UTC](https://community.glideapps.com/t/tie-student-to-parent-user/71040/4 "2024-02-22T00:34:43Z")

</div>

There must be a mechanism in there to let people “claim” a child profile, I guess, and you may have to let users add children on their own, otherwise it’s hard to scale.

The user that added children will be the only one who can verify it “claims” are valid or not.

I think that’s an option before you dive into the data structure.

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [February 22, 2024, 2:13am UTC](https://community.glideapps.com/t/tie-student-to-parent-user/71040/5 "2024-02-22T02:13:13Z")

</div>

Ya, there are a few ways to approach this, but you’ll want to provide families with a unique student code or QR code. By inputting/scanning the code, a parent will be able associate their user profile row to the child account. The _easiest_ way to do this is write a new record to a “parent-student association” table that includes both the user id and the student id, but it might not be scalable since many adults can be associated to the same child.

A leaner approach would be to write the student id to an array column in the user profile table, but this is a trickier setup. It involves using inline arrays using what we call the “Trebuchet method”. I plan on making a tutorial video on inline arrays as soon as Glide supports JSON in inline arrays.

Until then maybe a combo of these two videos will help:

This video uses a slightly outdated trebuchet setup, but the concept still works

> [@dizzy The Trebuchet Method](https://community.glideapps.com/t/the-trebuchet-method/48325):
>
> In certain situations, a single column has the potential to replace an entire table of data. The Trebuchet Method allows you to create an inline array that allows you to create a SIMPLE one-to-many relationship between two sets of data without the need of a log or submissions table. Examples: Who owns which item Who has registered for an event Who has completed which task Pros: no app bloat no additional rows of data fairly easy to set up Cons: Can only track one data point (eg. who has w…

> [@selfie Populate a Form by Scanning a QR Code](https://community.glideapps.com/t/populate-a-form-by-scanning-a-qr-code/69957):
>
> v Hey fellow Gliders! In this video, learn how allow users to scan a QR code to prepopulate a form screen using: point_right A helper table point_right A template column point_right Get Part of URL columns point_right Form container I’ve used this method to create scavenger hunt activities, inventory apps, onboarding functionality, and time card systems. There are several of variations you can do using this methodology (eg. use a form screen over a form container, create QR codes…
