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.
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
User | Count |
---|---|
42 | |
34 | |
26 | |
23 | |
15 |