slxdeveloper.com Latest Forum Posts

Re: ShowViewforRecord

slxdeveloper.com Forums — Sun, 14 Mar 2010 10:43:59 GMT

You just want to move from one record in a MV to another, based on ID?

View Post | Reply | Quote | View Thread

Posted by: Phil Parkin on Sunday, March 14, 2010 5:43:59 AM
Forum: SalesLogix Scripting & Customization

ShowViewforRecord

slxdeveloper.com Forums — Sun, 14 Mar 2010 07:45:54 GMT

I don't want to open a new/another form......simply keep the window open and post another record in that form......

must be something simple.....

Set the current ID to another ID Value and refresh the form or something like that?

Thanks!

View Post | Reply | Quote | View Thread

Posted by: RJ Samp on Sunday, March 14, 2010 1:45:54 AM
Forum: SalesLogix Scripting & Customization

Re: KnowledgeSync vs. TaskCentre vs. Custom App

slxdeveloper.com Forums — Sat, 13 Mar 2010 06:07:51 GMT

I would say unless yor need is verry simple Home Grown is rarly cost effective.

We have built a very complex version of what you are talking about using TaskCentre and it does a great Job.

I think KnowledgeSync could do a good job as well but I find TaskCentre easier to build and maintain tasks.
Both products allow HTML sends.

To be fair I have not used KnowledgeSycn in a couple of years, I also think it is more of a personal preference Coke Vs Pepsi type thing.

To really get an Answer to your Question, ( at least the TC v KS part) you would have to talk to somone that has used both recently and regurly and I doubt anyone like that if they plan on continuing to use both will give an opinion.

View Post | Reply | Quote | View Thread

Posted by: Brian Segers on Saturday, March 13, 2010 12:07:51 AM
Forum: Alerts & Workflow

Re: Datagrid using picklist column type

slxdeveloper.com Forums — Fri, 12 Mar 2010 21:57:22 GMT

I had the same problem. I got around it by using a 1-character text field instead of an integer. Apparently datagrids panic whenever they see text headed for a numeric field, even if it will end up with a picklist code instead of the displayed text.

View Post | Reply | Quote | View Thread

Posted by: Karlin High on Friday, March 12, 2010 3:57:22 PM
Forum: Controls

KnowledgeSync vs. TaskCentre vs. Custom App

slxdeveloper.com Forums — Fri, 12 Mar 2010 19:04:49 GMT

A customer is looking to create a ticket escalation process involving numerous automatic email communications. The conditions aren't necessarily complicated (though it'd be nice if complex logic is permitted). Examples include emailing the tech when he is assigned to a ticket, email a manager when a ticket is open and hasn't been updated in 48 hours, and emailing the customer every 48 hours for a Priority 1 ticket. I've had limited exposure to KnowledgeSync and only observed TaskCentre at Insights. I appreciate any feedback as to which product is more flexible, more reliable, has lower TCO, has better support, etc.? Also, with auto-generated emails, do the products permit HTML pages? Thanks!

View Post | Reply | Quote | View Thread

Posted by: Chris Burriss on Friday, March 12, 2010 1:04:49 PM
Forum: Alerts & Workflow

Dynamically populating combo box column type in a grid

slxdeveloper.com Forums — Fri, 12 Mar 2010 16:44:27 GMT

Is there a way to dynamically populate the combo box values in a datagrid column (type combo box)? I have a workaround but this would really be the better solution for me on a particular form.

Maria

View Post | Reply | Quote | View Thread

Posted by: Maria Amodei on Friday, March 12, 2010 10:44:27 AM
Forum: SalesLogix Scripting & Customization

Lookup UseAsResult

slxdeveloper.com Forums — Fri, 12 Mar 2010 10:02:24 GMT

Hi All,

I have been triying to set a column as UseAsResult but when i select the record different column value is show in the lookup textbox .I have made the useasresult as false .What should i do to make sure that the lookup should display the textbox the column value we want?

Thanks,
Pandi

View Post | Reply | Quote | View Thread

Posted by: NagaratnaPandi on Friday, March 12, 2010 4:02:24 AM
Forum: SalesLogix Web Platform & Application Architect

Re: New Nav bar

slxdeveloper.com Forums — Fri, 12 Mar 2010 08:51:10 GMT

Hi,

