LinkedIn
Twitter
Dear All,
I created an app which has "Members" and "Sessions" tabs. The goal is to be able to register multiple members (as attendees) on the sessions. For that I created a virtual column on the Sessions tab, and I am able to add a Member from a dropdown list, but only 1, because if there is 1 member on a session already, and I try to add another, it gives an error message that says "There is already a row with key xyz". The key is the session's ID, so it seems like it doesn't allow 1 ID to be registered twice.
Example:
I was able to add 1 member as attendee
but once I try to add another, I have this error message:
Can someone please help me with this?
Thank you in advance!
Solved
1 ACCEPTED SOLUTION
Thank you so much for the response!
This is how the 2 tables look like which leads to the scenario described above:
It gives me a dropdown list with all the members' names and pulls the session's ID automatically:
If I add the child table another key (the name of the member) then I do not have the dropdown list and it pulls the session's ID into the name field:
And with this setup the same thing happens, I add a test line to the attendees and if I try to add another, it gives me the same error message:
The desired goal would be to keep the dropdown list with the names and to be able to register multiple attendees to 1 session. My apologies for the multiple posts but could you please help me with how that could be done?
Thank you for your help again!
Thank you! I created a ref column in the child table and it helped indeed, now I can save multiple members, however, now it saves the members for each and every session, not just for the one I registered them:
I'm really sorry for the multiple questions, I'm not sure what I'm doing wrong. Do you have any ideas how this could be fixed so that it registers the attendees only for the session I actually register them and not for all the sessions?
Thank you!
Hi, I followed steps 1-6, indeed the REF_ROWS was autogenerated, however, now it's back to square one (only now from the member's perspective so now it allows multiple members on 1 session, but only I can register 1 member to 1 session only), if I add a member to a session and try to add the same member to another session, it gives me the same error message "There is already a row with the key xyz"
Maybe I didn't describe well what I would like to achieve, my apologies, so I would like to be able to add many members to 1 session but at the same time add a member to several sessions (like there is a team and each team member can apply to whichever sessions they would like to). How could this be achieved? Thank you so much for your help and patience!
