I want to restrict non-Administrator users from adding records with a date older than 2 days ago. How can I do this?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of Douglas0507

Douglas0507

  • 30 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,664 Points 50k badge 2x thumb
I would have a  formula checkbox field showing on the form called [Date is Current?] with a formula of

[My Date field] + Days(2) <= Today()

Then have a form Rules which says

When the record is saved and

[date is Current?] is unchecked

Abort the save with message "Sorry, but you may not enter records more than 2 days old'
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,664 Points 50k badge 2x thumb
The form rule will actually need to be
when the Record is saved
and the user is not in the role Administrator

...