Hi all,
I am creating an app for checking attendance, but I am confusing about how to specify a column to edit it.
My spreadsheet likes:
For example:
- When user opens the app, it gets the date of today (20/09) and check with name of columns, if they are the same, it will check attendance in this column by choice component.
- If the day is different, the choice component will be invisible.
I’m a newbie and I don’t know how to do like that. Please help me, thank you very much.
Hi Mr. Kien, from a fellow Vietnamese!
I think the better setup would be having a form to submit the signed-in user’s email/phone and timestamp to a new sheet, then use formula to bring that back to the Sheet you want to display attendance check, I would imagine in checkboxes style.
Hi Mr. Thinh, thks for your reply.
Your sussgestion is a good idea for adult but children. Our classes are kids, a teaching assisstant will check them follow the list students. So it is dificult to write on column with date.
1 Like
You can capture those information automatically using the Special component.
Anh ơi trong mỗi form button mình có các component: current date & time và signed-in user’s email, anh có thể dùng các component trên để tự động thêm thông tin vào các cột cần thiết nha anh.
1 Like