US State/Province choice list or reference table

Thomas Weyer
Tera Contributor

I have yet another project where I need to include a field for a US State.  (Yes, a complete address - I would like to offer the users the ability to select a state from a list instead of freeform text)

Is there a recommended table or choice list OOB that should be used for US States? 

I've tried using the sys_report_map table ... it works most of the time, yet seems a bit cumbersome.  I also feel like I'm using a table for a purpose it was not intended. 

Thanks,
Thomas

8 REPLIES 8

Ashutosh Munot1
Kilo Patron
Kilo Patron

HI,
Where you want to do this? On USer record or somewhere else.


Thanks,
Ashutosh

It's on a custom table that extends Task... in a scoped app.

HI,

Meaning where do you want to save this State values? user table or some other table.

Thakns,
Ashutosh

I am storing the state data on a custom table that extends Task... in a scoped app..... not the user table.