Can i pull a report that shows the ship to state for an order

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
Photo of Stephanie Mascilak

Stephanie Mascilak

  • 70 Points

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,758 Points 20k badge 2x thumb
If you have an "Orders" table that has a "ship To" address then you should be able to pull the ship to state to display it where you'd like in the columns, or even use it as a dynamic filter on the left, so you can easily pull all the orders to that particular state.
Photo of Mikail Kote

Mikail Kote

  • 148 Points 100 badge 2x thumb
 Assuming you have an address field named [Ship To ]

1.) I recommend you create another field Called Ship to State and make sure it is set to Formula - Text

2.)  If you look on your address field options and scroll all the way down you will see Address Subfields. Use the field label [Ship To: State/Region] 

3.) so just open up your newly created field Ship to State and simply enter
 [Ship To: State/Region]  and you're all set

Now for a report you can simply use the address field subfields as the columns