Dec 26, 202304:07 AM - edited Dec 27, 202307:04 AM
Hello Airtable Community,
I hope this message finds you well. I'm currently working on a project where I've implemented a referral code system in Airtable, and I could use some guidance on handling potential duplicates.
Here's a brief overview of the situation: I generate referral codes in the format "Four letters of firstname, -D, and last 2 digits of the phone number." For instance, if I have a user named Johnathan with the phone number ending in 19, the referral code would be JOHN-D19. If i have another user named John with the phone number ending in 19, the referral code would also be JOHN-D19.
Now, the challenge I'm facing is that I want to avoid assigning the same referral code to different individuals. To achieve this, I'm looking for a solution to identify and handle duplicates. Here's the logic I'm aiming for:
Identify Duplicate Referral Codes:
If the referral code is duplicated, proceed to the next step.
Check for Same Person:
Compare the email and phone number associated with the duplicated referral codes.
If both the email and phone number match, it means it's the same person, and the referral code remains unchanged.
Handle Different Phone Numbers:
If only the last 2 digits of the phone number are the same, increment the last 2 digits of the referral code by 1.
I'm struggling with implementing this logic in Airtable, and I would greatly appreciate any insights, tips, or examples that could help me achieve this goal. Your expertise and support mean a lot to me.