Modifying form behavior based on origination of edit request

  • 0
  • 1
  • Question
  • Updated 5 years ago
  • Answered

I have a one to many relationship between Projects and Risks. Is it possible to keep the Project name field read only when creating or editing a risk/issue from the Project record? And make it editable when creating a new risk/issue from the risk/issue table?

Photo of Krishna

Krishna

  • 10 Points

Posted 5 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,610 Points 50k badge 2x thumb
Make a field called [Record id# mirror] with a formula of [record id#]

form rule

when [record id# mirror]>0

make read only [related project]

The [record id# mirror] will need to be on the form hidden by a form rule.



ie if the record previously existed, then the related project will not be editable. If its a new record, then you still may select related project.