ContributionsMost RecentMost LikesSolutionsRe: Re-order rows in grid via drag-and-drop and then auto-save the orderMark, Thanks for your response. That is not going to work. Kanban report type requires a multiple choice or User data type. There are scenarios where I need to re-order the line items of an invoice without having to either delete each line item and re-enter them or having to add an "order" column of numeric type and then sorting by that column. Would be really great if QuickBase allows that. That link I posted did just that but doesn't have the capability to save the order. Can this be placed on the product roadmap? ------------------------------ Alex Yu ------------------------------ Replenishing QOH - Subtracting units from one Table based on entry into another TableI was reading this post about Subtracting units from one Table based on entry into another Table regarding Inventory and Orders and getting the QOH formula field calculated. My question is if I replenish the starting inventory, e.g., 100, how can I reset the QOH to be the same as that as the starting inventory? Currently the QOH is calculated as the difference between the starting inventory from the parent table minus the total Orders in the child table. Here is the post I found that allowed me to be able to calculate the QOH: https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=3663f84a-a355-4743-bbe7-10f5a2503b64&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer Subtracting units from one Table based on entry into another Table --> OR <--- Just allow me to deduct the starting inventory when an order is placed. There is a video on youtube.com this is similar to the solution I'm looking for, except QuickBase's interface has changed as it removed the trigger portion and called it Actions instead of Automation. The video only shows the option to copy values. I need an option to write a formula expression to deduct the starting inventory by the order quantity to result in OOH. That way, I can reset the QOH without worrying about the formula -numeric field. Can this be done? Can you provide instructions to do this? Here is the youtube video Using a QuickBase Automation to Update a Field in a Related Table - YouTube https://www.youtube.com/watch?v=fgwAiRuWnCI Thanks in advance for your help. ------------------------------ Alex Yu ------------------------------Re-order rows in grid via drag-and-drop and then auto-save the orderDoes QuickBase have an out-of-the-box way to re-order the rows in the grid with drag and drop and then save the new order afterwards? I found this link that does that but lacks the function to automatically save the re-order. This is a requirement for me from my customer. : Auto re-order steps in a process | Discussions (quickbase.com). In this demo you candrag and droprows of a report to reorder the records:. QuickBase Bloggers https://haversineconsulting.quickbase.com/db/bmguzsp87?a=td Pastie Database https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=543 A little additional code could be used to add a new row or you could add a new row before invoking thedrag and dropsolution. If you want help with this feel free to contactmo_an the ultimatenext week using the information in my profile: http://getsatisfaction.com/people/dandiebolt ------------------------------ Alex Yu ------------------------------