Is there a way to move a report from table to table based on an input value?

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • In Progress

Hi, I am in need to better organize lab requests where I work. Let's say I have 4 tables: My Requests, Pending Requests, Started Requests and Finalized Requests. We will include a dropdown that has the request status of either Pending, Started, or Finalized. How would I make this so that whenever the admin changes the status to, let's say, Pending, the request will only be shown on the pending tab and be removed from Started Requests and Finalized Requests until this is changed and so on with each other Request type?

I am new to quickbase and have very little knowledge about API. Any leadway would be much appreciated.

Thanks,

-Brandon

Photo of Brandon Burton

Brandon Burton

  • 82 Points 75 badge 2x thumb

Posted 8 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,326 Points 50k badge 2x thumb
I VERY strongly suggest that you have just 1 table and and a status field with choices o Pending, Started and Finalized.

Do not create multiple tables to handle your work flow, just use different statues.  
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb
Have one table and four reports filtered to your preferences.
Photo of Brandon Burton

Brandon Burton

  • 82 Points 75 badge 2x thumb

If I have one table with four reports, would it be easier to move a row between tables based on an input value?


Thank you for the responses!

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,326 Points 50k badge 2x thumb
Brandon, since you are new to Quick Base, I'm not sure if you are meaning the terminology you are using.

I can't stress strongly enough that you must not make your app design with 4 tables to hold the same data tables.  It will quadriplicate your work content and make it impossible for you to have meaningful consolidated reports or your over all order status.

No one on his forum will tell you how to move a "row"  (ie a record) between tables as its really bad design to design it that way.

Just have a Multiple choice Status field on your record and update the Status as it moves along your internal workflow.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,326 Points 50k badge 2x thumb
You can have 1 report which is groups on Status ands also that report can have Dynamic filters on status.

Or else 4 reports all for the same table.