Skip to main content
Question

Make it impossible for users to change status back to previous status by mistake

  • February 10, 2021
  • 0 replies
  • 57 views

Forum|alt.badge.img+5
Hello all,

Right now I am working on a policy tracker for the insurance company that I work for. To track the status of each policy in its lifecycle, I am using a dropdown. Every time a user chooses a new status and saves the record, the status gets saved in a child table called 'Status Log'. To make it so that a user cannot choose a previous step by mistake, could I make it so that when a user chooses the next status, all the previous statuses become 'read-only' or something to that effect?








------------------------------
James Dalton
------------------------------
This topic has been closed for replies.

  • Quickbase Alumni
  • February 10, 2021
If there's a strict order in which these records go from one Status to another, you could always setup the change in Status to be initiated by a button instead. So, say it's in "Quote Sent" status, your button could say something like "Submit to [Next Status]".

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------