I want to use a few different forms for my staff to submit info. 1 for contact info, 1 for schedules, 1 for rsvp to event etc. Is there a way to auto merge the info or link their name so all their info is tied together? I am struggling to understand the best way to set it up.
Air Table for forms
+1This topic has been closed for replies.
+6Hi @Ddegrand ,
You can start by creating a table for your staff members. Then create a table each for schedules, events, etc.
You need to link these tables to the staff members' table.
Then, in the staff members' table, you need to create button fields that redirect your staff members to the forms and prefill their names.
the formula for the buttons would look like this : https://airtable.com/shr12345678?prefill_StaffName=RecordId
Hope it helps.
+31If the staff members know the names of every other staff member then I'd just have a table for contact info, and then link that table to the "RSVP to event" table and the "Schedules" table. The staff members would then select themselves via the linked field when filling out the form, which would tie everything together like you want
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.