I need help to determine if Airtable can do what I am trying to build.
Currently, we are using Google sheet, and I feel it’s not working, I want things to be more automatic.
Our six business development team book sale events for our sale team to attended.
Main Sheet: will have these following tabs:
COID: (will have drop downs)
Community: (will have drop downs)
Event Type: (will have drop downs)
Contact Phone number:
Team Members: (will have drop downs)
When we assign Address to our six business development team members, we only give them the address, and they need to fill the rest out, themselves.
What I want to do is, once I fill the address field with address and assign it to a team member, I want it to show it up on their sheet. Without deleting it from the current sheet
If enter: 123 street in the address field and then go to Team member and select Omar, That address will show up on Omar sheet.
Once they fill the rest of the requirement fields from COID to Contact Email; The main sheet will be updated.
I am not sure how to go about this or if Airtable can do this or if I have to find a different solution.
Thank you guys in advance