Jun 28, 2023 06:20 PM
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.
Jun 28, 2023 09:32 PM
Hi @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.
Jun 29, 2023 03:00 AM
If 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