Check-in field (check box) for a record with multiple selection

Welcome to the Airtable Community!

You need a junction table to store info about the relationship.

Hi Kuovonne, thanks for much for helping me out. That’s a good suggestion, but as far as I can understand I would need to manually select the relevant records and their relationships.

For example, I can select the volunteer “John Doe” on line 1 together with slot “Ticketing @ 13.00 hrs”. On line 2 I can select “John Doe” again and select the other slot John signed up for, “Kitchen service @ 18.00 hrs”.

Then, I could create a check-box field for each line and could check John in each time when he showed up for the relevant slot.

However, with 100 slots and 100 volunteers, where everybody signs up via a form, this wouldn’t work. Is there a way to do this automatically, with a formula, script or similar? Thanks in advance for any tips, I really cant figure this out… :thinking:

After some more researching I’ve been testing the “create junction table” script from Airtable, but this populates the junction table with all combinations from both my “volunteers” and my “slots” tables, not just the specific fields which I would need, i.e. “name” from volunteers table and the chosen “slot” from the slots table… I could strip the two tables of all info except the fields I want to populate into the junction table, but I’m not sure if this would work - or if it’s a good idea. (Then I would somehow need to store this surplus information from the volunteer form - i.e. addresses, phone numbers, emails etc. - in another table, linking it to the volunteer it belongs to…)

Any advise is greatly appreciated…

Here are two no-code ways of making junction records. I still personally prefer using a script to make junction records.