Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
New Idea

More control over SLXID's

Status: Comments Requested
by Employee on ‎05-28-2010 11:48 AM

Staying within the constrainsts of using the CHAR(12) field for the ID field on all Tables/Entities, I would like the ability to

  1. Assign a unique key generator to my entities - instead of everything using the "Other" key
  2. Choose the 1 character "prefix" for the internal ID - instead of everything using "Q"
  3. Choose the fomat/calculation for the "Pretty Key" prefix & suffix - instead of having to use the format of "xxxx-xx-xxxxxx" (Opis' SupportExpress allowed this)

Better would be the ability to define your own key - GUID, etc. But short of that...

Allow change to font, color foreground, color background based upon value.

 

Support at a cell and row levels.

 

For example, on a ticket grid change the color of a cell to red background and white foreground if the Needed By date is past due.

In our business we end up using teams as account management but cannot because of the limitations of the program.

Sitekeys modification

Status: Comments Requested
by Bronze Super Contributor nrice on ‎06-04-2012 09:01 AM

Add a column that stores the value for the first digit of a SalesLogix id.

 

Stored procedures to create SalesLogix keys or similar type functionality have to be updated everytime a new keytype comes out.

 

Here is an example:

 

-- Procedure Name: SPR_GetNextKey 
-- Date Created: 08/05/2004 
-- By: John Ostheimer - From code provided on CRM message board
.
.
.
SELECT @NewKey = CASE @KeyType 
WHEN 1 THEN 'A' 
WHEN 2 THEN 'O' 
WHEN 3 THEN 'C' 
WHEN 4 THEN 'B' 
WHEN 5 THEN 'V' 
WHEN 6 THEN 'H' 
WHEN 7 THEN 'E' 
WHEN 8 THEN 'n' 
WHEN 19 THEN 'L' 
WHEN 20 THEN 'Z' 
WHEN 21 THEN 'Y' 
WHEN 22 THEN 'a' 
WHEN 23 THEN 'J' 
ELSE 'Q' 
END

 Since this was released more key types have been added.  Most notiable is probably Ticket, 32.  Storing these values would eliminate a need to update 100's if not 1000's of deployed solutions when keyvalues are added.

 

If the new column is called KeyFirst this is what could be coded to obtain the value

 

declare @keyFirst char(1)

set @keyFirst = 'Q'

select @keyFirst = KEYFIRST from sysdba.SITEKEYS where KEYTYPE = 32

 

 

We want to hear your cool ideas for enhancing Saleslogix products and services. So add your own ideas or kudo (vote) on the ideas of others here! Watch the most valuable bubble to the top!

I have an idea! How do I get started?

One
Read our submission guidelines.

Two
Search for your idea. If you don't see it, submit a new one!

Three
Provide feedback on the ideas of others by voting with kudos and adding comments.
For more information about using ideas, read this thread.

Four
Track your ideas and those you like. Once you've posted or kudoed and idea, subscribe to be notified via email of the latest updates to the idea. From within the idea, click "Idea Options" which appears above the idea title and choose, "Subscribe to this idea".

Be sure to check back from time to time to see new ideas and status updates!

Here is a quick list of the recent ideas for speedy browsing!
Labels