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.
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!