Forum Discussion

KevinKing's avatar
KevinKing
Qrew Member
5 years ago

Custom Data Rules - Restrict Table Edits with Status & User Role

I have used custom data rules to validate a specific field, but is it possible to restrict all fields while a "Job" is in a certain "Status" or certain User Roles?

Here's my general thought (loosely formatted):

If User=SalesRepID AND JobStatus=InProduction, don't allow any edits to the record.

The goal is to prevent any last minute edits by the Sales Rep once the job is in motion.

Thanks!

------------------------------
Kevin King
------------------------------
  • OK,
    So that will be done with a custom permission Rule for the Role access for Modify, not Custom Data Rules.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
  • OK,
    So that will be done with a custom permission Rule for the Role access for Modify, not Custom Data Rules.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • KevinKing's avatar
      KevinKing
      Qrew Member
      Mark,

      Thanks so much. I was over complicating things. Made a Custom Rule in 2 seconds.

      ------------------------------
      Kevin King
      ------------------------------