# Building with arrays

**URL:** <https://community.glideapps.com/t/building-with-arrays/66827>\
**Category:** Ask for Help\
**Created:** [October 7, 2023, 5:39pm UTC](https://community.glideapps.com/t/building-with-arrays/66827 "2023-10-07T17:39:26Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![nkatglide](https://avatars.discourse-cdn.com/v4/letter/n/839c29/32.png) [@nkatglide](https://community.glideapps.com/u/nkatglide)\
**Post date:** [October 7, 2023, 5:39pm UTC](https://community.glideapps.com/t/building-with-arrays/66827/1 "2023-10-07T17:39:26Z")

</div>

Hello,

I have an array with names and difficulties of classes. I needed to limit the array so the classes only repeat once.

 ![Screenshot 2023-10-07 at 10.36.09 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/b/5ba87b41933688c81041fda997e4cd505bf72178.png)

In the case below, each class should only be placed once, but because of multiple responses, its not.

Also wondering, how to pull up array values in different table.

Thank you

---

<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:** [October 7, 2023, 7:05pm UTC](https://community.glideapps.com/t/building-with-arrays/66827/2 "2023-10-07T19:05:30Z")

</div>

What are you planning on doing with the array. Usually the functionality dictates how the data should be structured. Don’t want to solve for the wrong problem.

---

<div class="post-metadata">

**Author:** ![nkatglide](https://avatars.discourse-cdn.com/v4/letter/n/839c29/32.png) [@nkatglide](https://community.glideapps.com/u/nkatglide)\
**Post date:** [October 7, 2023, 7:21pm UTC](https://community.glideapps.com/t/building-with-arrays/66827/3 "2023-10-07T19:21:17Z")

</div>

Hello,

I plan on using these values on a detail page for each class. For that I need each array to not repeat and that way I can send it to a different table and then display them.

Thank you

---

<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:** [October 8, 2023, 1:12am UTC](https://community.glideapps.com/t/building-with-arrays/66827/4 "2023-10-08T01:12:18Z")

</div>

So both of the elements in each array should contribute to the uniqueness of your solution?

So if I have “Advanced Algebra 2 - 3” and “AP Statistics - 3” is it ok?

I don’t really understand your use case. Why should they be unique and why is this configured as an array?

---

<div class="post-metadata">

**Author:** ![nkatglide](https://avatars.discourse-cdn.com/v4/letter/n/839c29/32.png) [@nkatglide](https://community.glideapps.com/u/nkatglide)\
**Post date:** [October 8, 2023, 2:20am UTC](https://community.glideapps.com/t/building-with-arrays/66827/6 "2023-10-08T02:20:36Z")

</div>

The arrays only use was to hold the data but that is not working properly either. The idea behind the screenshots was to average values from a google spreadsheet and then associate it to a class. Then using those values to send it to another table with the class pages. The problem is each response is creating another row, so for example, Advanced Algebra 2 is being repeated twice. That makes it a hassle to display and update for each class page.

In the end, the goal is to take values from the spreadsheet average them and associate them to a class. Then take it to a different tab.

---

<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:** [October 8, 2023, 2:49am UTC](https://community.glideapps.com/t/building-with-arrays/66827/7 "2023-10-08T02:49:13Z")

</div>

Why does it have to be “taken to a different tab”?

So what do you want to be unique here? The class name? And you want the average of some number for each class?

---

<div class="post-metadata">

**Author:** ![nkatglide](https://avatars.discourse-cdn.com/v4/letter/n/839c29/32.png) [@nkatglide](https://community.glideapps.com/u/nkatglide)\
**Post date:** [October 8, 2023, 3:00am UTC](https://community.glideapps.com/t/building-with-arrays/66827/8 "2023-10-08T03:00:57Z")

</div>

The other tab holds the class detail screens. I need the arrays to only contain one class so that there are no repetitions. For example, only having Advanced Algebra 2 display once.

---

<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:** [October 8, 2023, 3:03am UTC](https://community.glideapps.com/t/building-with-arrays/66827/9 "2023-10-08T03:03:21Z")

</div>

But circling back, why are there multiple Advanced Algebra 2 rows from the start? What exactly is that table storing?

---

<div class="post-metadata">

**Author:** ![nkatglide](https://avatars.discourse-cdn.com/v4/letter/n/839c29/32.png) [@nkatglide](https://community.glideapps.com/u/nkatglide)\
**Post date:** [October 8, 2023, 3:06am UTC](https://community.glideapps.com/t/building-with-arrays/66827/10 "2023-10-08T03:06:21Z")

</div>

The table is storing values taken from a spreadsheet connected to a google form. The reason there are repetitions is because its taking the users choice and then combining it with the class difficulty for that choice.c
