We want the rows to be clubbed i.e. Start Absent Date to End Absent Date in Single Column Field instead of each Absent Day coming on separate row, making the table very long and useless in those case where Absent Dates are in sequence such as 1-12-2023, 2-12-2023, 3-12-2023, 4-12-2023, etc AND rest of COlumn values are empty/zero. (this is used to show Long Leaves Dates in single row in Salary Slip of an Employee where he is absent for equal/more than 3 days consecutively without any gap)
So, Condition will be → If Employee has no Checkins (IN & OUT both are NONE) and Working Hours is Zero for equal / more than 3 days, then the rows should be clubbed together in single line.
Pls refer to fig.
Salary Slip Print Format, where we want the Absent Dates to come in Single row clubbed
Instead of 3 rows, there should be SINGLE row with the below value in Absent Date Field.
value-> 01-12-2023 to 03-12-2023 (StartDate to EndDate in Single Row of COlumn Absent Dates, rest of the COlumns will be zero/null)
Note: frappe.get_list is Frappe function to get data.
Jinja Code attached. Pls check the jinja code in this post https://discuss.frappe.io/t/jinja-code-in-print-format-of-salary-slip/127219
Falah is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.