@Anonymous ,
OnChange code -
//Get PayrollData from database
ClearCollect(
PayrollData,
'GetPayrollDataNew'.Run(
dtpkWeekOf.SelectedDate,
Last(LoginDetails).EmployeeId
)
);
//Check if time entry data already exists in database
If(
IsEmpty(PayrollData),
UpdateContext({record: "new"}),
UpdateContext({record: "old"})
);
//Check if Timesheet is Approved or not
ClearCollect(
HoursApproved,
Blank()
);
If(
!IsEmpty(PayrollData),
ForAll(
PayrollDataNew,
If(
PayrollDataNew[@Approved] = true,
Collect(
HoursApproved,
{Apprd: 1}
)
)
)
);
//Check if Timesheet is Submitted or not
ClearCollect(
HoursSubmitted,
Blank()
);
If(
!IsEmpty(PayrollData),
ForAll(
PayrollDataNew,
If(
PayrollDataNew[@Submitted] = true,
Collect(
HoursSubmitted,
{Submit: 1}
)
)
)
);
//Create a new dummy record to populate the gallery if timesheet doesn't exists in the database
If(
IsEmpty(PayrollData),
ClearCollect(
PayrollData,
{
PayrollHoursId: 00,
EmployeeId: Last(LoginDetails).EmployeeId,
EmailAddress: Last(LoginDetails).EmailAddress,
ProjectDetailId: 0,
TaskName: "--Select--",
WeekOf: Text(
dtpkWeekOf.SelectedDate + Time(
0,
0,
0
)
),
DayOneDate: Text(
dtpkWeekOf.SelectedDate + Time(
0,
0,
0
)
),
DayOneHours: 0,
DayOneNote: "",
DayTwoDate: Text(
dtpkWeekOf.SelectedDate + 1 + Time(
0,
0,
0
)
),
DayTwoHours: 0,
DayTwoNote: "",
DayThreeDate: Text(
dtpkWeekOf.SelectedDate + 2 + Time(
0,
0,
0
)
),
DayThreeHours: 0,
DayThreeNote: "",
DayFourDate: Text(
dtpkWeekOf.SelectedDate + 3 + Time(
0,
0,
0
)
),
DayFourHours: 0,
DayFourNote: "",
DayFiveDate: Text(
dtpkWeekOf.SelectedDate + 4 + Time(
0,
0,
0
)
),
DayFiveHours: 0,
DayFiveNote: "",
DaySixDate: Text(
dtpkWeekOf.SelectedDate + 5 + Time(
0,
0,
0
)
),
DaySixHours: 0,
DaySixNote: "",
DaySevenDate: Text(
dtpkWeekOf.SelectedDate + 6 + Time(
0,
0,
0
)
),
DaySevenHours: 0,
DaySevenNote: "",
Submitted: false,
Approved: false,
Pulled: false,
New: true
}
)
);
Logout button OnSelect code -
Clear(PayrollData),
Clear(PayrollDataNew),
Clear(HoursApproved),
Clear(HoursSubmitted),
Back()
