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.
  • 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,
  • 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).