The row ordering is done according to the chosen sorting column (first one / wdt_ID by default). You can define a column for positioning (e.g. ‘pos’, as integer, with values 1, 2, 3), and use it as a default sorting column.
Are you suggesting adding another column with integers as sorting column, and then edit/change the numbers to change positions of rows? Is there no drag and drop interface?
Ok, so I did that. It works, not perfect, since if I enter a same number from middle of the table it inserts the row after it, but does not rearrange the numbers. But its manageable.
My question is, how when creating new row, the number will always be the last + 1 , and then the user may change it if he needs to. But there must be a number and I can't ask the client to llok what is the last rows number and to enter it +1.
My question is, how when creating new row, the number will always be the last + 1 , and then the user may change it if he needs to. But there must be a number and I can't ask the client to llok what is the last rows number and to enter it +1. - Maybe you can try to set auto increment for this number, but if user will change this number then it can mess up this column.
I do not seem to find a way to:
1) Create new row at specific position, lets say, for example, as first row of table.
2) Move existing row to another place like higher or lower than it is.
Thanks
Hi Dima,
Thank you for your purchase.
The row ordering is done according to the chosen sorting column (first one / wdt_ID by default). You can define a column for positioning (e.g. ‘pos’, as integer, with values 1, 2, 3), and use it as a default sorting column.
Are you suggesting adding another column with integers as sorting column, and then edit/change the numbers to change positions of rows? Is there no drag and drop interface?
Hi Dima,
Yes I suggest you to add integer sorting column as a workaround because unfortunately we don't have drag and drop feature at this moment.
Ok, so I did that. It works, not perfect, since if I enter a same number from middle of the table it inserts the row after it, but does not rearrange the numbers. But its manageable.
My question is, how when creating new row, the number will always be the last + 1 , and then the user may change it if he needs to. But there must be a number and I can't ask the client to llok what is the last rows number and to enter it +1.
Thanks
Hi Dima,
My question is, how when creating new row, the number will always be the last + 1 , and then the user may change it if he needs to. But there must be a number and I can't ask the client to llok what is the last rows number and to enter it +1.
- Maybe you can try to set auto increment for this number, but if user will change this number then it can mess up this column.