Column formatting in the SalesLogix web grid control

In the SalesLogix web grid control there is a TextFormatString property to grid columns.  Unfortunately there is no documentation currently on how to use this property.  Hopefully this article will help with that.


In the SalesLogix Application Architect, if you open a QuickForm that has a grid, you can click on the Grid to see its properties.  one of these properties is the Columns collection.


Clicking on the Collection will open the grid column collection dialog.


In the dialog you can see the columns in the grid and as you click each column on the left you can see the column’s corresponding properties on the right.  This is where the TextFormatString property is located.  In the screen above I have selected the CreateDate property as my bound entity property (DataField).  let’s say I wanted to format that so that it only displays the date and not the time.  To do that I can simply add the format string for short date, which is {0:d}.


That is all there is to it.  Now when the form is rendered the date will display as just the short date (i.e. 12/25/2006).

Check out this MSDN article for various format strings.


Kris Halsrud

Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.

1 Comment

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!