I hope this is the right place to ask this. I’m hoping to figure out an easier way to handle a data type in my base. Basically, a lot of the data we use has cities in our area for different purposes (Address for the student, parent address, school address, things like that). So basically we have 5 different fields that are basically of a “City” type.
To import into our system, the city names have to exactly match what is in there, or they won’t import. To accommodate this, I made the city list a dropdown selection. We have a ton of cities we serve, and it seems every year we get new ones. Unfortunately, that involves updating the attributes for not only 5 fields, but due to confidential data regulations, those same 5 fields across multiple bases.
Is there some way to sync the dropdown selections for those city fields to a master list somewhere? This way, if a new city pops up, we can push it out to all of the bases for our customers, or if we find out someone put in a city name and spelled it wrong, we can fix that across all bases.
Thanks for your help!