172 questions
2
votes
2
answers
120
views
Running total for stock left for each month
I want to find out the stock of each product for each month as it comes into the warehouse. Here is how far I got
MonthNumber
Year
work_area
product_id
quantity
running_total
1
2025
NULL
NULL
NULL
...
- 628
0
votes
0
answers
69
views
How to get advanced details of users from zktecho device
I am using qr-zklib in my Node.js application. When I fetch users, I only receive the following details: uid, role, password, name, cardno, and userId.
However, when I check my ZKTeco UFace 900 device,...
0
votes
1
answer
62
views
segmented monthly snapshots of validly eligible user counts
I've been trying to figure out a SQL (in postgresql) query for a cohort-type analysis at work and can't figure this one out for the life of me.
I need a snapshot count of the number of valid users at ...
4
votes
6
answers
232
views
A mathematical way to divide overlapping time ranges into hours
I am trying to solve a problem of "labor tickets" - where each ticket can have a clock in and clock out time.
But, if multiple tickets overlap, the time should be distributed proportionally.
...
- 99
1
vote
1
answer
85
views
How can I get an array of all overlapping date ranges across a given set?
I am using fullcalendar.io JS library to visualize the bookings on my rental company. I store the motorbikes as arrays of categories (engine sizes) with a children array containing all the motrobikes ...
- 13
0
votes
1
answer
85
views
Currently, i'm working on attendance part which user can clock in and clock out
So supposedly, when user open the system only the clock in button enable, while clock out button disable. when user clicks on the clock in button, the button will be disabled and clock out button ...
- 1
-1
votes
2
answers
57
views
status table for all entries (even in different dates) in database changing value when all checkboxes are checked
i was testing for an attendance website, logging attendance on different dates (manually changing the date on my device) i have a status column 1 for present and 0 for absent. when i log an attendance ...
0
votes
1
answer
43
views
Filter a range to get a pivot like result
I want to filter a range of attendance in Google Sheet where the result will show the only the dates where the employee did Overtime in one column and the number of OT hours of the employee on the ...
1
vote
1
answer
1k
views
How to integrate ZKTeco K40 attendance device with Salesforce
I want to integrate my integrate my Salesforce Org to this Attendance device to store all the attendance records.
I am already familiar with socket based PHP libraries and SDKs but I am required to ...
- 11
0
votes
1
answer
76
views
SQL Server Attendance Time In Time Out Issue
I am making time in time out attendance system. Example table i have i am just trying to set the value in first right in time and very right time out then i have calculated easily other entries are ...
- 11
0
votes
0
answers
122
views
User's Location not matching with current location
App Description:
The AttendanceApp in React Native stores the user's location and status (IN/OUT) in AsyncStorage with the default status as OUT. On opening the app, the user sees a Check In button ...
0
votes
1
answer
76
views
SetInterval doesn't take the exact time which was specified
I have been trying to create an attendance system that prompts a user for check-in and check out. Based on the input given, I have assigned a value time which increments by 1 after 1000 milliseconds(...
2
votes
1
answer
2k
views
Getting a list of header columns where the value is true
I apologise if this question appears simple, but I'm having trouble making it work.
I just want to know what days were each employee absent in the column G (the last column), for example I want it ...
user16580724
0
votes
1
answer
883
views
Creating Time In and Out in Flutterflow
Is there a way how can I create a time in / out in flutterflow? What actions do I need to add? Thank you here's a screenshot of my app created in flutterflow.
0
votes
0
answers
289
views
Attendance Sheet in Google Sheets Using forms
This is a pseudo code for my excel work
IF sheet1(column(range)).value IS Exit in sheet2(column(range)).value on specific(date) in sheet2(column(range)).value(date) Then print "P" Else ...
0
votes
1
answer
280
views
Excel Auto Attendance sheet
im trying to make an automatic attendance sheet here are the details:
-Data will be imported in the excel sheet (left side)
-I want to automatically mark "p" or "a" a specific cell ...
0
votes
0
answers
145
views
Google sheet multi list attendance - optimal solution?
I am trying to make one sheet with multiple lists for attendance tracking. Each list has a specific task/group like so:
Master list: all members with their contact info and attendance scores for each ...
- 1
1
vote
0
answers
386
views
Read user fingerprint and assign to user - zk
I am using php zklib to manage zk time attendance machine.
I am able to connect to device.
What I need is I want to add a new user to the machine from system, I can add the user information using ...
- 3,356
0
votes
2
answers
288
views
How to separate clock in and out from 1 same column in PHP
I have a little problem with the attendance machine in my office. I want to separate the time in and out which are in 1 column. I've tried so many queries in two weeks and i can't get what i want. I ...
- 1
1
vote
1
answer
1k
views
How can I get absent days from ZKTeco device?
I have a ZKTeco K80 device, what I can get now are the logs data ( DateTime, InOut, VerifyMethod..)
private void btnPullData_Click(object sender, EventArgs e)
{
try
{
...
user14743092
1
vote
1
answer
995
views
How can I check student attendance in recurring google meet's?
I want to check the students attendance for all google classroom courses. As the meeting_code will be the same for each course (recurring), how can I figure out the attendance for each meeting? Which ...
- 31
0
votes
1
answer
5k
views
Is there a Discord bot to check attendance to an event in the server?
I'm looking into hosting an academic event in Discord. I need a bot that can check the presence of the enrolled in each activity, an activity being to watch seminars and alike through discord ...
- 41
-2
votes
1
answer
724
views
SQL Time Attendance Query
Recently I made a switch from MS Access to SQL Server. Due to this switch I am having issues with making one SQL query to work.
This is how the current table looks like in SQL.
This is what I am ...
- 21
0
votes
0
answers
199
views
view sql produced by crystal reports
I am developing reports for a system using Workforce Time and Attendance. The system uses an Oracle database, Crystal Reports, and (I think) Business Objects. My reports use parameters. I want to ...
- 3,163
0
votes
1
answer
216
views
Kizala response time in attendance card is not accurate when mark attendance
Kizala response time in attendance card is not showing accurate time with mark attendance.
For instance, when I mark attendance at time 11: AM, it shows in the report 9:07 AM.
Where can be the ...
