It would be nice to be able to write a standard SQL function to bring back results. In my use case, I wish to in one lookup change the description of the single returned result to something else.
Andre Ferreira
| Company | Pacific Formwork |
| Job Title / Role | Pacific Formwork |
| I need it... | 1 month |
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.
Sadly if the function requires parameters, the workaround does not work. If VP would modify their "Lookup" procedures to swap "?" in the "From" line, then I think functions would work fine in the "From" line.
As a workaround, perhaps you could create a view for the source of your lookup. You could easily change the description of one result in that.