US State/Province choice list or reference table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-07-2020 09:28 AM
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
- Labels:
-
Scripting and Coding

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-07-2020 09:38 AM
HI,
Where you want to do this? On USer record or somewhere else.
Thanks,
Ashutosh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-07-2020 10:27 AM
It's on a custom table that extends Task... in a scoped app.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2020 08:33 AM
HI,
Meaning where do you want to save this State values? user table or some other table.
Thakns,
Ashutosh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2020 12:55 PM
I am storing the state data on a custom table that extends Task... in a scoped app..... not the user table.