# How can change to next columns

**URL:** <https://community.glideapps.com/t/how-can-change-to-next-columns/15807>\
**Category:** Ask for Help\
**Created:** [September 15, 2020, 10:00am UTC](https://community.glideapps.com/t/how-can-change-to-next-columns/15807 "2020-09-15T10:00:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kien\_Trung\_Nguyen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kien_trung_nguyen/32/13587_2.png) [@Kien\_Trung\_Nguyen](https://community.glideapps.com/u/Kien_Trung_Nguyen)\
**Post date:** [September 15, 2020, 10:00am UTC](https://community.glideapps.com/t/how-can-change-to-next-columns/15807/1 "2020-09-15T10:00:34Z")

</div>

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:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3cc5f1ff83d20326df582fe72183c39ec62bfbbd.png)

For example:

1. 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.
2. 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.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 15, 2020, 10:06am UTC](https://community.glideapps.com/t/how-can-change-to-next-columns/15807/2 "2020-09-15T10:06:31Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Kien\_Trung\_Nguyen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kien_trung_nguyen/32/13587_2.png) [@Kien\_Trung\_Nguyen](https://community.glideapps.com/u/Kien_Trung_Nguyen)\
**Post date:** [September 15, 2020, 12:27pm UTC](https://community.glideapps.com/t/how-can-change-to-next-columns/15807/3 "2020-09-15T12:27:19Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 15, 2020, 12:28pm UTC](https://community.glideapps.com/t/how-can-change-to-next-columns/15807/4 "2020-09-15T12:28:36Z")

</div>

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.