Attendance App Recommendations

[MTZD]

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.

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!

[GrumpyRick]

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

[MTZD]

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.

[GrumpyRick]

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

[ThinhDinh]

Items in Array to separate row in another table

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.

[MTZD]

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

[MTZD]

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