Skip to main content
Question

Queue Prioritization

  • April 14, 2020
  • 0 replies
  • 134 views

What is the best way to handle this sort of manufacturing scenario in Quick Base?

  • We have jobs that come in for a manufacturing run. Each job can be anywhere from an hour to multiple days
  • We can have anywhere from 2 days worth of jobs queued at any time up to a couple of months of backlog.
  • We need a way to prioritize jobs easily based on incoming new jobs and a number of other real-time factors that happen throughout the day. This is done manually by the manager.
  • Currently, the jobs are stored in an Excel file and the user cuts and pastes rows to re-order them.
  • The user may filter the jobs first and then re-order the currently-displayed jobs.
  • What is a simple way to allow the user to re-order the jobs in Quick Base?

  • If we were to use a number field to order the jobs, anytime a job is moved, all subsequent jobs (in the current view) would need to be renumbered somehow. 
  • Ideally, this could be done through a drag and drop method or at least through gridview or any other simple method


------------------------------
Jesse Berry
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Try a Kanban report. Enable manual drag and drop sequencing. https://help.quickbase.com/user-assistance/kanban_manual_ordering.html

15 columns by I think 50 cards Max per column.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Forum|alt.badge.img+8
  • Registered
  • April 15, 2020
Are all of these jobs being entered into quickbase and an excel sheet at the same time?  What kind of manufacturing 'steps' do you have (ex: awaiting release for production, awaiting production of xyz, awaiting pickup/delivery, etc)?  What dictates the re-prioritization of jobs - and how often do those jobs get re-ordered?

Lastly - how much leeway do you have with adding to/retooling your Quickbase app?

------------------------------
Brad Lemke
------------------------------