Oct 22, 2024 03:07 PM
I am in real estate. I started with a Deals table, but now realize I should have a Properties table...so I did the following:
Here is a link to a video...please help. Thank you everyone.
https://share.zight.com/BluPqq0j
Best,
John
jgiordani@gmail.com
Oct 22, 2024 06:57 PM
I think the comma might be confusing the linking. They're one to one links, so try toggling off "Allow linking to multiple records":
Should work fine after that:
Oct 22, 2024 08:38 PM
The issue is that you have a comma in between the city and state. Airtable will see that as 2 different records it is trying to link to. So when you have a value of "freeholde, NJ" it is seaching for "freeholde" and "NJ" which do not exist in your base. A fast way to resolve this is to create a new field without the comma in the deals table, remove the comma from the properties table primary key, then link the two that way.