I’m trying to setup a data base for a Webflow project and I need the following to happen.
As you can see on the image above, I have a column for cities, and another for city ID. Both are dropdowns including different options where only 1 can be selected. The city column includes things like London, New York, etc. and the columns City ID has an ID that is associated with a city.
Is there a way to link both columns so that when I select London from the City column, automatically selects the ID in the City ID that is associated with London?
Hi @Ethan_Suero, in this case it would be easier if cities were stored in a separate table, in which you specify the corresponding id for each city. You then just link the city and you can use a lookup field for the id if you want to display the id in your main table.
No, you wouldn’t be able to use separate bases to workaround the 5k limit, because whenever you sync records from one base to another base, those records count towards your limit in both bases.
So, if you’re on a Plus Plan and you have more than 5,000 cities (although you would actually need less than 5,000 cities because you’ll want records in other tables as well), then you will need to upgrade to the Pro Plan.