How do we insert above or below a particular row in grid?

Frappe Framework Custom Script
1

We want to allow the user to add a row below the existing row conditionally, from click of a custom button, instead of ‘Insert Above’/‘Insert Below’.

cur_frm.add_child adds a row at the bottom. We want the new row right below the current row and take care of indexing also.

Any pointers?

Thanks
Krithi

2
  • copy the child table docs into a variable
  • clear the original child table
  • populate the child table as you desire
  • refresh when done
3

I was looking at using the same event that is there in the core, to insert_above or insert_below. Wont that be possible?

Krithi

4

Good idea. That will work

5

I couldn’t find any explicit function to do that, need help there.

6

Even if conditionally you are able to add a row just below, the grid rows are draggable, so anyone can add any row and then drag it above or so. Wouldn’t that kinda kill the whole conditionality ?

7

Where is it draggable?

8

Take your pointer between the checkbox and the row no. , click on it and drag it up or down. The row number will adjust accordingly too

9

@Zlash65 drag to reorder doesn’t work for me. I am new to ERPNext and i thought this was not supported.
Is it just me? is there anyone else for whom it doesn’t work?

10

drag-to-move
Seems to be working for me ? Are we talking about something else perhaps ? This feature has been there since long though

1 Like
11

Doesn’t work for me either. Is this only in Doctype or all grids?

12

Hey,
Just figured out… it doesn’t work on chrome-ubuntu 16.04…
But it works on chrome-windows and firefox-ubuntu …

@krithi_ramani @Zlash65 can you please mentions your Browser and OS… so that we can confirm the issue is similar.

13

I don’t think thats the case @karthikeyan5 Prior to mac I had ubuntu and this used to work then too.
@krithi_ramani Its for all grids

14

when is “then”?
I guess a lot must have changed from “then” and “now”… Because chrome and frappe has had two major versions changes in the last 4 months…
can somebody else please confirm the issue exists in current versions?

15

As @Zlash65 claims worked for me provided this is current by your standards @karthikeyan5

frappe@erpnext:~/frappe-bench$ bench version
erpnext 9.2.23
frappe 9.2.24

trusty tahr aka 14.04 lts

frappe@erpnext:~/frappe-bench$ uname -a
Linux erpnext 3.13.0-79-generic #123-Ubuntu SMP Fri Feb 19 14:28:32 UTC 2016 i686 i686 i686 GNU/Linux

Chrome Version 60.0.3112.78 (Official Build) (64-bit)

16

Am on

erpnext 8.0.44
frappe 8.0.64

Chrome - Version 60.0.3112.113 (Official Build) (64-bit)

Linux ecapv7devremote 4.4.0-93-generic #116-Ubuntu SMP Fri Aug 11 21:17:51 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux

@Zlash65 I remember seeing this feature only in ‘Customize form’ in v6, but not after that.

17

Ok, In V9.2 , am able to drag the rows both in firefox and Chrome (Ubuntu). I should now rethink the design.

Thanks @Zlash65

18

Found it. On button click,

var grid_row = cur_frm.open_grid_row();
grid_row.insert(true, true);

would insert a row right below the current row and set the focus in the new row.

4 Likes