Wish all Are well
I m Trying to Developed a payroll app. which can be operated by any organization and their employee with QR and NFC and this system should be as easy that a less-educated security person can also operate and it should be less-step app like only one OR two-click operation.
i have already created structure and logic. but from the last day I stop at the date and time column.
many organization has two or three-shift, and their date is also changed after the last shift finished.
TABLE 1- “IN” , TABLE 2- “OUT”
1] last shift ends at 8.00 am, I want the initial date value trigger as per a specific time like today() date is today()-1 day after 12.00am to 8.00 am. or before this time value is as regular today(),
2] in the OUT table some time employees also duty out late then shift closed time but the date should be the same as per duty in date so that time I want a manual change date in same the above column that’s why I keep it as editable and initial. for this I add one more enum as the [previous day] when they hit this button date will ignore 1] formula and add today()-1.