So here’s what I’ve got so far…a table for the Single Ladies, a table for the Single Men, a table for Scheduled Events. I was trying to use Forms to send out RSVPs, but want the data submitted from the RSVP form to populate the Scheduled Events fields. Equally, some of our single ladies and single men, have some issues with various people, so on the RSVP form I have a field that asks them to name anyone whom they would like to avoid, so I’d like that to populate the specific record in the Single Ladies or Single Men table.
Have 1 table for all the Singles, add a field for the gender.
Create a new table called Events RSVP. This is the table where the form will populate. You can have a unique form link for every event that is prefilled with the event you are inviting them to.
Since you would want the names to be linked to the singles table BUT at the same time you wouldnt want anyone filling the form seeing all the other names (I assume?), You could take advantage of this Script here. This can work for the Participant field and the trying to avoid field.