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
Out of all my suggestions, I thought that using 1 and 6 or 9 would be sufficient for managing it; however the user would never know that their reply was being deleted (and ignored).