Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 31, 2021 05:51 PM
Hi! I’m new here. Is it possible to share all of the options in one single select field with another single select field in another table? For example, say I have table of employees with a location (city), and a table of clients with a location. I’d like to be able to add a city to one field and have it automatically show up as a single select option in the other table.
Aug 31, 2021 07:15 PM
Welcome to the Airtable community!
In order to share information across bases, you need a synced table. You could turn your list of locations into a synced table, and use a linked record field instead of a single select. When you add a new location to the original table, it would show up in the synced table (either automatically or at the next manual sync, depending on the setup). Note that you would only be able to add locations in the original table, not from the synced table.
Sep 01, 2021 08:19 AM
Hi, Kuovonne. I am not trying to share options across bases, but rather across tables. I can’t tell if your reply still applies.
Sep 01, 2021 08:26 AM
Thank you for the clarification. Yes, I recommend converting the single select field into a linked record field. You would have a [Locations] table that stores all the locations. Adding a location to the Locations table would make that location available to all of the tables that are linked to it. You would loose some features (different colors for locations, kanban grouping, etc.), but it should solve the base problem.
Sep 01, 2021 08:29 AM
Thank you, I will try that!