Login / Register  search  syndication  about

          Jason Buss' Blog

Jason Buss on SalesLogix development & customization, SQL, and more.

Calling Merge Forms in SalesLogix LAN VBScript

Recently, I've been working on a customization which calls for one of a number of Merge Forms to be ran based on certain criteria.  This is a pretty simple process, and here's how I did it:

First of all, I need to get the pluginid for the appropriate Merge Form, based on my criteria.  This can be found in the "Plugin" table, based on the plugin type of 25, and the name of the Form.  In this case, these forms have been created by Admin, so the userid is the standard SYST00000001 value:

Select Case {value}

Case {condition1}

     sPluginID = GetDataValue("pluginid", "plugin", "name = 'MergeForm1' and userid = 'SYST00000001' and type = 25") 

Case {condition2}

     sPluginID = GetDataValue("pluginid", "plugin", "name = 'MergeForm2' and userid = 'SYST00000001' and type = 25") 

Case Else

     sPluginID = GetDataValue("pluginid", "plugin", "name = 'MergeForm3' and userid = 'SYST00000001' and type = 25") 

End Select

After getting the plugin, we just need to use the "MergeFromPlugin" function within SalesLogix.  This function takes a few parameters:  The first, PluginID, is simply the pluginid that I got from the case statement.  The second parameter is the Merge mode.  1 = Email, 2 = Fax and 3 = Letter.  The next parameter is ContactID, and the final parameter is OpportunityID.  The OpportunityID parameter is optional to this function.


application.BasicFunctions.MergeFromPlugin sPluginID, 2, sContactID, sOpportunityID

That's all there is to it!  This function will return a True if the merge is performed successfully, and false if not.

 Thanks for reading!  I hope you find this helpful.  :)

What's This?
  
Bookmark and Share

About Jason Buss

   Jason is a senior application developer with Customer FX.



Related Content
   Can the SalesLogix Application architect's build process be automated?
Can the SalesLogix Application architect's build process be automated, or called from a batch file? W
Posted on May 16, 2013 by SalesLogix Support to SalesLogix Questions & Answers
 
   Is it possible to Sync SalesLogix Attachments based on Account Manager?
Is it possible to only sync SalesLogix Attachments from the accounts where the user is the account manag
Posted on May 15, 2013 by SalesLogix Support to SalesLogix Questions & Answers
 
   SalesLogix Remote Library Management
Is it possible to log into a SalesLogix Remote Database as Admin and Manage the Library Files?
Posted on May 14, 2013 by SalesLogix Support to SalesLogix Questions & Answers
 
   Demystifying SalesLogix Web: Dashboards and Analytics Tools
Join us for a free webinar, Wednesday, May 15th at 2pm CDT. The SalesLogix Web dashboards and analytics
Posted on May 08, 2013 by Brianna Tinjum to The Inbox
 
   What is the Difference Between Left Joins and Inner Joins in SalesLogix?
Question: What is the difference between Left joins and Inner joins in SalesLogix?
Posted on May 07, 2013 by SalesLogix Support to SalesLogix Questions & Answers
 
Comments

No Comments

Leave a Comment

(required)  
(optional)
(required)  
Add
All contents Copyright © 2013 Customer FX Corporation
Customer FX Corporation
2324 University Avenue West, Suite 115
Saint Paul, Minnesota 55114
Tel: 800.728.5783

  Follow @CustomerFX on twitter
Follow the best news, tips, and articles
  Subscribe to Customer FX on youtube
Watch SalesLogix tutorial videos from Customer FX
Login / Register