Setting restrictions on one field based on another

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • In Progress
We have a table in which anyone can create a new record, but only 2 people are allowed to "approve" the record. How can we set it up so the creator can't approve their own record? The approvers can and do use grid edit to fill in their name, so I can't use a dynamic form rule. 
Photo of Pamela Bray

Pamela Bray

  • 272 Points 250 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,928 Points 50k badge 2x thumb
How about an Automation to reverse the approval if the approval status changes and yje Asprovsl Status is Approved and the record owner = last modified by.