Articles by Jason Buss

Changing text alignment on Numeric controls in InforCRM

In many interfaces, numeric values tend to be right justified.  In InforCRM however, all controls display their information with the text aligned to the left of the control.  Recently I was asked about changing the text alignment of numeric controls to display the text to the right in the control.  While InforCRM doesn't expose a text-alignment property in their controls, it is possible to set the style.textAlign property of the composite N...

Load order issue in Infor CreateUnicodeDB utility

I recently bumped into an issue with the order in which the utility (CreateUnicodeDB) creates database objects.  SQL Users and schemas are processed first, followed by SQL tables, followed by the other SQL objects.  In this particular database, there were scalar UDFs being used to create computed columns in a number of the SQL tables.  Since the utility creates Tables before UDFs, it would error out on any table referencing that non-existent U...

Installing Web Manifests in InforCRM

I wanted to take a moment to briefly document how to install web manifests in InforCRM. This is pretty basic functionality, but I thought it would be helpful to have it documented here as a reference. So, without further ado:

Using Computed columns to create an Email link on a standard ICRM web datagrid

Recently, I had a request to build functionality that would allow a user to send an email based on information in a datagrid row. Here is an outline of how I put that functionality together. The form contains a standard datasource/datagrid setup (Note, this does not work with an editable datagrid). In addition to any other functionality on the form, we also need to add two objects: A Hidden Text control, and a button on the form. The Hidde...

Editable Grid modifications/deployments with new entity properties in InforCRM (Saleslogix)

I was working on an editable datagrid, adding two new columns from a couple of field properties that I had just added to the entity model. After I made my changes, built the web platform and deployed, my new columns were not showing up in the datagrid. "Oh well", I thought, "Sometimes you have to rebuild everything for a change to come across". So, I deleted everything from my build folders to force a full rebuild. I also deleted everything f...

Using Global Script functions in InforCRM

I recently had a project that required me to be able to check if a user belonged to a particular team. A previous post by Ryan showed me how to query team membership, but rather than setting this up as a Business Rule, I wanted to create it as a Global function that could be called from anywhere without having to worry about instantiating an entity to access the business rule. Instead of creating a business rule, I created a Global CS script...

Adding a report link to the Common Tasks pane in Infor CRM (formerly Saleslogix)

When you are viewing an Entity Detail page, the Common Tasks pane on the right of the page provides a number of links to perform common tasks, such as Mail Merges, Emails and creating activities for the current entity record. By making a couple modifications, we can add a link to run a report from this section I'm going to demonstrate how to add a report link to the Account Entity. Account should already have a link to run the Account De...

Limiting a Product lookup to current Account Product records in Infor CRM (Formerly Saleslogix)

I recently worked on a project which contained a Product Lookup control on an Account-level tab. In this case, the lookup is only supposed to return products that are also AccountProducts for the current Account. To do this, you can set the Lookup control to pull from the AccountProduct entity, then use code to save the Product from that entity and save it to your custom entity. In your lookup control: Set the Lookup Binding Mode to "Obj...

Problem with the Clean Build Folders option in Application Architect

On occasion, it becomes necessary to clean out the build folders and deployed website prior to a build/deploy, in order to force changes to become available. In version 8.1, Saleslogix provides a handy menu option to clear out the build folders. Unfortunately, using this menu item also seems to temporarily break it's own ability to build by causing some of the folders in that build path to become read-only, as shown below:

Pivoting data in SQL (Part 2)

In the past, I've written about pivoting data in SQL, and I wanted to post a quick follow-up showing basically how to rotate the data back into a single column. My source data consists of a recordID field, then 5 different boolean fields representing a different type value:

Subscribe To Our Newsletter

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

You have Successfully Subscribed!