read only date field after save

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
How to make a date field read only after user selects a date and clicks on Save.
User should not be able to change the date after they click on Save.
Photo of QuickbaseUser

QuickbaseUser

  • 474 Points 250 badge 2x thumb

Posted 7 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
You can use a form rule to detect if the record has been saved.

But for some reason, form rules do not allow the use of the [Record ID#] field.

You can make a formula numeric field call Record ID# mirror with a formula of

[Record ID#]

And use it in a form rule

When multiple conditions
The user is in the Role. (Role)
The Record ID# mirror is > 0

Make read only [Date field]

And make the field required on the form.
Photo of QuickbaseUser

QuickbaseUser

  • 474 Points 250 badge 2x thumb
Awesome...tried it out and it works...
Thanks Mark!!!