Versions Compared

Version Old Version 8 New Version 9
Changes made by

Amy Mangueira

Cooper Blakemore

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Message formats are used when sending email messages to customers and email, text, or X Mobile messages to drivers. 

To get to the Message Formats section, go to Maintenance > Message Formats.

...

Tip

Quick Tips

  • Available Fields can be restricted to a certain number of characters. 

    Example:

    [5POD] would return 5 characters to the POD value instead of the full POD.  If a POD of 123456789 were entered in it would return the first 5 as 12345.

  • Localized times for Available Fields: 

    • Server times: Invoiced, PickUpTimeFrom, DeliveryTimeFrom, Canceled 

    • Origin times: ReadyTimeFrom, ReadyTimeTo, PickedUp, AtOrigin, Confirmed, Dispatched, Ordered, Transmitted, ReceivedAtDock, UpdatedWhen, PickupETA

    • Destination times: DueTimeTo, DueTimeFrom, AtDestination, Delivered, DeliverETA

  • You can add Client Portal track order or attachment links to the Message Format section. See Client Portal Punch-Through URL.

  • Message formats can be up to 100,000 characters. 

...

Advanced (SQL and HTML Statements)

The Advanced tab allows you to execute a custom SQL or HTML statement when the message format is triggered and/or use a report format for the message format. For "Customer On-Demand" and "Customer Route" message types, you can preview your message. 

...

Additional Resources for HTML Message Format Statements

If you want to use a HTML statement, there are some simple online editors that you can use to help you build your HTML, even if you don’t have prior experience with it.

Execute Custom SQL

Check the Execute SQL Statement checkbox (for either SQL or HTML statements) and then click the button next to SQL Text.

...