This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

has anyone tried to get the "shortname" (like for a state: Arizona -&gt; AZ) in a join field? I have a custom field on a project record that is from the list "state" but I want AZ to display in the search and not Arizona (which is currently the case)

SuiteAnalytics usually gives you this option `#display` or `#RAW`, search does not really have that option in the UI

Could always brute force it with a decode statement.

decode({field},'Arizona','AZ','Florida','FL', ... etc etc)

you know, that'd be pretty handy to have in the future... hold on a second and I'll cheat the whole formula in...

```decode({field},'Alabama','AL','Alaska','AK','Arizona','AZ','Arkansas','AR','California','CA','Colorado','CO','Connecticut','CT','Delaware','DE','Florida','FL','Georgia','GA','Hawaii','HI','Idaho','ID','Illinois','IL','Indiana','IN','Iowa','IA','Kansas','KS','Kentucky','KY','Louisiana','LA','Maine','ME','Maryland','MD','Massachusetts','MA','Michigan','MI','Minnesota','MN','Mississippi','MS','Missouri','MO','Montana','MT','Nebraska','NE','Nevada','NV','New Hampshire','NH','New Jersey','NJ','New Mexico','NM','New York','NY','North Carolina','NC','North Dakota','ND','Ohio','OH','Oklahoma','OK','Oregon','OR','Pennsylvania','PA','Rhode Island','RI','South Carolina','SC','South Dakota','SD','Tennessee','TN','Texas','TX','Utah','UT','Vermont','VT','Virginia','VA','Washington','WA','West Virginia','WV','Wisconsin','WI','Wyoming','WY')```

furiously browsing looking for a state you missed lol

I copy pasted from a table, and then did find and replace in a CSV formula

well I need not just US but canada potentially, etc.... :disappointed:

well, you could do the same exercise I just did. Shouldn't add, but what? 13?