quick suggestion:
1. Open Architect
2. Select menu File - New Plugin - NavBar/Toolbar
3. In the "Toolbar Strip" dialog click on "Add Child"
4. Enter "Projects" for Caption and Name value
5. Select "NavBar" as Default Dock" and "Large Icons"
6. Add Childs to your new NavBar by clicking on "Add Child"
7. Edit the properties of the new Childs

Hope this is helpful for the first steps.

Have a look at the Sales Toolbar for a detailed example of the properties of the child node within the toolbar.

Cheers,
Thomas

View Post | Reply | Quote | View Thread

Posted by: Thomas Aussem on Friday, March 12, 2010 2:51:10 AM
Forum: SalesLogix Scripting & Customization

Re: Replace does not work

slxdeveloper.com Forums — Thu, 11 Mar 2010 20:34:29 GMT

yup, that's what I figured out minutes after posting the second message

View Post | Reply | Quote | View Thread

Posted by: Dan Carvin on Thursday, March 11, 2010 2:34:29 PM
Forum: SalesLogix Scripting & Customization

Re: Replace does not work

slxdeveloper.com Forums — Thu, 11 Mar 2010 20:14:55 GMT

The problem is that you're using Replace like a sub, expecting it to change the contents of the variable you pass in. It does not work this way, it is a function that returns the changed value.

So instead of this:

Replace strTest,"table","chair"

you must do this:

strTest = Replace(strTest,"table","chair")

It does not modify the contents of the variable, in your case strTest. It only returns the changed value which you must capture into a variable to use it.

Does that make sense?

View Post | Reply | Quote | View Thread

Posted by: Ryan Farley on Thursday, March 11, 2010 2:14:55 PM
Forum: SalesLogix Scripting & Customization

Re: Replace does not work

slxdeveloper.com Forums — Thu, 11 Mar 2010 19:35:29 GMT

DOH!

That should be

strSQL = Replace(strSQL," WHERE "," WHERE (")

nevermind

View Post | Reply | Quote | View Thread

Posted by: Dan Carvin on Thursday, March 11, 2010 1:35:29 PM
Forum: SalesLogix Scripting & Customization

Replace does not work

slxdeveloper.com Forums — Thu, 11 Mar 2010 19:05:42 GMT

I modifying some code in SLX 7.5.1 LAN which builds an SQL query and the VBScript "Replace" function does not seem to work.

Under certain circumstances I need to add an OR condition to the previous conditions in the query. Therefore I need to enclose the existing WHERE clauses in parentheses, then add the OR clause. I'm trying to do it like this:

If [conditions are present] Then
Replace strSQL," WHERE "," WHERE ("
strSQL = strSQL & ") OR [New condition]"
End if

This gets a "Failed to Parse SQL" error and SLXProfiler shows that closing paren and OR condition is added, but the opening paren is not added, which causes the error.

Why would this not work?

View Post | Reply | Quote | View Thread

Posted by: Dan Carvin on Thursday, March 11, 2010 1:05:42 PM
Forum: SalesLogix Scripting & Customization

Re: Custom css class not working

slxdeveloper.com Forums — Thu, 11 Mar 2010 15:55:34 GMT

Ryan,

I added a red label to a TextBox, PersonName, Picklist and Lookup controls. Now I want to add a RequiredFieldValidator on each of them. I changed the corresponing template (.vm) files. It works for TextBox and PickList, but I have the following error for PersonName and Lookup controls:

Control 'QFSLXLookup' referenced by the ControlToValidate property of 'vld_QFSLXLookup' cannot be validated.

How would you do validation on these controls?

Thanks,

BTW, everything is set at design mode.

View Post | Reply | Quote | View Thread

Posted by: Veronka Capone on Thursday, March 11, 2010 9:55:34 AM
Forum: SalesLogix Web Platform & Application Architect

Re: Is there a way to pin tab?

slxdeveloper.com Forums — Thu, 11 Mar 2010 15:42:30 GMT

Of course! Why I did not think about it?

Thank you!

View Post | Reply | Quote | View Thread

Posted by: Veronka Capone on Thursday, March 11, 2010 9:42:30 AM
Forum: SalesLogix Web Platform & Application Architect

Re: No Data shown through Relationship to Contact Entity

slxdeveloper.com Forums — Thu, 11 Mar 2010 15:38:21 GMT

That's because of three simple reasons:

