COLINKELLY
6 months agoQrew Member
Progressing a "Restricted" Status Field
Hello!
We track a number of different status options in QuickBase. Some users have permission to change these statuses while others are restricted.
In one place, we ask the PM to complete some tasks, check a box indicating they've done the work, and touch Save. When they do this, we want the status to automatically change from Awaiting Action to Submitted / Not Yet Reviewed.
I know I've been able to make this work in the past. But now, I'm finding that because the user doesn't have full access to the field, the status isn't changing. I could just unlock the field, but then the user could potentially just move the project status to Approved which I do not want.
Does anyone have a suggestion for achieving this?
Thanks,
Colin