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])
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
I presume that this was some kind of employee survey and they only want 1 reply per user per Feedback Request.  I was surprised it worked because one would think, the system does not know the Record Owner,  until after the record is saved.  But it must have looked ahead to see that ahead of the save.

Well live and learn, that's why we haunt the forum,