Lime links

Lime links are direct shortcuts to a record or a feature in Lime CRM. Examples of where Lime links are used in Lime CRM is in the “Please call” feature, Super Search results window and in action pads.

You can also build your own Lime links. The following links could for example be embedded in web page:

<a href="limecrm:company.lundalogik.cosmo?command=open&name=Greenland%20Fir%20Trees%20AB">Greenland Fir Trees AB </a>

<a href="limecrm:plant.lundalogik.cosmo?command=new">Create new spruce plantation</a>

A Lime link follows this formatting scheme:

limecrm:CLASS.DATABASE.LIMESERVER?command=COMMAND[&PARAMETER=VALUE]

An example of a Lime link that opens a specific record and where CLASS refers to the database name of a table:

limecrm:company.lundalogik.cosmo?command=open&idcompany=1001

If a table label were to be used instead the link should look like this:

limecrm:1.lundalogik.cosmo?command=open&idcompany=1001

Executing the link will open the company record having ID 1001 in the database Lundalogik on the server named cosmo.

The open command opens the specified record in Lime CRM. The record ID must be specified as a parameter having the name id«classname», e.g. idcompany.

Available parameters:

Open the company having record ID 1001 in the Lundalogik database on server cosmo:

limecrm:company.lundalogik.cosmo?command=open&idcompany=1001

The short version:

limecrm:company.lundalogik.cosmo?1001

Open the company having the name Lundalogik AB in the city of Lund:

limecrm:company.lundalogik.cosmo?command=open&name=Lundalogik%20AB&city=Lund

Note that all values need to be URI encoded. The VBA function Application.UriEncode can be used for this purpose.

The new command creates a new record and can also open it afterwards. To create a new history record associated with a company:

limecrm:history.lundalogik.cosmo?command=new&ownerclass=company&ownerid=1001

Available parameters (all optional):

Create a new history record:

limecrm:history.lundalogik.cosmo?command=new

Create a new history record with the company having ID 1001 as parent:

limecrm:history.lundalogik.cosmo?command=new&ownerclass=company&ownerid=1001

Create a new history record with the select company as the parent and the text Talked to Lisa Johnson as the text and the alternative Sales call as category:

limecrm:history.lundalogik.cosmo?command=new&ownerclass=company&ownersource=activeexplorer&category=Sales%20call&text=Talked%20to%20mLisa%20Johnson

The mailto command creates a new e-mail message in the same manner as when an e-mail address is clicked by the user in Lime CRM. The following link creates an e-mail for Nisse at Manpower:

limecrm:person.lundalogik.cosmo?command=mailto&address=nisse@manpower.se

Available parameters (all optional):

By using the callto command Lime CRM is instructed to dial the specified phone number. This can typically be used to easily dial a number from an action pad.

The following is a Lime link that dials Lundalogik Customer Support when executed:

limecrm:person.lundalogik.cosmo?command=callto&number=+46462704800

Available parameters:

The appointment command creates a new meeting and a to-do item in the same manner as when using the New meeting… command is used in Lime CRM.

The following example creates an appointment with the person having record ID 1001 and sets the subject to Lime CRM kick-off:

limecrm:todo.lundalogik.cosmo?&command=appointment&ownerclass=person&ownerid=1001&subject=Lime%20kick-off

Note that the CLASS parameter is todo here since a to-do item will be created.

Available parameters (all optional):

Create a new, empty appointment:

limecrm:todo.lundalogik.cosmo?&command=appointment

Create a new appointment with the person having record ID 1001:

limecrm:todo.lundalogik.cosmo?&command=appointment&ownerclass=person&ownerid=1001

Create a new appointment with the company having record ID 2001:

limecrm:todo.lundalogik.cosmo?&command=appointment&ownerclass=company&ownerid=2001

Create a new appointment with the company having record ID 2001 and set the subject to Lime CRM kick-off:

limecrm:todo.lundalogik.cosmo?&command=appointment&ownerclass=company&ownerid=2001&subject=LIME%20Pro%20kickoff

Create a new appointment for an activity having record ID 3001. Note that the behavior here is completely dependent on the database structure since the activity table may or may not have a name field or a person or company associated with it.

limecrm:todo.lundalogik.cosmo?&command=appointment&ownerclass=activity&ownerid=3001

The log command adds a new log record to the Information log tab (Administrators only). The following example creates a new log record:

