Insert number into sort field.
I have a iQuery drag and drop script that works really well to re-order the rows in a database table, so I would like to use it for the "items" table management, to update the location of catalog items.
The only issue at the moment is that:
When entering a new record into the items table, I would like the next higher number in the sort field entered automatically.
I am doing it manually at the moment.
To further complicate the issue, I am using the "Multiple Record Inserts" behaviour.
It would be brilliant if this can be done