Forum Discussion

GideonAnsell's avatar
GideonAnsell
Qrew Trainee
7 years ago

How do I restrict a user to only add 1 child record to a given parent record

We have a master table "Feedback Requests" and users can add a child record "Reply" to each request for feedback.  I'm trying to limit the user to only 1 reply per feedback request.  In other words, i...
Relationships
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Somewhat surprisingly this worked as a formula text field set to be unique.  I suggest that you name your field

[Sorry, but only 1 feedback per request!]

You will see why I suggest that when you attempt to save the second feedback.


List("-", ToText([Record Owner]) & ToText([Related Request])
Laura_Thacker's avatar
Laura_Thacker
Qrew Commander
7 years ago
After some interesting testing; I love the simplicity of this.  This does assume that the same person will be adding a Reply though.