Creating Unique ID for one contact that has been pulled in from various data sources
So, I have contacts that have been pulled into Airtable from different sources (Active Campaign, Google Form, etc). Each data source is in it's own table and I have created a fourth table where I have pulled in EVERYONE using automations, lookups and roll ups. I have then grouped the view using email address and what I now have is a brilliant view of a single contact and how they are involved in our company. In my example below, I can see that she is a 'Puppy Handler' (pulled in from google docs data) and she has also subscribed to a few of our marketing emails (pulled in from activecampaign)... However, autonumber have given her 5 different ID numbers as she has a total of 5 entries within the base... is there anyway I can create a singe ID for her using her unique email address as the unique value???
