Would really appreciate some help creating a formula. I am trying to run (modernize) a non profit social society’s events calendar / booking system using airtable.
I have 3 tables in the same base.
Table 1 (Master) - This has a sign up form linked to it for people (both members and guests)
to can sign up for the events (single or multiple). The selection of events is linked to the (Events) table. The sign up form has a check box for users to select if they are Members.
Table 2. (Events) - this is the calendar table with date and event name. (separate columns)
Table 3. (Members) - List of members with their names and membership numbers (and other membership data) (all in separate columns)
If a member signs up for specific event, I need a formula to look into the (Members) table and compare their names and return their membership number into the master table.
Appreciate any help people can offer?