# 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:** 1
**Showing post:** 5

<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…

---

_[View the full topic](https://community.glideapps.com/t/tie-student-to-parent-user/71040)._
