Changing the Format and Mask of Fields in the Grid

Hi,
I'm trying to change the format of the ultr datagrid for the number fields , for just to reflect on whole number format, in the similar way I have a currency field which needs to be formatted as ######.## . I have tried customization>collection> format, mask change. It seems it works as soon as I compile and save it. But when I go back into the form and see the changes those formatting are lost. It looks like changing the format from the collection object in the customization is not the right place.
Can any one guide me on how to do this basic thing?

Hi Nafa - try changing it from the EpiDataView. In the development mode under the tools menu you can access "Modify extended properties" (under Wizards). From there you can choose your dataView, the field, and set the format. This will put some custom code in the script to set the format property on the EpiDataView on initialization.

Help the community by fixing grammatical or spelling errors, summarizing or clarifying the solution, and adding supporting information or resources. Always respect the original author.

Popular White Paper On This Topic

Hi Nafa - try changing it from the EpiDataView. In the development mode under the tools menu you can access "Modify extended properties" (under Wizards). From there you can choose your dataView, the field, and set the format. This will put some custom code in the script to set the format property on the EpiDataView on initialization.

I have the same issue with a UDtable form. Can't change the display format of a column in the list grid. I tried to change the format from the collection property, not working. I tried the solution posted above, but still it's not working?

Ok case closed. Not sure why but, I probably tried too many different things and everything gets mixed up. So I carefully clean all places where I tried to change the format, keeping only extended properties and restarted the client and...it works now !