Attendence mannagement app

I need help… I have made an attendence app for ten people and connected it with google sheets. I have made the names using check box but i want to how should write the block so when i check a box and submit the “present” writtent text should come in sheets and when i dont check the box it should write absent… i want to know the blocks.

This is just simple matter, if check box cheked then use "present " else “absent”

Have you tried anything?

Hi. Yes i have solved that issue but then im stuck with another. That when i eneter the data… its not in one line it goes up and down and in wrong columns. MY DISCORD IS 22727#5937 message here so i can talk to u and take some help.