1. I've never customized the WebClient before
2. I am a trainee, so I don't no really how to describe in words what is in my head
3. My english is not the best

View Post | Reply | Quote | View Thread

Posted by: Sebastian Walter on Thursday, March 11, 2010 9:38:21 AM
Forum: SalesLogix Web Platform & Application Architect

Re: No Data shown through Relationship to Contact Entity

slxdeveloper.com Forums — Thu, 11 Mar 2010 15:29:14 GMT

Good stuff! Got there in the end. Your initial description was confusing me slightly

View Post | Reply | Quote | View Thread

Posted by: Nick Hollis on Thursday, March 11, 2010 9:29:14 AM
Forum: SalesLogix Web Platform & Application Architect

Re: Display truncated db field in datagrid

slxdeveloper.com Forums — Thu, 11 Mar 2010 15:17:11 GMT

I saw that DOCUMENTTYPE and wondered why it wasn't populated... guess I could populate it when an attachment is inserted but having the view is simpler and foolproof. Thanks again.

View Post | Reply | Quote | View Thread

Posted by: willis on Thursday, March 11, 2010 9:17:11 AM
Forum: SalesLogix Scripting & Customization

Re: No Data shown through Relationship to Contact Entity

slxdeveloper.com Forums — Thu, 11 Mar 2010 15:09:01 GMT

-deleted-

View Post | Reply | Quote | View Thread

Posted by: Sebastian Walter on Thursday, March 11, 2010 9:09:01 AM
Forum: SalesLogix Web Platform & Application Architect

Re: Display truncated db field in datagrid

slxdeveloper.com Forums — Thu, 11 Mar 2010 15:07:14 GMT

What I have done in the past is to use the DOCUMENTTYPE column for this purpose.

Again, since I had no remotes I relied on SQL Triggers to populate it, but basically this column contained the Extension for each Attachment.

View Post | Reply | Quote | View Thread

Posted by: Raul A. Chavez on Thursday, March 11, 2010 9:07:14 AM
Forum: SalesLogix Scripting & Customization

Re: No Data shown through Relationship to Contact Entity

slxdeveloper.com Forums — Thu, 11 Mar 2010 15:03:57 GMT

It works Thanks man for your help!! I've added a Relationship with contact as parent and NewEntity as child. I think it works, because it cannot work :D

View Post | Reply | Quote | View Thread

Posted by: Sebastian Walter on Thursday, March 11, 2010 9:03:57 AM
Forum: SalesLogix Web Platform & Application Architect

Re: Display truncated db field in datagrid

slxdeveloper.com Forums — Thu, 11 Mar 2010 15:00:02 GMT

P.S. - I used the Contact Firstname as a simple example. I was really after the Attachment File Extension. Creating the view like this gives you a very nice way to display the File Type as a groupable/sortable column in any Attachments grid.

Create VIEW ATTACHMENT_EXT_VIEW as
SELECT ATTACHID, UPPER(RIGHT(FILENAME, 3)) as FILEEXTENSION FROM ATTACHMENT

Could be useful for someone out there.

View Post | Reply | Quote | View Thread

Posted by: willis on Thursday, March 11, 2010 9:00:02 AM
Forum: SalesLogix Scripting & Customization

Re: Display truncated db field in datagrid

slxdeveloper.com Forums — Thu, 11 Mar 2010 14:59:59 GMT

