Hello AppSheet Users, I am trying to create ...

Hello AppSheet Users,

I am trying to create a simple โ€˜Clock Inโ€™ app.

I have a list of Students who each have a row in the app. Every row contains a column for the โ€˜Student Nameโ€™, the โ€˜Clock inโ€™ button (True/False), โ€˜Current Timeโ€™ and โ€˜Current Dateโ€™.

I would like it so that when a student presses Yes on the โ€˜Clock inโ€™ button, it saves the โ€˜Current Timeโ€™ as well as the โ€˜Current Dateโ€™ on a separate table under their name. The table is called โ€˜Logโ€™ which has a row for every student and keeps a log of every time a Student has clocked in.

How can I achieve something like this? Thanks in advance for any replies.

0 1 333
1 REPLY 1

Just have one table for now with the following columns and their types: Student Name = ENUM Clock In = Y/N Current Time = Time Current Date = Date

The user selects their name from the ENUM list

Initial_Value for Clock in [FALSE]

Initial_Value for Current Time IF([Current Time]=TRUE,Now(),"")

Initial_Value for Current Date [Current Date]=TRUE,Today(),"")

get that working then go for something more complicated

Top Labels in this Space