We would like the ability to use a dropdown in form templates that can select a specific sites serviceable items. The goal is to create a historical record for certain forms like warranty documents tied to a specific piece of equipment aka (serviceable items)
James Tomlinson
| Company | Veregy |
| Job Title / Role | Service Coordinator |
| I need it... | 6 months |
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.
© 2024 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.
Kevin where is this SQL field you are referring to? I originally thought it was the SQL Choices Override field in the manage look up section
This is currently possible by using the following in the lookup SQL field:
SELECT ServiceItem AS ChoiceShortName, ServiceItem + ' - ' + items.Description + ' - ' + Model + ' - ' + SerialNumber AS ChoiceLongName FROM ScopeChecklistInstance i
INNER JOIN kSMWorkOrder wo on i.SMCo = wo.SMCo and i.SMWorkOrder = wo.WorkOrder
INNER JOIN kSMServiceItems items on i.SMCo = items.SMCo and wo.ServiceSite = items.ServiceSite
WHERE i.ChecklistInstanceID = @ChecklistInstanceID