Sign in-out Sheet

AppSheet AppSheet Q&A
,
1

Hello,

I am trying to make a Sign in - out app for my mother’s preschool. Eventually I want to expand it’s functionality to include attendance and tracking of where the kids are, through transfer forms that the teachers can fill out, but for now i’m focusing on just getting the kids signed in and out. The idea seems simple but I have zero experience doing anything like this. I’ve been trying to figure it out on my own for two full days but I’ve made very little progress.

Currently, I’ve got a table for Students and Sign in Log.
Students table has columns for Student ID, First Name, Last Name, and “Present?”
Sign in Log table has columns for Action ID, Student ID, Student Name, Date, Time in, Signature in, Time Out, Signature Out.

The idea is this: Parents enter the school, go up to the counter and are greeted with a list of every student registered to the school, separated by classroom, and searchable. Once the parent finds their child and clicks on it, it opens the “Student Detail” page which pretty much just display’s the student’s name and has two options; a button for sign in and a button for sign out.

The “sign in” button is only visible if the child is absent (not signed in for the day) and similarly, the sign out button is only be visible if the child is present (has been signed in for the day.) The app knows this because the child’s status under the “Present?” column in the “Students” table is set to TRUE or FALSE
Clicking the “sign in button” brings up a form for the Sign in Log table. It currently has fields for the child’s name (pre-populated from the selection of the student in the earlier view), Date (TODAY ()), Time in (NOW ()), and a signature capture space. Parent signs, clicks save, and a record gets created for that child in the Sign in Log table. I’ve managed to figure up to this point. From here on is where I’m stuck. Once a child is signed in (the record is created in the Sign in Log table) I can’t get the “sign out” button to recognize that the child already has a record for the day and update the existing record with the time out and signature out details. Currently; clicking “sign out” only produces a new record rather than updating the remaining column for a record that already exists.

Also, the buttons recognize the status of the child from the “Present?” column in the Students table but only because I set those myself in the google sheet to begin with. I can’t figure out how to have the status changed via being triggered by a “sign in” (would change to TRUE) or a “sign out” (would change to FALSE)

Apologies for the wall of text, hopefully everything is clear…I appreciate any help.

2

Create an additional action button with a LINKTOROW deep link. Depending on today’s status, show the correct action with a condition rule. For the LINKTOROW action you would need to use MAXROW expression so you can know the record’s key column value for opening correct/ latest sign in record

3

Good day @shadowcat190 . How did you create buttons for Sign-in and Sign-out? I check students in and out for lunch and want to have a sign out button that automatically adds their name to a list with a timestamp for being out to lunch, then a sign in button that adds a separate timestamp for coming back (updating the list rather than creating a new record), I also want a button that triggers a timestamp that updates their record (or creates a new one if none exists) that records timestamp for leaving school for the rest of the day.