Why are UD Fields in standard tables denied the ability to show their Validation in the GRID? Additionally, why are UD TABLES denied the ability to show validation fields (pardon me, "Description" fields) in the GRID?
Usefulness: A ton! This would actually fulfill much the same desire as the "Custom display only field" wish.
I think this should work the same as standard fields.
Nathan Sutherland
| Company | Cutting Edge Plumbing & Mechanical |
| Job Title / Role | Developer |
| I need it... | Yesterday...Come on already |
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.
© 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.
We would love to be able to put custom field descriptions on the grid, it would be a pretty big deal for us.
100% agree. This is a big issue, especially when using key field. In the grid you see only numbers and have to create a report for the user to see what everything is. OR they go to the form, but you only see one at a time then.
Thanks Travis!!
We had added some custom calculated descriptions in the grid and form (see PF-I-58)
This was accomplished by inserting into dbo.vDDFIc
insert into dbo.vDDFIc (Form , Seq , ViewName , ColumnName , Description , Datatype , InputType , InputMask , InputLength , Prec , ActiveLookup , LookupParams , LookupLoadSeq , SetupForm , SetupParams , StatusText , Tab , TabIndex , Req , ValProc , ValParams , ValLevel , UpdateGroup , ControlType , ControlPosition , FieldType , DefaultType , DefaultValue , InputSkip , Label , ShowGrid , ShowForm , GridCol , AutoSeqType , MinValue , MaxValue , ValExpression , ValExpError , ComboType , GridColHeading , HeaderLinkSeq , CustomControlSize , Computed , ShowDesc , ColWidth , DescriptionColWidth , IsFormFilter , ExcludeFromAggregation , MaskText , DisableInput , ShowInSearchLabel)values ('udPMManpower' , 5001 , 'udPMManpower', 'dbo.uf_PMPMName_EPCS(Co,EmployeeID)' , 'Name' , null , 0 , null , 60 , null , 'N' , null , 0 , null , null , null , 1 , null , 'N' , null , null , null , null , 5 , '0,0,0,0' , 0 , null , null , 'Y' , 'Name' , 'Y' , 'N' , null , 0 , null , null , null , null , null , 'Name' , null , null , 'Y' , null , null , null , 'Y' , 'N' , 'N' , 'Y' , null)where
dbo.uf_PMPMName_EPCSis a Scalar-Valued Function that takes in the Company and Contact# and returns the employee's name which is shown on the grid.There are other fields that they added that also show on the form.
These fields were added a couple years ago and we haven't run into any problems with them.
This is our current workaround until Vista gets their `Field Properties > System Overrides > Display > Description in Grid > 0-Show In Grid Only` working
This is important as we want to be able to use "key values" in the text box and then show the description in the validation message, but without this capability, the grid is almost useless as the user doesn't know what the "key values" text value is.
It would be helpful to have UD items visible in the grid. We add UD items because it is a needed piece of information. Majority of people at our company work on the grid view. Therefore, the UD field is almost useless. We have to manually go and check the tab for data.
This is a must.
100% Agreed. There are so many challenges in getting away from external Excel spreadsheets and small things like this can easily derail the efforts being made to bring data from outside of the system to being managed and stored inside Vista.