Onboarding of @#Cust_Company_Name (e.g. Onboarding of Colorado University)
Dynaforms
Main ( ? )
Input Documents
Finance: Credit document - Case support document.
Output Documents
Support: Welcome Support Email Template.
External Data Base Connections
Account and Opportunity information from SUGARCRM database
Plug ins and Programming Development
...
Panel
title
Task 1.1. Register Sales
Users
Sales Executive Group
Assignment Rule
Value Based Assignment
Variable = @@salesExecutiveId
Duration
1 Day
Count Days By = Work Days
Data Base Connections
SUGARCRM
Step 1.
Name: Sugar Connect
Type: Trigger
Step 1
Name: Sugar Connect
Type: Trigger
Creates the connection to SugarCRM
Step 2.
Name: Sugar Login
Type: Dynaform
It opens a form for the credentials to log in the SUGARCRM (User and Password)
Field Name
Label
Data Type
Read Only
Description
Source
1
@@SugarUserName
User Name
Text
False
User
2
@@SugarPassword
Password
Text
False
Mask ***** (Password)
User
Step 3.
Name: Sugar User Opportunities
Type: Dynaform
After the user has logged in, PM will show a form with 2 sections
Field Name
Label
Data Type
Description
Source
1
@@sugarUserName
User Name
Text [xxx]
Non-Editable / Section 1
User
2
@@sugarAccount
Account
Dropdown
Section 2 - Dependent to @#sugarUserName
From SUGARCRM
"SELECT ACCOUNT_NAME, ACCOUNT_NAME FROM PM_SUGAR_OPPORTUNITIES WHERE ASSIGNED_USER_NAME='@#sugarUserName' GROUP BY ACCOUNT_NAME ORDER BY ACCOUNT_NAME"
3
@@sugarOpportunities
Opportunities
Grid (?)
Section 2 - Dependent to @#sugarAccount
From SUGARCRM
SELECT ID_OPPORTUNITY, CONCAT(OPPORTUNITY_NAME," (",OPPORTUNITY_DESCRIPTION,")") FROM PM_SUGAR_OPPORTUNITIES WHERE ACCOUNT_NAME="@#sugarAccount"
Step 4.
Name: Sugar CRM Final Selection
Type: Dynaform
Field Name
Label
Data Type
Read Only
Description
Source
1
@@SUGARCRM_ACCOUNT_NAME
Account name
Text
True
Non-Editable / Section 1 -
Dependent to @#sugarAccount
SUGARCRM
2
@@SUGARCRM_ACCOUNT_DESCRIPTION
Description
Text
True
Non-Editable / Section 1
SUGARCRM
3
@@SUGARCRM_ACCOUNT_TYPE
Type
Text
True
Non-Editable / Section 1
SUGARCRM
4
@@SUGARCRM_ACCOUNT_INDUSTRY
Industry
Text
True
Non-Editable / Section 1
SUGARCRM
5
@@SUGARCRM_ACCOUNT_PHONEFAX
Phone/Fax
Text
True
Non-Editable / Section 1
SUGARCRM
6
@@SUGARCRM_ACCOUNT_BILLING_ADDRESS_STREET
Billing Address Street
Text
True
Non-Editable / Section 1
SUGARCRM
7
SUGARCRM_ACCOUNT_BILLING_ADDRESS_CITY
Billing Address City
Text
True
Non-Editable / Section 1
SUGARCRM
8
@@SUGARCRM_ACCOUNT_BILLING_ADDRESS_STATE
Billing Address State
Text
True
Non-Editable / Section 1
SUGARCRM
9
@@SUGARCRM_ACCOUNT_BILLING_ADDRESS_POSTALCODE
Billing Address PO
Text
True
Non-Editable / Section 1
SUGARCRM
10
@@SUGARCRM_ACCOUNT_BILLING_ADDRESS_COUNTRY
Billing Address Country
Text
True
Non-Editable / Section 1
SUGARCRM
11
@@SUGARCRM_ACCOUNT_EMAIL
Email
Text
True
Non-Editable / Section 1
SUGARCRM
12
@@SUGARCRM_ACCOUNT_PHONE_OFFICE
Phone Office
Text
True
Non-Editable / Section 1
SUGARCRM
13
@@SUGARCRM_ACCOUNT_WEBSITE
Website
Text
True
Non-Editable / Section 1
SUGARCRM
14
@@SUGARCRM_SELECTED_OPPORTUNITIES
Services Selected
Grid
True
No add Rows
No Delete Rows
SUGARCRM
15
Grid Field - SUGARCRM_OPPORTUNITY_ID
hidden
SUGARCRM
16
Grid Field - SUGARCRM_OPPORTUNITY_NAME
Opportunity Name
Text
True
Non-Editable / Section 2
SUGARCRM
17
Grid Field - SUGARCRM_OPPORTUNITY_TYPE
Type
Dropdown
True
Non-Editable / Section 2
SUGARCRM
18
Grid Field - SUGARCRM_OPPORTUNITY_AMOUNT
Amount
Text
True
Non-Editable / Section 2
SUGARCRM
19
Grid Field - SUGARCRM_OPPORTUNITY_DESCRIPTION
Description
Text Box
True
Non-Editable / Section 2
SUGARCRM
20
@@SUGARCRM_ACCOUNT_CONTACTS
Contacts SugarCRM
grid
True
Allow to Delete Rows
No add rows
SUGARCRM
21
Grid Field - SUGARCRM_ACCOUNT_CONTACT_ID
hidden
hidden
22
Grid Field - SUGARCRM_ACCOUNT_CONTACT_FIRST_NAME
First Name
Text
False
User
23
Grid Field - SUGARCRM_ACCOUNT_CONTACT_LAST_NAME
Last Name
Text
False
User
24
Grid Field - SUGARCRM_ACCOUNT_CONTACT_PHONE_MOBILE
Mobile
Text
False
User
25
Grid Field - SUGARCRM_ACCOUNT_CONTACT_PHONE_WORK
Work phone
Text
False
Mask XXX-XXX-XXXX
User
26
Grid Field - SUGARCRM_ACCOUNT_CONTACT_EMAIL1
Email
Text
False
User
27
Grid Field - SUGARCRM_ACCOUNT_CONTACT_TYPE
Type
Dropdown
False
Technical
Financial (Financal ?) validate Sugar (?)
Business
Other
User
28
Grid Field - SUGARCRM_ACCOUNT_CONTACT_NOTES
Notes
Text Box
False
User
29
Grid Field - None
Delete
Button
False
Allows to delete the contact row
User
30
@@ADDITIONAL_CONTACTS
Additional Contacts
Grid
False
Add and Delete is permited (?)
User
31
Grid Field - ADDITIONAL_CONTACT_FIRST_NAME
First Name
Text
False
User
32
Grid Field - ADDITIONAL_CONTACT_LAST_NAME
Last Name
Text
False
User
33
Grid Field - ADDITIONAL_CONTACT_PHONE_MOBILE
Mobile
Text
False
User
34
Grid Field - ADDITIONAL_CONTACT_PHONE_WORK
Work Phone
Text
False
User
35
Grid Field - ADDITIONAL_CONTACT_EMAIL1
Email
Text
False
User
36
Grid Field - ADDITIONAL_CONTACT_TYPE
Type
Dropdown
False
Technical
Financial (Financal ?) validate Sugar (?)
Business
Other
User
37
Grid Field - ADDITIONAL_CONTACT_NOTES
Notes
Text
False
User
38
@@BILLING_ADDRESS_TO_USE
Billing Address to Use
Radio Group
False
Required
SELECT CONTACT_ID,CONCAT(LAST_NAME," ",FIRST_NAME, " (",PRIMARY_ADDRESS_STREET,", ",PRIMARY_ADDRESS_CITY,", ",PRIMARY_ADDRESS_STATE,", ",PRIMARY_ADDRESS_POSTAL_CODE,", ",PRIMARY_ADDRESS_COUNTRY,")") FROM PMT_PM_SUGAR_CONTACTS WHERE ACCOUNT_NAME=@@sugarAccount
User
39
Subtitle Information
Subtitle
Please review carefully the information in this form. If there is something to chenge you may access SugarCRM and then restart the case
40
Submit Button
Submit Button
Validate Sugar Info (See JavaScript)
JavaScript Validations
Validation
Code
Validate Sugar Information On Submit
var dynaformOnload = function(){ validateSugarInfo(false); }
function validateSugarInfo(sw_submit){ errorMessage="";
fieldsToValidate = new Array('SUGARCRM_ACCOUNT_NAME','SUGARCRM_ACCOUNT_BILLING_ADDRESS_STREET','SUGARCRM_ACCOUNT_BILLING_ADDRESS_CITY','SUGARCRM_ACCOUNT_BILLING_ADDRESS_STATE','SUGARCRM_ACCOUNT_BILLING_ADDRESS_COUNTRY'); //fieldsToValidate = new Array('SUGARCRM_ACCOUNT_NAME'); for(i in fieldsToValidate){
if(errorMessage!=""){ title="<font color='red'>ERROR!</font><b> Some required fields were not filled in Sugar</b><br /><br />"; bottom = "<hr><i>Please complete it in SugarCRM</i>" //msgBox(title+errorMessage, 'info', false); msg=title+errorMessage+bottom; new leimnud.module.app.info().make({ label: msg, width: 450, height: 250, }); }else{ if(sw_submit){ //alert("submitForm"); submitForm(); }else{ //alert("nothing"); } } }
Step 5.
Name: Service Information
Type: Dynaform
Field Name
Label
Data Type
Read Only
Description
Source
1
@@Account_Exec
Account Executive
Text
True
Disable / Sales Manager who started the process
Register Sale Task
2
Customer Invoicing Information
Subtitle
New Section
3
@@Cust_Company_Name
Company Name
Text
True
Disable / Customer Invoicing Information
SUGARCRM
4
@@Cust_First_Name
First Name
Text
True
Disable / Customer Invoicing Information
SUGARCRM
5
@@Cust_Last_Name
Last Name
Text
True
Disable / Customer Invoicing Information
SUGARCRM
6
@@Cust_Email
Email Address
Text
True
Disable / Customer Invoicing Information
SUGARCRM
7
@@CustomerAddress1
Address Line 1
Text
True
Disable / Customer Invoicing Information
SUGARCRM
8
@@CustomerAddress2
Address Line 2
Text
True
Disable / Customer Invoicing Information
SUGARCRM
9
@@CustomerCity
City
Text
True
Disable / Customer Invoicing Information
SUGARCRM
10
@@CustomerState
State
Text
True
Disable / Customer Invoicing Information
SUGARCRM
11
@@CustomerPostCode
Zip / Postal Code
Text
True
Disable / Customer Invoicing Information
SUGARCRM
12
@@Cust_Country
Country
Text
True
Disable / Customer Invoicing Information
SUGARCRM
13
@@Cust_Work_Phone
Work Phone Number
Text
True
Disable / Customer Invoicing Information
SUGARCRM
14
@@CustomerCellphone
Cellphone Number
Text
True
Disable / Customer Invoicing Information
SUGARCRM
15
@@CustomerFax
Fax
Text
True
Disable / Customer Invoicing Information
SUGARCRM
16
Invoicee Information
Subtitle
New Section
17
@@invoicee
Invoicee
Text
False
Invoicee Information - Hint: Please edit and insert correct name and address ONLY if invoicee information is different from account information in SugarCRM
Current Task
18
Additional Customer Information
Subtitle
New Section
19
@@ACCOUNT_REGION
CustomerRegion
Dropdown
False
Pending - SELECT REGION_ID, REGION_NAME FROM PMT_CUSTOMER_REGION
Current Task
20
@@Cust_TimeZone
Customer Timezone
Dropdown
False
Pending - SELECT GMT,NAME FROM PMT_TIMEZONES
Current Task
21
@@Cust_PO_Number
Customer PO Number (If given)
Text
False
Editable / Additional Information
Current Task
22
@@Cust_Extra_Information
Additional Information / Special Requests
Text Box
False
Additional Information
Current Task
23
@@Upload_Customer_Order
Customer Order Form
File
False
Additional Information - Required - Hint: You MUST upload the completed order form from the customer
Current Task
24
@@Upload_Customer_Doc_1
Additional Customer Documentation
Multiple File
True
View / Additional Information - Hint: Please attach here any additional required customer digital documentation.
Current Task
25
@@PSQuotationDocument
PS Quotation Document
File
False
Additional Information - [New Field]
Current Task
26
Selected Opportunities Information
Subtitle
New Section
27
@@SUGARCRM_SELECTED_OPPORTUNITIES
Selected Opportunities
Grid
True
Previous Step
28
Contacts Information
Subtitle
New Section
29
@@SUGARCRM_ACCOUNT_CONTACTS
SUGARCRM
Grid
True
Disable / Contacts Information
Current Task
30
Select The Services The Customer Has Ordered
Subtitle
New Section
31
@@Select_Services
Services to be Invoiced
Grid
False
Editable - Allows to add new rows and delete them
Current Task
32
Payment Plan / Invoice Information
Subtitle
New Section
33
@@PaymentPlanGrid
Payment Plan / Invoice Information [new Field]
Grid
Flase
Editable / Allow Adding or Deleting Rows
Current Task
34
Invoice By
Datetime
Flase
Payment Plan / Invoice Information Grid Field
Current Task
35
Payment Due Date
Datetime
Flase
Payment Plan / Invoice Information Grid Field
Current Task
36
Invoice Currency
Dropdown
Flase
Payment Plan / Invoice Information Grid Field
Current Task
37
Invoice Amount
Text
Flase
Payment Plan / Invoice Information Grid Field
Current Task
38
Invoice Number
Text
Flase
Payment Plan / Invoice Information Grid Field
Current Task
39
Invoice Date
Datetime
Flase
Payment Plan / Invoice Information Grid Field
Current Task
40
Invoice Sent to the customer?
Dropdown
Flase
Payment Plan / Invoice Information Grid Field
Current Task
41
Invoice File
File
False
Payment Plan / Invoice Information Grid Field
Current Task
42
Invoicing Comments
Textbox
False
Payment Plan / Invoice Information Grid Field
Current Task
43
Remarks / Comments
Subtitle
New Section
44
@@Services_Internal_Remarks
Internal Remarks / Notes
Text Box
False
Remarks / Comments
Current Task
45
@@Service_Start_Date
Contract Start Date
Datetime
False
Remarks / Comments - Hint: Enter the date that the customer would like to begin their services
Current Task
46
@@Service_End_Date
Contract End Date
Datetime
False
Remarks / Comments - Hint: In most cases, the end date should be 1 year from today
Current Task
47
@@Signed_Contract_sent_check
Checkbox
False
Remarks / Comments
Current Task
48
Dropdown
False
Shows the users from Finance Group Remarks / Comments -
SELECT USR_UID, USR_FULLNAME FROM INVOICE_USERS
Current Task
49
IMPORTANT: Begin services before collecting payment?
The Sales Executive selected a service as a “Support Services”.
(@@sw_support==true) && (@@sw_user_sugar==true)
...
Panel
title
Task 3 Support Registration
Users
Support Group
Assignment Rule
PENDING
Duration
PENDING
Step 1.
Name: Support Starter
Type: Dynaform
Field Name
Label
Data Type
Read Only
Description
Source
1
@@AccountExecutive
Account Executive
Text
True
Disable / Sales Manager who started the process
Register Sale Task
2
New Support Customer
Subtitle
New Section
3
@@CustomerCompanyName
Company Name
Text
True
Disable / New Support Customer
SUGARCRM
4
@@CustomerFirstName
Contact Person First Name
Text
True
Disable / New Support Customer
SUGARCRM
5
@@CustomerLastName
Contact Person Last Name
Text
True
Disable / New Support Customer
SUGARCRM
6
@@CustomerWorkPhone
Work Phone Number
Text
True
Disable / New Support Customer
SUGARCRM
7
@@CustomerCellphone
Cellphone Number
Text
True
Disable / New Support Customer
SUGARCRM
8
@@CustomerEmail
Email Address
Text
True
Disable / New Support Customer
SUGARCRM
9
@@CustomerCity
City
Text
True
Disable / New Support Customer
SUGARCRM
10
@@CustomerCountry
Country
Text
True
Disable / New Support Customer
SUGARCRM
11
Technical Person Contact Information
Label
12
@@CustomerTechFirstName
First Name
Text
True
Disable / New Support Customer
SUGARCRM
13
@@CustomerTechLastName
Last Name
Text
True
Disable / New Support Customer
SUGARCRM
14
@@CustomerTechEmail
Email Address
Text
True
Disable / New Support Customer
SUGARCRM
15
@@CustomerTechWorkPhone
Work Phone Number
Text
True
Disable / New Support Customer
SUGARCRM
16
@@CustomerTechCellphone
Cellphone Number
Text
True
Disable / New Support Customer
SUGARCRM
17
@@CustomerTechTimeZone
Customer Time Zone
Text
True
Disable / New Support Customer
SUGARCRM
18
@@ServicesGrid
Services Purchased: Please note the level of support based on the Subscription purchased
Grid
True
Disable / New Support Customer
Register Sale Task
19
Opportunities Information
Subtitle
New Section
20
@@OpportunitiesGrid
Grid
Grid
True
Disable / Opportunities Information
Register Sale Task
21
@@CustomerOrderFile
Customer Order Form
File
True
View / Opportunities Information
Register Sale Task
22
Workflow Bundle Information
Subtitle
New Section
23
@@WorkflowBundle
Workflow Bundle
Dropdown
True
Disable / Workflow Bundle Information PENDING
Register Sale Task
24
@@Processes
Processes
Text Box
True
Disable / Workflow Bundle Information PENDING
Register Sale Task
25
Contacts Information
Subtitle
New Section
26
@@ContactsGrid
SUGARCRM
Grid
True
Disable / Contacts Information
Register Sale Task
27
@@NewContactsGrid
Additional
Grid
False
Editable / Contacts Information
Current Task
28
Support Actions
Subtitle
New Section
29
@@SalesInternalRemarks
Internal Remarks / Notes
Text Box
True
Disable / Support Actions
Register Sale Task
30
@@ServiceStartDate
Service Start Date
Datetime
True
Disable / Support Actions
Register Sale Task
31
@@ServiceEndDate
Service End Date
Datetime
True
Disable / Support Actions
Register Sale Task
32
@@SupportSpreadsheetUpdated
Is the Support customer spreadsheet updated?
Dropdown
False
Editable / Support Actions
Current Task
33
@@CaseID
Case ID
Text
True
Disable / Support Actions
System PENDING
34
@@SupportComments
Comments from Support Team
Text Box
False
Editable / Support Actions
Current Task
35
Welcome Email
Subtitle
New Section
36
@@UserFirstName
User First Name
Text
False
Welcome Email
Current Task
37
@@MantisSupportProjectName
Mantis Support Project Name
Text
False
Welcome Email
Current Task
38
@@MantisUsername
Mantis Username
Text
False
Welcome Email
Current Task
39
@@MantisUserEmail
Mantis User Email
Text
False
Welcome Email
Current Task
40
@@WorkspaceURL
Workspace URL
Text
False
Welcome Email
Current Task
41
@@WorkspaceUsername
Workspace Username
Text
False
Welcome Email
Current Task
42
@@WorkspacePassword
Workspace Password
Text
False
Welcome Email
Current Task
43
@@SandboxURL
Sandbox URL
Text
False
Welcome Email
Current Task
44
@@SandboxUsername
Sandbox Username
Text
False
Welcome Email
Current Task
45
@@SandboxPassword
Sandbox Password
Text
False
Welcome Email
Current Task
46
@@UniversityUsername
University Username
Text
False
Welcome Email
Current Task
47
@@UniversityPassword
University Password
Text
False
Welcome Email
Current Task
48
49
Submit
Submit Button
Step 2.
Name: SendWelcomeSupportEmail
Type: Trigger
Step 2
Name: SendWelcomeSupportEmail
Type: Trigger
Creates a new email using the following "Support Welcome Email Template".
Panel
bgColor
#F4F6F7
title
Support Welcome Email Template
Image Modified
Hello {@@UserFirstName},
Thank you for choosing ProcessMakerfor your BPM needs. We are confident that you will be very satisfied with the services that we offer. The information enclosed below will help you make the most of our services. If you have any questions, please contact us.
We would also like to draw your attention to the following additional support sites :
Community Forum - where you can become a member of our Community.
Documentation - where you can find up to date Documentation on ProcessMaker's features.
Blog and News Home - where you can find the latest news from ProcessMaker.
If your purchase features a support contract, then you may contact our support team on +1 (617) 340-3377, option 2. Please be ready to state your name and company name when you call.
As your needs change, we will be happy to help you evaluate those needs and offer you the services that will help you achieve your new goals.
Again, thank you for choosing ProcessMaker, we’re looking forward to working with you!
Summary Of Services Purchased
Your Private Support Project has been created on our Support Portal under {@@MantisSupportProjectName}
Please use http://bugs.processmaker.comas the primary tool to report Support Tickets. You will also receive an automated email from our bug tracker (Mantis) to set up your password(s).
In order to install it, please uncompress the resulting .zip file that you just downloaded and import every .pmx process file located in the Bundle folder, then import the .pmt file located in the PMTables subfolder and finally import the plug-in located in the Plugin subfolder.
In order to access the included ProcessMaker Video Bootcamp online training course, please use the following credentials: