I am new to using Airtable.
I have a question about a formula I want to implement.
I would like to be able to do an IF function to check if a phone number is already assigned to the customer. If the phone number is assigned to customer 1, I would like to check if it is also assigned to customer 2, if so, a final check of the phone number for customer 3.
If the first condition is not validated, I would like to indicate “Customer1” in the result column, if the phone is assigned for “Customer1” but not for customer2, I would like the result column to indicate “Customer2” etc…
If the number is not in the list, and it is not assigned to any customer, I would like the result to be “Not assigned”.
The purpose of this formula is to check to which customer a phone number has already been assigned (knowing that it can be assigned to several customers).
This formula would be used during an API connection to check for a defined phone number and assign it to a customer who does not already have that phone number in his database.
If you have any idea about that, you would be a great help to me!