List Order Plugin - Order row and update field

[fireplace]

Hi everyone, good day.

I got the order plugin working as per attached image.

Is there a way to update a field with a calculated value every time after a row is reordered? This is similar to how the Order ID (as order element) gets updated.

I have the following elements in the list:
1 . Job#
2. Order ID (as order element)
3. Duration
4. Completed Date (to be updated with calculated value)

Scenario:
A machine in a production line will run the jobs in sequence. The Duration is the time required to complete a job.

The value of the Completed Date of the first record (where Order ID =1) will be Today + Duration.
The Completed Date of the second record (where Order ID =2) would be Completed Date (of first record) + Duration. So on and so forth.

The Completed Date column will then get updated every time there is a re-ordering.

Can someone help? thank you for your time.

CS

 

[cheesegrits]

There's nothing in the order plugin at the moment which would help. That would require adding an option to the plugin to let you specify a query to be run after the re-ordering is complete. Which comes under "custom coding" rather than subscription support.

-- hugh

 

[fireplace]

Hugh, can you quote me the cost for the the "custom coding". Thank you.

 

[cheesegrits]

Probably less than $50. However, before I do this, you need to figure out if you can do what you need to do with just a query. I think you can, using a variation of the "correlated subquery" solution here:

http://stackoverflow.com/questions/13196190/mysql-subtracting-value-from-previous-row-group-by

So I suggest you figure out what the query needs to be, and test in in phpMyAdmin (or whatever).

-- hugh