Submit Your Suggestions for Vista

Ideaspace topics with the most votes have been moved into the Suggestion Box. If there is a topic missing, please re-enter. Our product team reviews the Suggestion Box items regularly and will provide updates as to status and incorporation into upcoming releases.

Is it possible to make SM Work Order Number Viewpoint Type /SQL Type from Integer to Numeric or Alpha Numeric

We will run out of SM Work Order Numbers due to the limit of 10 characters if the format was changed from INT to Numeric or Alpha Numeric this would resolve this issue.

  • Sherry Packard-Silvius
  • Aug 2 2022
Company PLH Group Inc
Job Title / Role Senior ERP Technical Analyst
I need it... 12 months
  • Attach files
  • Nathan Sutherland commented
    August 09, 2022 22:01

    The INT value type only stores up to 2,147,483,647, not 9 billion. My bad. Dividing my estimates by 9 still leaves quite a bit of room though. :-)

  • Nathan Sutherland commented
    August 09, 2022 21:58

    10 digits, that would be 9,999,999,999.


    We started at the 10,000 range, and have over 9.9 billion left. At 100 per day, we still have 99 million days, or 271 thousand years.


    Even if we did 10 thousand per day, we'd have over 2,700 years left.


    How many work orders do you guys do per day?


Dear Viewpoint Suggestion Box contributor;

We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs. Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.

1515 SE Water Avenue, Suite 300, Portland, OR 97214 |  800.333.3197  | Contact Us | Terms of Use | Privacy | Support Policies

© 2023 Trimble Inc. All Rights Reserved. Viewpoint®, Vista™, Spectrum®, ProContractor™, Jobpac Connect™, Viewpoint Team™, Viewpoint Analytics™, Viewpoint Field View™, Viewpoint Estimating™, Viewpoint For Projects™, Viewpoint HR Management™, Viewpoint Field Management™, Viewpoint Financial Controls™, Vista Field Service™, Spectrum Service Tech™, ViewpointOne™, ProjectSight® and Trimble Construction One™ are trademarks or registered trademarks of Trimble Inc. or its affiliates in the United States and other countries. Other names and brands may be claimed as the property of others.