limecrm:infolog.lundalogik.cosmo?command=log&type=0&source=My%20app&location=My%20method&number=1234&message=dooh

Available parameters:

0 - Information 1 - Warning 2 - Error 3 - Audit success (default) 4 - Audit failure |

In addition to the built-in commands it is possible to define custom commands that are processed in VBA by listening to and handling the Application.ExecuteURL event which receives the following parameters:

Given the following Lime link:

limecrm:company.MyDatabase.MyServer?command=mycommand&param1=1501&param2=1601

…the event parameters will receive the following values:

The following code sample shows how a custom command that opens a web browser with the URL set to the contents of any present field having the “Homepage, work” label.

Private Sub Application_ExecuteURL(ByVal Class As LDE.IClass, ByVal Command As String, ByVal Parameters As String,                                                     Handled As Boolean)
 
   ' Handle Lime shortcuts on the following format:
   '    limecrm:company.MyDatabase.MyServer?command=openwebsite&id=15099001
 
   Dim fieldUrl As LDE.Field
   Dim rec As LDE.Record
   Dim viewUrl As LDE.View
   Dim i As Integer
   Dim parameter As String
   Dim parameterArray() As String
   Dim recordId As Long
 
   If Command = "openwebsite" Then
     ' Find the business homepage field by looking at field labels
       Set fieldUrl = Class.Fields.Lookup(FieldLabelEnum.lkFieldLabelBusinessHomePage,
                                               LookupFieldEnum.lkLookupFieldByLabel)
 
       If Not fieldUrl Is Nothing Then
           ' Find the id=xxxx parameter and extract the record ID
 
           parameterArray = Split(LCase(Parameters), "&")
 
           For i = LBound(parameterArray) To UBound(parameterArray)
               If Left(parameterArray(i), 3) = "id=" Then
                   recordId = CLng(Mid(parameterArray(i), 4))
                   Exit For
               End If
           Next
 
           If recordId <> 0 Then
               ' Open the record and retrieve the web site address
 
               Set rec = New LDE.Record
               Set viewUrl = New LDE.View
 
               viewUrl.Add fieldUrl.Name
 
               rec.Open Class, recordId, viewUrl
 
               If Len(rec(fieldUrl.Name)) > 0 Then
                   ' Launch the web browser
                   Shell rec(fieldUrl.Name)
 
                   ' Tell Lime that we were able to successfully handle the event
                   Handled = True
               Else
                   MsgBox "The specified record is not associated with a web site.", vbInformation
               End If
           End If
       End If
   End If
 
End Sub

To simplify the creation and execution of Lime links Lundalogik provides a Javascript helper class that can be found in the scripts folder located in the actionpad folder.

This function can be used with all commands and has the advantage that only one call to LimeUrl needs to be done to both create and execute the link command.

LimeUrl.Execute = function(classname, command, options)

Open the company record having ID 1001 and set the tab pointed to by the employees relation field to active:

LimeUrl.Execute('company', 'open', {
             idrecord: '1001',
             activeexplorer: 'employees'
           });

Create a new history record and associate it with the currently selected company record:

LimeUrl.Execute('history', 'new', {
             ownerclass: 'company',
             ownersource: 'activeexplorer'
           });

The same as above, but for embedded use in e.g. an actionpad:

<a href="#" onclick="javascript:LimeUrl.Execute('history', 'new', {
             ownerclass: 'company',
             ownersource: 'activeexplorer'
           });">Skapa historik</a>

Creates a Lime link with the specified command as its only parameter.

LimeUrl.Create = function(classname, command)

To create a link that creates a new history record:

LimeUrl.Create('history', 'new');

This results in the following link:

limecrm:history.MyDatabase.MyServer?command=new

Adds a parameter to a link that was created using a call to LimeUrl.Create.

LimeUrl.AddParameter = function(name, value)

To add parent record and contact person to the link that was created in the previous example:

LimeUrl.AddParameter('ownerclass', 'company');
LimeUrl.AddParameter('ownerid', '1001');
LimeUrl.AddParameter('contactperson', 'Johnny Doe');

This results in the following link:

limecrm:history.MyDatabase.MyServer?command=new&ownerclass=company&ownerid=1001&contactperson=Johnny%20Doe

Executes the Lime link created using LimeUrl.Create and optionally LimeUrl.AddParameter. This method does not accept any arguments.

LimeUrl.Click();