Another method that works (but can't be used if you have remotes) is to:
Use DB Manager create a field with the name that you are looking for (e.g. MYTRUNCATEDFIELD).
Then using SQL Management Studio, modify the field definition and make it a calculated field. And off course, set the formula to what you need it to be.

By doing it this way, the field is built into the Schema that SLX uses for Group builder, Mail Merge, etc and it will return your calculated data.

Again, this is only a good approach if you are not considering any kind of remotes.

View Post | Reply | Quote | View Thread

Posted by: Raul A. Chavez on Thursday, March 11, 2010 8:59:59 AM
Forum: SalesLogix Scripting & Customization

Re: Display truncated db field in datagrid

slxdeveloper.com Forums — Thu, 11 Mar 2010 14:55:40 GMT

That worked Raul! Way to think outside the box. I thought I could have done it easier but that works just fine.

THANKS!

View Post | Reply | Quote | View Thread

Posted by: willis on Thursday, March 11, 2010 8:55:40 AM
Forum: SalesLogix Scripting & Customization

Re: Could Not Establish Connection with SLXServer

slxdeveloper.com Forums — Thu, 11 Mar 2010 14:46:20 GMT

Make sure that:
- The Connection has been properly setup in Connection Manager (go back into it, edit it and click on test, it should work without you having to make any changes).
- Make sure that the SLX Service is running.
- If the SLXSystem is configured to run as a Service, review which account it is running under. I would suggest you don't use the Local System account.
Also, if the SLXSystem is running it, kill it and let it restart. Sometimes it freezes up (specially if it has been loaded for a while) and may cause this type of problems.
- Also, if SLXSystem is not configured to run as a Service, you may want to consider configuring it as a Service.

View Post | Reply | Quote | View Thread

Posted by: Raul A. Chavez on Thursday, March 11, 2010 8:46:20 AM
Forum: General Administration

Re: I need a help with a quick easy script

slxdeveloper.com Forums — Thu, 11 Mar 2010 14:41:55 GMT

On each field, add a When Change Event handler.

Also, make sure you test the State of the Form, if the Form is loading you don't want your script to run..
e.g.

If Not Form.IsReading then 'Form is the name of your Active Form
dteDateCtr.Date = Now()
End If

So, whenever a field is changed (but not when the form is loading), the date control is updated.
Off course, the assumption is that the date control is bound to the DB, so once the record saves it will preserve the value we just populated it with.

View Post | Reply | Quote | View Thread

Posted by: Raul A. Chavez on Thursday, March 11, 2010 8:41:55 AM
Forum: SalesLogix Scripting & Customization

Re: Display truncated db field in datagrid

slxdeveloper.com Forums — Thu, 11 Mar 2010 14:38:00 GMT

How about this:

Create a SQL View with a One to One relationship with the ID field and the calculated field (on SQL):

e.g. CREATE VIEW Acct_Ext_View as
SELECT ACCOUNTID, LEFT(FIELD, 3) AS FIELDX FROM ACCOUNT..

Then enable the View within the DB Manager, and create a Global Join if necessary (otherwise just use a Local Join on your group or Datagrid)....

View Post | Reply | Quote | View Thread

Posted by: Raul A. Chavez on Thursday, March 11, 2010 8:38:00 AM
Forum: SalesLogix Scripting & Customization

Re: Display truncated db field in datagrid

slxdeveloper.com Forums — Thu, 11 Mar 2010 14:28:15 GMT

I tried that. If I create the calculated field using that in the calculation tab, it literally displays in the datagrid column as "LEFT(Brian, 3)"...

View Post | Reply | Quote | View Thread

Posted by: willis on Thursday, March 11, 2010 8:28:15 AM
Forum: SalesLogix Scripting & Customization

Re: Display truncated db field in datagrid

slxdeveloper.com Forums — Thu, 11 Mar 2010 14:21:15 GMT

LEFT(*Field Name*, 3) should do it.

View Post | Reply | Quote | View Thread

Posted by: James Jury on Thursday, March 11, 2010 8:21:15 AM
Forum: SalesLogix Scripting & Customization

Re: Display truncated db field in datagrid

slxdeveloper.com Forums — Thu, 11 Mar 2010 14:10:56 GMT

Thanks James. I thought of that and made an attempt to manipulate the string but it appears you can only do concatenations in the calculation. Is there a way to take only the LEFT 3 characters of a string in a calculated field?

View Post | Reply | Quote | View Thread

Posted by: willis on Thursday, March 11, 2010 8:10:56 AM
Forum: SalesLogix Scripting & Customization

I need a help with a quick easy script

slxdeveloper.com Forums — Thu, 11 Mar 2010 13:58:46 GMT

Hello,

Can someone help me real quick to write a script. I need a script that writes the current date and time to a custom date field when the data changes in a custom field. The form is in the new 6.2.6 format. The form contains 4 custom fields and I have created 4 custom date fields for each field that will not show up on the form. I will have a report that shows the date of the last time the fields were updated.

I don't want to use the record to history function on these fields.

I am running the network version of SalesLogix 6.2.6 on an oracle 10g data base. Hope this makes sense.

Thanks,
Leif

View Post | Reply | Quote | View Thread

Posted by: Leif on Thursday, March 11, 2010 7:58:46 AM
Forum: SalesLogix Scripting & Customization