I’m trying to create a single select dropdown with all 50 US states. Is there a way to do this without manually typing out all 50 states? I thought pasting in comma separated values would automatically do this, but it doesn’t. Thanks.
1 Like
Hi @Donald_Wilson and welcome to the Coda Community!
Have you tried using Coda AI?
I would suggest you to use AI and tell it to generate a Table with all US States. You then need to change your column type to Relation and relate to the table that was just created.
Please let me know if this solved your issue or if you need any more help.
Best regards
Jannis
1 Like
Interesting, I just was going to ask the same question in a different way. I have a table with 100 companies in one column and then each of their investors in another column. I can create the list of companies and investors and relate them but when I look at the company listed as text it is not picking up the values from the select list even though they are identical.
Sorry, I don’t know the right term for the text with bubbles around them versus plain text. I tried everyway to match text to then pull the matching bubble outlined selection but also cannot. I think it is the same issue. So I have to go manually and go company by company to select the correct ones that match. There must be a shortcut here.
Thanks
1 Like
Generally try to stay away from select lists, it’s usually better to create an entirely new table with a linked relation instead
Like Jannis said, ask an AI of your choice to generate a table of the 50 US states, you can copy-paste this into a coda doc to create a table
# State Abbreviation Capital
1 Alabama AL Montgomery
2 Alaska AK Juneau
3 Arizona AZ Phoenix
4 Arkansas AR Little Rock
5 California CA Sacramento
6 Colorado CO Denver
7 Connecticut CT Hartford
8 Delaware DE Dover
9 Florida FL Tallahassee
10 Georgia GA Atlanta
11 Hawaii HI Honolulu
12 Idaho ID Boise
13 Illinois IL Springfield
14 Indiana IN Indianapolis
15 Iowa IA Des Moines
16 Kansas KS Topeka
17 Kentucky KY Frankfort
18 Louisiana LA Baton Rouge
19 Maine ME Augusta
20 Maryland MD Annapolis
21 Massachusetts MA Boston
22 Michigan MI Lansing
23 Minnesota MN Saint Paul
24 Mississippi MS Jackson
25 Missouri MO Jefferson City
26 Montana MT Helena
27 Nebraska NE Lincoln
28 Nevada NV Carson City
29 New Hampshire NH Concord
30 New Jersey NJ Trenton
31 New Mexico NM Santa Fe
32 New York NY Albany
33 North Carolina NC Raleigh
34 North Dakota ND Bismarck
35 Ohio OH Columbus
36 Oklahoma OK Oklahoma City
37 Oregon OR Salem
38 Pennsylvania PA Harrisburg
39 Rhode Island RI Providence
40 South Carolina SC Columbia
41 South Dakota SD Pierre
42 Tennessee TN Nashville
43 Texas TX Austin
44 Utah UT Salt Lake City
45 Vermont VT Montpelier
46 Virginia VA Richmond
47 Washington WA Olympia
48 West Virginia WV Charleston
49 Wisconsin WI Madison
50 Wyoming WY Cheyenne
2 Likes
Thanks for the responses! This was the same solution Chat GPT gave me. I guess I was hoping there was a way where I could keep the State field color-coded, but I noticed when you do group by State, the table defaults to a grey color.
Also I don’t really want an extra table floating around, but I’ll just collapse it for now and put in on the bottom of the page. All in all in worked. Thanks!
1 Like
Welcome to the community ! 
was this what you were getting at?
the trick is you will need a numeric column in your States table and then set conditional formatting on it. This will then allow “color scale”.
or if you want to just set your colours manually for the states, you can also do it with conditional format.
here’s a demo you can view in detail
Hope this helps!
Cheers!
Mel
4 Likes
Figured it out. Used Trim() on both sides and now it is working.
@Melanie_Teh Excellent! This helps a lot. I’m coming from Airtable/Smartsuite. Coda is very flexible so Im wrapping my head around everything. It’s a lot haha.
1 Like