Hi All,
So I have a question about the best way to merge data. I manage a scholarship program for a festival that happens once a year. We've been using airtable the last few years to manage the staff, artists, and scholarship recipients. We saw a lot of success converting our emails into Typeforms last year and want to expand on that.
We use a typeform application for people to apply and then pull those who are selected into an 'Accepted' View. We intend on sending 4-5 typeforms with questions so we will need to merge their answers into each of their 'Applicant' profile.
The typeform will ask for the same email address they applied with and I would use that to direct the merge. This is going to create a lot of multiple 'accounts' and I want to make sure our data stays tidy and manageable.
Rundown:
1. John Snow is accepted.
2. We send out Typeform 1, 2, 3, and 4 out to John
3. John fills out the typeformform as he recieves them, the data is collected and sent into airtable via the integrations
4. We would then have 5 'Jon Snows' per se. The initial acceptance and then the 4 entries from Typeform.
My plan is to merge that data each time we send out a typeform. Anyone have any guidance with this? I don't want this to happen automatically at first, I would feel better about manually merging the data in case something happens. I expect some people will mispell their email, so some sort of log error would be helpful if the email can't be found. I hope this explains what I'm trying to do, please feel free to ask any questions you have.
Thank you!
