Re: Air Table for forms

434 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.  

2 Replies 2
6 - Interface Innovator
6 - Interface Innovator

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 :

 Hope it helps.

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