Check In & Check Out in One Line Without Using Action Button

[IshwarG]

HI Team, I am building a Timesheet apps, as follows :

1. Taking Input (Check in & Check Out) using QR Code 

2. Check Out Comes if Check in is not Blank.

3. But  I am confuse to handle single row data . (i.e. Check in and Check Out in one rows and Calculate Total Hour Duration) but I don't want to press action button In Check-In Row. I want to scan QR and Take a Check-Out Input in Check-In Input Row.

How can I solve it. please guide me . Thanks in advance.

[franc]

hi @IshwarG 

if you want to calculate the duration, you can check the time expressions https://support.google.com/appsheet/answer/10107326?hl=en

if you want to record a check-out only if the check-in has been validated first maybe you could use the "Valid if" formula (of the check-our column) to check if the check-in is blank or not and, if it is missing, then you can throw an error to prevent the check-out being recorded.

hope this helps

[IshwarG]

@franc 

Thanks for your Reply......

Actually, 

I want Check-Out in Same Row of Check-In 

Example 

1.ID   2.Worker_ID  3.Check-In   4. Check-Out   5. Duration

when I Initialize the Form then 1st it fill all 1st 3 Column in a row,

then when the worker check-out then I want to fill Check-Out Column in Same Row of Check-In.

Example:

1.ID   2.Worker_ID  3.Check-In   4. Check-Out   5. Duration

dfi     1001           Dt & 08:00 Am     Dt & 05:00 Am   08:00 Hrs

Hope you understand my view point.

[franc]

if you want to go back to the same row to complete its values/observations, then you probably need LINKTOROW()

I'd suggest you to have a look at this APP in order to see examples of how to use deep linking within your app

https://www.appsheet.com/templates/How-to-link-between-different-parts-of-an-app?appGuidString=102df...