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.
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?
Oh I see now, you manually created the REF_ROWS ‘related…’ VC. Don’t do that. Delete that VC. You need to set up a Ref column in the child table that points to the parent.
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?
Your new VC is pulling the entire table for every record, that’s all. You don’t need to manually create a VC on the parent table. Do this to make sure the situation is “reset” and re-built:
Delete that new VC
Set [Topic] column in child table to Text.
Save the editor.
Set [Topic] back to Ref.
Save again.
Notice how the “related..” REF_ROWS VC in auto-generated.
Additional note, why is [Name] a Ref too? That’s most likely not appropriate.
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!
