Google Sheet Data Update

Questions about Thunkable Web API's
,
1

sheet1
sheet11476×293 44.7 KB

sheet2
I have like this 2 google sheets. I added 2 butons in my app one of enter work and one of exit work. when a loged user click on enter button i can get datas from app on google sheet but i couldnt find way to when user clicked exit button get DateExit, TimeExit and LocationExit datas line of TurkishId. Someone can help me about this?

2

Hope we can help here, I may not be fully understanding, however. The process for writing data to DateExit, TimeExit, and LocationExit would be the same as for DateEnter, TimeEnter, and LocationEnter but with the updated column for each and the row id.

image
image768×285 45.9 KB

3

Thank you for reply @matt_conroy .
I changed my mind and now I’m creating a unique UserID for each user using the “random integer from 1 to 100” block in the math section, and I’m adding it to the first column in the “puantaj” sheet. When a user arrives at work in the morning, they press the entry button, and a unique UserID is created automaticaly in the timesheet. My problem is that when the user leaves in the evening and presses the exit button, I need to retrieve the exit data and put it into the relevant columns of the row corresponding to this unique UserID. However, I haven’t been able to achieve this.

4

My first idea would be to try using a Stored Variable for this. Assign the UserID to a stored variable when the UserID gets created. Then, when they press the exit button, you can use the UserID text to find the corresponding row number in the Google Sheet. Once you know the row ID, it should be simple to use the update value block to update the columns.
Because it’s a Stored Variable, the UserID should be saved in between user sessions on the app.

Someone posted a method to find the row number based on the contents of a known column recently, check out: How to get data for an individual user from a google sheet? - #4 by jakecohen120rpcjvw - the latest reply has a Youtube tutorial

Mind you, this only works if the UserID is a unique value. I’m not sure how your app would be used exactly, but a random number between 1 and 100 can run into issues. Perhaps you could use the ‘Seconds since 1970’ block to assing a UserID instead? This block is in the Device category.

5

Hello @Machinimush!
I used 1 and 1000000000 and used join in text and added with “-” users id number. So hard to people get same number for UserID. Actualy UserID using for that not right. we can say UUID for it. I already solved that problem in my app. when user created UUID(UserID) ive save that UUID in phone store database. When user clicked exit button call for row id from phone store database. Thank you for reply
Best wishes

6

Thanks for answering, I appreciate you.