I am working on a solution for an iOS tool so people's names can be added to a group. Typically all of the potential attendees are known and imported into the db, but occasionally a new one needs to be added. This is easily handled with a new record layout I can jump in and out of.
My problem is I need to make new subgroups on the fly and add members to those groups. I assume the best thing is to make a new table for groups, so the peoples’ records can be related to those groups. Then whilst being in front of a group with a layout in list view showing all of their names, I need to make a new group, then find each person in front of me and add them to that group.
Is this the way I should approach this problem?:
1. add a portal in the header of layout to the groups table allowing me to make a new group
2. make a script that triggers on entering a new group in that portal field that makes the group name a variable,
3. then when I touch on each person to assign them to the group, a script trigger pastes the variable into a field in the person’s record associating them with that group.
I have no experience with variables, what would the scripts look like that load the variable and paste it (assuming this is the most efficient way to perform this)?