Dynamically sorting Timesheet Detail

ERPNext Customize ERPNext
1

Hi, just to know if there is an easy way to sorting dynamically rows in timesheet detail, here sorting by date (from_time), ascending.

Capture02
Capture021005×225 12.6 KB

2

I’m interested … ( I know there would be a “hard” way by just programatically taking the entries, deleting them and then inserting them in the right order)

3

Hi, indeed, there must be an hard way to prgramming but I’m sure that’s also an easy way … (hoping ;))

4

Hi, by custom server script, I think it’s possible. I will keep you posted if I find something

5

Hello,

You can set the idx using frappe.model.set_value. (e.g. frappe.model.set_value('Timesheet Detail', 'New Timesheet Detail 1', 'idx', 1);)

Once you are done modifying the idx, do cur_frm.refresh_field('<table_name>');

For this case, you may want to sort it first and iterate over the sorted timesheet detail, modifying the idx.

Regards,

Ivan

6

Thank you for your reply. I’m going to try.

7

Works great for me :wink: Thank you very much for your help