CRM Developer - All Comments

re: ReadOnly and Disabled Fields

Geraldine — Mon, 29 Jun 2009 10:13:23 GMT

I need to enable a disabled datetime field. I have tried enabling it thru "crmForm.all.<new_datefield>.Disabled = false;". The datepicker is available for date pick. But the selected date that display on the date field is disabled. It does not allow manual entry into the field. Any idea how to resolve this? Thanks

re: How to: Execute a file/program in VBScript

Egon — Fri, 26 Jun 2009 17:49:51 GMT

Nice Comand Ryan

Now Im try to install a program into the script how I make the instalation with out the next bottons,

I want the script install all the program for me automatically

could yo helpme with this ?

re: Extracting Reports from the SalesLogix Plugin Table from External Applications

karim — Fri, 26 Jun 2009 10:11:32 GMT

nice & very helpful article

re: Consuming Web Services from SalesLogix VBScript

Jim — Thu, 25 Jun 2009 16:01:14 GMT

Hi! Excellent blog!

I have tried to resolve the first name / last name of the current user via javascript in the onLoad function of an account form. It works with the UserId (using the WhoAmI / SOAP thing):

var userid = xmlDoc.getElementsByTagName("UserId")[0].childNodes[0].nodeValue;

See www.crowehorwath.com/.../hide-show-fields-in-crm-4-0-based-on-security-role.aspx

How on earth do I get the first name and last name? I tried to use the information from your code, but the following didnt work:

var userid = xmlDoc.getElementsByTagName("User")[0].childNodes[0].Text;

Any ideas? Truely appreciate your help.

Jim

re: Making Required Fields More Visible for SalesLogix 7.2 Web

Ryan Farley — Mon, 22 Jun 2009 15:38:28 GMT

Hi Chris,

The only way to get rid of the red asterisk (last time I checked) was to modify the control template itself in the VFS to use a less noticable char or to use the image itself in place of the char.

re: Making Required Fields More Visible for SalesLogix 7.2 Web

Chris Grant — Mon, 22 Jun 2009 07:54:27 GMT

When I try this in V7.5.1 you get the red aster showing over the top of the icon. Any ideas on how to remove this... Thx

re: Public SalesLogix Web Developer Classes On The Way

Ram — Fri, 19 Jun 2009 08:44:43 GMT

I am intrested in the training. I am from india. Is it possible to attend the classes and pay the fees from here

re: Filtering a DataGrid in SalesLogix Web at Runtime

Ryan Farley — Fri, 05 Jun 2009 15:58:12 GMT

Hi Tom,

I would put that rule to return the empty list in the same entity as what you want to end up binding to the grid at runtime. For example, if you are going to be binding up a list of IAccount at runtime, put your rule, and the rule that returns the empty list of IAccount there (on the Account entity). This way it makes it possible to set up columns for the grid based on what the Account entity has.

-Ryan

re: Filtering a DataGrid in SalesLogix Web at Runtime

Tom — Tue, 02 Jun 2009 15:21:49 GMT

How would I accomplish this on an entity-less form? Where would I create the business rule that returns blank data?

re: Binding a Grid to a List Returning Business Rule using GetByMethod

Ryan Farley — Tue, 02 Jun 2009 07:18:40 GMT

Tom,

Shouldn't make a difference. If you're binding the results of the rule to a grid then make sure your rule is returning

System.Collections.Generic.IList<Sage.Entity.Interfaces.IAccount>

instead of just 'object'. Could that be what is causing your issue?

re: Binding a Grid to a List Returning Business Rule using GetByMethod

Tom — Tue, 02 Jun 2009 07:12:37 GMT

How do I do this for an entity-less form? I just want to create a custom account lookup on an entity-less form.

1. I added the business rule at the Account entity

2. Trying to bind the grid, per your instructions on no.4 "Source = Account" the DataSource "Source" property blanks out whenever I set it to Account?

Is this not possible at an entity-less form? Or is there a different way to do it?

Twitted by 4SalesLogix

Twitted by 4SalesLogix — Sat, 30 May 2009 19:49:10 GMT

Pingback from Twitted by 4SalesLogix

re: ReadOnly and Disabled Fields

Manoj Talwar — Wed, 27 May 2009 10:38:58 GMT

Sorry, read its as follows:

crmForm.all.<datefield>.all.time.disable();

and to enable it back:

crmForm.all.<datefield>.all.time.enable();

re: ReadOnly and Disabled Fields

Manoj Talwar — Wed, 27 May 2009 09:16:49 GMT

To disable the time portion of date field, the code is:

crmForm.all.<datefield>.all.time.disabled();

and to enable it back:

crmForm.all.<datefield>.all.time.enabled();

Does anybody know how to disable/enable the date portion?

re: Setting the Default Sort for a DataGrid in SalesLogix Web REVISITED

Chris Kepert — Fri, 22 May 2009 00:59:07 GMT

Hi,

Firstly, thanks again Ryan for your posts - they're an excellent resource for SLX Web Dev hich is devoid of documentation. (Sage if you are listening, I am appalled! You're API ref is generated by a tool!!)

However, on this occaision I also was not able to get the code above working on its own.

