Good Evening and thank you for taking the time to take a look at my request.
In short, I would like to have my users complete forms (which I have made into various collections) that are associated with that one particular user.
- Susan is my app user and she’s completed the sign up process and created her account.
- First, she must complete survey one (Collection A) and it should be linked to her user account.
- Second she must complete survey two (Collection B) and it should also be linked to her user account.
I would like this concept to apply to all of my users. So on the backend when I search for Susan or any of my users I will get their user details but also survey one and two specific to that said user.
I attempted to make the relationship from the user collection to Collection A and B. I’ve tried one to many, many to one, and many to many however when the record is created it doesn’t associate itself with the user who is creating it. Each time I attempt to add an automatic field it does not allow me to only select “Logged In User”
Any feedback is much appreciated.