Solved: How to set Clock-out should on the same date as Cl... - Page 2

romanus · 05-10-2020 10:41 PM

I made a presence app to record faculty members and other staffs activity during Covid19 WfH. I manage using form to capture timestamp, clock-in, location, photos, activities, and clock-out. I wish to set the clock-out should be on the same date as clock-in. Is it possible if user forgot to clock-out it will automatically clocked-out by app on 23.59. I do appreciate for any comment and suggestion. I search that it is not possible at the moment to use server/system side trigger action to accomplish this.

Suvrutt_Gurjar

Thank you for the updates.

Since you have [Clock In] and [Clock Out] as TIME type columns, I believe the earlier suggested valid_if expression will not work.

Instead you may set the expression [Date]=TODAY() in Editable_if constraint of [Clock In] and [Clock out] columns.

This will ensrue that the user can edit these values only if the record creation date is today.

I believe , if your column type is Time, your initial value can be simply an expression as TIME(“23:59:59”)

Since [Clock Out] will always have an initial value of “23:59:59” , you may have a slice expression something like

AND([Date]=TODAY(), [Clock Out]= TIME(“23:59:59”))

This will list all of today’s records where the user has yet not entered any other [Clock Out] time than the default initial time of “23:59:59”. Only lacuna of this slice filter expression is if a user has purposely entered [Clock Out] time of “23:59:59” , then also it will be included in the “Working Now” slice.

View solution in original post

How to set Clock-out should on the same date as Clock-in