# Attendance App Recommendations

**URL:** <https://community.glideapps.com/t/attendance-app-recommendations/80750>\
**Category:** Ask for Help\
**Created:** [March 14, 2025, 5:07pm UTC](https://community.glideapps.com/t/attendance-app-recommendations/80750 "2025-03-14T17:07:23Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![MTZD](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mtzd/32/85683_2.png) [@MTZD](https://community.glideapps.com/u/MTZD)\
**Post date:** [March 14, 2025, 5:07pm UTC](https://community.glideapps.com/t/attendance-app-recommendations/80750/1 "2025-03-14T17:07:23Z")

</div>

Hi Everyone,

This is my first time posting in this community, and I’m a very novice Glide user (3 or so months in).

I’m building an attendance app for my school. I need to log a date choice, attendance taker name, event attendance is taken in, and the names of all the students who may be absent for the event.

I then need to send those individual student names into another table, creating new rows for each name indicated as absent. The row also needs to contain all the other information logged for the event (date, taker name, event, etc.).

In my existing form, I’m using a choice option and allowing for multiple selections. This creates an array of names along with the event information in a table.

 ![Screenshot 2025-03-14 at 11.05.30 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/f/1f2720ab632591b3fa5e23b62abb16d996f20eb1.png)

What would your suggestions be to parse the array and create individual new rows associated with each name and include the event information in a new table?

Thanks in advance, all those wiser than I!

---

<div class="post-metadata">

**Author:** ![GrumpyRick](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grumpyrick/32/18079_2.png) [@GrumpyRick](https://community.glideapps.com/u/GrumpyRick)\
**Post date:** [March 14, 2025, 6:13pm UTC](https://community.glideapps.com/t/attendance-app-recommendations/80750/2 "2025-03-14T18:13:26Z")

</div>

Probably best to turn the data in json format and use the Glide API to create rows for each student.

---

<div class="post-metadata">

**Author:** ![MTZD](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mtzd/32/85683_2.png) [@MTZD](https://community.glideapps.com/u/MTZD)\
**Post date:** [March 14, 2025, 7:33pm UTC](https://community.glideapps.com/t/attendance-app-recommendations/80750/3 "2025-03-14T19:33:37Z")

</div>

Thanks @GrumpyRick! Unfortunately, my institution is not so interested in upgrading to the business plan… which I think is the only way to use the Glide API… Blarg.

---

<div class="post-metadata">

**Author:** ![GrumpyRick](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grumpyrick/32/18079_2.png) [@GrumpyRick](https://community.glideapps.com/u/GrumpyRick)\
**Post date:** [March 15, 2025, 12:03am UTC](https://community.glideapps.com/t/attendance-app-recommendations/80750/4 "2025-03-15T00:03:40Z")

</div>

Can still be done but would need to use something like Make or Zapier.

---

<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:** [March 15, 2025, 12:22am UTC](https://community.glideapps.com/t/attendance-app-recommendations/80750/5 "2025-03-15T00:22:33Z")

</div>

> [@Items in Array to separate row in another table](https://community.glideapps.com/t/items-in-array-to-separate-row-in-another-table/74193/17):
>
> With webhook triggers and loops, you can do it like this, as an on-submit action: Add a webhook workflow, copy the webhook URL. Add an on-submit action, use a trigger webhook action and send over the rowID of the quote request, and the comma-delimited list of items. Use two query steps to query the request ID and the items list from the body of webhook payload. Use a split text module to split the list of items. Loop through that, and add them to your helper table of items, with the same reque…

It does sound some what like this approach.

---

<div class="post-metadata">

**Author:** ![MTZD](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mtzd/32/85683_2.png) [@MTZD](https://community.glideapps.com/u/MTZD)\
**Post date:** [March 15, 2025, 2:32pm UTC](https://community.glideapps.com/t/attendance-app-recommendations/80750/6 "2025-03-15T14:32:52Z")

</div>

@GrumpyRick I will check both of those options out. Thanks!

---

<div class="post-metadata">

**Author:** ![MTZD](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mtzd/32/85683_2.png) [@MTZD](https://community.glideapps.com/u/MTZD)\
**Post date:** [March 15, 2025, 2:33pm UTC](https://community.glideapps.com/t/attendance-app-recommendations/80750/7 "2025-03-15T14:33:42Z")

</div>

@ThinhDinh Thanks! Interesting. I’ll mess around with that and see what I can make happen.

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [March 26, 2025, 6:27pm UTC](https://community.glideapps.com/t/attendance-app-recommendations/80750/8 "2025-03-26T18:27:51Z")

</div>

> [@MTZD](#):
>
> I then need to send those individual student names into another table, creating new rows for each name indicated as absent. The row also needs to contain all the other information logged for the event (date, taker name, event, etc.).

What is the reason for wanting to duplicate the data from one table to another.

---

<div class="post-metadata">

**Author:** ![MTZD](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mtzd/32/85683_2.png) [@MTZD](https://community.glideapps.com/u/MTZD)\
**Post date:** [March 26, 2025, 9:53pm UTC](https://community.glideapps.com/t/attendance-app-recommendations/80750/9 "2025-03-26T21:53:09Z")

</div>

Thanks for the reply @nathanaelb!

The whole app is being used for attendance purposes and also to track what we call dings, which are like points that a student accumulates for various reasons in various spaces.

So in one part of the app, a user logs dings one by one for individual students. The cumulative data (ex. How many total dings a student has and the details for each individual ding) is then displayed in a few different ways depending on user roles.

For this attendance portion, I am looking to input absences (which also count as dings) but for many students at once (could be up to 75). Ideally, I would want to have a user be able to rapidly submit individual student absences in a single table, creating individual rows within that table with each submission. This would, ideally, be the same table as the rest of the dings being logged.

So to answer your question: It doesn’t have to be info duplicated in another table.

I still haven’t played with webhook options suggested by ThinhDinh, and am open to other suggestions!

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [March 27, 2025, 2:23pm UTC](https://community.glideapps.com/t/attendance-app-recommendations/80750/10 "2025-03-27T14:23:56Z")

</div>

It would be interesting to know what tables you have in your database (data editor) with what basic columns.

It would also be interesting to see some sort of diagram of your data, such as an entity-relationship diagram, to get an idea how the tables relate.

Starting with a solid database architecture makes building easier. And starting with an unsound database architecture makes building much more difficult.

I ask because there is no point parsing arrays and copying data from one table to another if the architecture of your database doesn’t play in your favor.

---

<div class="post-metadata">

**Author:** ![MTZD](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mtzd/32/85683_2.png) [@MTZD](https://community.glideapps.com/u/MTZD)\
**Post date:** [March 27, 2025, 3:38pm UTC](https://community.glideapps.com/t/attendance-app-recommendations/80750/11 "2025-03-27T15:38:57Z")

</div>

Thank you. Let me see what I can put together and get back to you!
