Login / Register  search  syndication

          Kris Halsrud's Blog

Kris Halsrud on development and Integration with CRM and Development

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.

image

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

image

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}.

image

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.

What's This?
Bookmark and Share

About Kris Halsrud

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


Related Content
   Using SQL triggers to enforce data rules in SalesLogix.
In a recent project, I used triggers to enforce some data rules in the Ticket area of SalesLogix. We did
Posted on Feb 05, 2010 by Jason Buss to Jason Buss' Blog
 
   SalesLogix 7.5.2 Hot Fix 1 – the Dependency Lookup is still broken
SalesLogix released hotfix 1 for SalesLogix 7.5.2.  One of the published resolutions of the hot fix
Posted on Jan 27, 2010 by Kris Halsrud to Kris Halsrud's Blog
 
   System Dates
One of my customers had an issue this week with setting the date on their system. They were trying to ru
Posted on Jan 15, 2010 by Dale Richter to Tech Talk
 
   Message box dialogs in the SalesLogix web client
In the web client, there's not an easy way to present the user with a multiple choice dialog. One q
Posted on Jan 14, 2010 by Jason Buss to Jason Buss' Blog
 
   Clearing user default settings in the SalesLogix web client
Each user of the SalesLogix web client can define various user based  settings while they are using
Posted on Jan 13, 2010 by Kris Halsrud to Kris Halsrud's Blog
 
Comments

No Comments

Leave a Comment

(required)  
(optional)
(required)  
Add
All contents Copyright © 2010 Customer FX Corporation
Customer FX Corporation
2324 University Avenue West, Suite 115
Saint Paul, Minnesota 55114
Tel: 800.728.5783

  Follow @CustomerFX on twitter
Follow the best news, tips, and articles
  Subscribe to Customer FX on youtube
Watch SalesLogix tutorial videos from Customer FX
Login / Register