# Extract Data and Update **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner, data-viewer, google-sheets\ **Created:** [July 6, 2024, 5:17pm UTC](https://community.thunkable.com/t/extract-data-and-update/3088677 "2024-07-06T17:17:29Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![IJohnKennady](https://avatars.discourse-cdn.com/v4/letter/i/dec6dc/32.png) [@IJohnKennady](https://community.thunkable.com/u/IJohnKennady)\ **Post date:** [July 6, 2024, 5:17pm UTC](https://community.thunkable.com/t/extract-data-and-update/3088677/1 "2024-07-06T17:17:29Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/f/3f1dc94f7ed62924a601b6973feb7db903296646.png) i have data like this… in that data have 2 admin users. ( User 1: [123@te.com](mailto:123@te.com) and User2: [321@te.com](mailto:321@te.com)) when the User 1 will login it will show how many data’s match User 1 id ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/c/6c317c2934f692a34263fc4ec432d221eebfefef.png) and this my code block ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/7/2702a2e2f1d28bcef6032162c121476311a5e486.png) after when i click any one data “Janani S” the current date and time will update “day1-in” column when i swipe left it will remove the data Need Help!!! ---
**Author:** ![IJohnKennady](https://avatars.discourse-cdn.com/v4/letter/i/dec6dc/32.png) [@IJohnKennady](https://community.thunkable.com/u/IJohnKennady)\ **Post date:** [July 6, 2024, 5:23pm UTC](https://community.thunkable.com/t/extract-data-and-update/3088677/2 "2024-07-06T17:23:03Z")
One more query, if “day1-in” filled after 5:00 hours when i click data “Janani S” the current date and time will fill “day1-out” column Its like Student attendance When the “Janani S” add the “day1-in” its disable click until the swipe left ---
**Author:** ![domhnallohanlon](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/domhnallohanlon/32/29554_2.png) [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)\ **Post date:** [July 8, 2024, 10:39am UTC](https://community.thunkable.com/t/extract-data-and-update/3088677/3 "2024-07-08T10:39:27Z")
> [@IJohnKennady](#): > > Its like Student attendance Are you looking for help in building a student attendance app @IJohnKennady? > [@IJohnKennady](#): > > i have data like this… Is there any specific requirement that your data be in this format? If you can change the structure it differently then you can make you life a lot easier. * * * Finally, and most importantly, is Google Sheets the right option for your project? How many teachers will you have and how many students are you expecting to have? This is probably the main limiting factor that will determine the best backend to go with. ---
**Author:** ![IJohnKennady](https://avatars.discourse-cdn.com/v4/letter/i/dec6dc/32.png) [@IJohnKennady](https://community.thunkable.com/u/IJohnKennady)\ **Post date:** [July 11, 2024, 2:44pm UTC](https://community.thunkable.com/t/extract-data-and-update/3088677/4 "2024-07-11T14:44:49Z")
its not a student attendance, its Faculty attendance, the logic we have trainers, each trainer to teach 40+ faculty members, when A trainer login, they teach specific program, and same as B and C and its 2 - 7 Days program, based on course But in our case database we using MongoDB and SQL ---
**Author:** ![domhnallohanlon](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/domhnallohanlon/32/29554_2.png) [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)\ **Post date:** [July 11, 2024, 2:55pm UTC](https://community.thunkable.com/t/extract-data-and-update/3088677/5 "2024-07-11T14:55:47Z")
> [@IJohnKennady](#): > > But in our case database we using MongoDB and SQL got it - so do you need to use an API here rather than Google Sheets? ---
**Author:** ![IJohnKennady](https://avatars.discourse-cdn.com/v4/letter/i/dec6dc/32.png) [@IJohnKennady](https://community.thunkable.com/u/IJohnKennady)\ **Post date:** [July 18, 2024, 3:40pm UTC](https://community.thunkable.com/t/extract-data-and-update/3088677/6 "2024-07-18T15:40:37Z")
Yes, anyone Guide me ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\ **Post date:** [October 16, 2024, 3:41pm UTC](https://community.thunkable.com/t/extract-data-and-update/3088677/7 "2024-10-16T15:41:35Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.