Forum Discussion

Qrew Cadet

3 years ago

Locking a Dropdown field based on a selection in another field.

On my Ticket table, once a Team Member has been assigned, the Status field changes to "Assigned" should not be allowed to go back to "Pending". How do I make it so users cannot change the Status back...

roles and permissions

EvanMartinez

Quickbase Staff

3 years ago

Hi Chris,

You could also create a custom data rule that doesn't allow a record to be saved if there is both a Team Member assigned in the team Member field and the Status is "Pending", then you could even have a message pop up if someone tries to direct them that they cannot put a task back to Pending.

------------------------------
Evan Martinez
------------------------------