My situation was as follows:

1. I have a custom entity that is related as achild from the contact.

2. I have a page with a grid view displaying these in the tab pane of my contact page (i.e. entity (object) datasource from a property of my contact entity).

3. I needed the records to be sorted by one of the fields (descending) by default

4. I tried the above code, but it just came up in ID order. Some investigation showed that in this instance at least, the SLX page lifecycle clobbered the onload script code.

Here are the additional things I had to do:

1. Obvious but required - set the enable sorting on the grid to true

2. IsSortable on the column to be sorted by to true also (not sure if this is actually required, but makes sense to do it).

3. Set the SortField if not set already. Take note of the value as this is what you sshould use in your sort expression.

Code as follows on the onload action:

// get a reference to the underlying ASP.NET datagrid

System.Web.UI.WebControls.GridView grid = (System.Web.UI.WebControls.GridView)form.grdMonthlyPlaySummarys.NativeControl;

// only setting default, so check to see whether we already have a sort expression

if (string.IsNullOrEmpty(grid.SortBLOCKED EXPRESSION

{

// set the desired sort order

grid.Sort("Playmonth", System.Web.UI.WebControls.SortDirection.Descending );

// databind to force changes

grid.DataBind();

}

</script>

And that is it!

Chris

Distributing SQL Views to Remote SalesLogix Databases

The Integration Blog — Wed, 13 May 2009 16:16:05 GMT

There have been a couple occurrences where a client has required SQL views be used within their SalesLogix

re: Elegant SalesLogix Table ID Class in C#

Jim Forte — Fri, 08 May 2009 19:35:50 GMT

Question. I am trying to build a contactID outside of windows in perl, using freeTDS. Any thoughts on how I can build it without the functions built into sales logix?

re: Determining if a User is a Member of a Team in SalesLogix Web

Aron H. — Thu, 07 May 2009 15:17:58 GMT

Just what I was looking for, thanks Ryan!

re: Accessing the Current Parent Entity from a Code Snippet Action

Chris — Thu, 07 May 2009 03:30:37 GMT

Thanks for the post Ryan, much appreciated.

Doing first SLX 7.5 development at the moment and this is the second time you've saved me a fair amount of research through your blogs.. Ta!

re: Setting the Default Sort for a DataGrid in SalesLogix Web REVISITED

Alexander Pfingstl — Mon, 04 May 2009 17:44:48 GMT

Hi, Yes, the property I am sorting is in the grid. Perhaps I did a mistake, but I am not sure where it is, as I posted my code and it looks quite as yours. Do I have to put the entity property name in the sort order (as I did) or the column name of the grid?

As I said, I tried also with the AccountContacts grid, adding a LastName column and doing the code you provided.

Would relay love to get it working as I realy need it!! Thanks for you ideas and help!

re: Setting the Default Sort for a DataGrid in SalesLogix Web REVISITED

Ryan Farley — Mon, 04 May 2009 17:26:37 GMT

Alexander, there has to be something missing somewhere. I have this working fine in several 7.5.1 systems without issue. Is the property you're sorting by a column in the grid?

re: Setting the Default Sort for a DataGrid in SalesLogix Web REVISITED

Alexander Pfingstl — Mon, 04 May 2009 17:17:23 GMT

Hi Ryan, Well I looked at the entity and the property was spelled like this.

Also I tried it with the AccountContacts grid. I first tried with the LastNem,FirstName column, as this turned out not to work, I tried inserting a new column databound to LastName and tried it there. No way.

I did this as a load action and I also set the onrepaintevent to true.

I can try tomorrow again, but I think I have not overloked something.

Just followed your example. And normally they work quite well!!

re: Setting the Default Sort for a DataGrid in SalesLogix Web REVISITED

Ryan Farley — Mon, 04 May 2009 16:03:03 GMT

Alexander, make sure your property name you are sorting by is correct, including case (for example, you have "Servicedate", could it possibly be "ServiceDate"?)

Also, I assume this is on a LoadAction? Make sure you set the LoadAction's OnRepaintEvent to true.

re: Setting the Default Sort for a DataGrid in SalesLogix Web REVISITED

Alexander Pfingstl — Mon, 04 May 2009 12:53:02 GMT

Hi Ryan,

Thanks for the article. I am not sure what I am doing wrong.

For me it is not working. I see no sort change. Tried with two forms and nothing is sorting.

I also tried writing the code in vs2008 and putting it in as an external assembly.

No chance.

Here is my code:

public static void LoadServices(IAccountServices_mcc form, EventArgs args)

{

System.Web.UI.WebControls.GridView grid = (System.Web.UI.WebControls.GridView)form.grdC_Services.NativeControl;

grid.Sort("Servicedate", System.Web.UI.WebControls.SortDirection.Descending);

}

I use slx 7.5.1.

Thanks!

Alexander

re: RESTful Web Services Coming in SalesLogix 7.5

NixDev — Fri, 24 Apr 2009 23:56:32 GMT

Hello Ryan. As always your articles are interesting. Please note that (at least as of SLX 7.5.1) the URI for querying SData has changed a bit from your post. I don't have it now, but its a bit different (this had me head scratching a few minutes until I figured out).