Basically, here is my problem.
I synced an airtable view to help manage our service providers all over the country. The view contains customer name & city information. Table 1 is synced, so the information is not editable in primary field.
Table 1: P...
Hi Adam,
Appreciate all of the help. I am having trouble doing this however.
Here’s what I have in table 1
Table 2:
I set up a formula to concencate “City - State” into column 1.
Now, I’ve tried to do an automation or copy and paste existing “city ...
Hi Adam,
I think I know where you are going with this.
How would you handle duplicates getting added to Table 1 (Customer name + city).
It would most likely add multiple rows of the same city.
Let’s just say I have 250 customers but only 30 different...