Salesforce Drupal Integration
$250-750 USD
Paiement à la livraison
Drupal/Salesforce Programmers
For this project the Salesforce Objects are:
• Contact
• Student__c
• StudentTeam__c
A single Drupal/mySQL table “LiteUsers)” is involved.
The deliverables for this project are:
1. Create trigger on Salesforce Contact Object.
a. On Insert - if Contact.isLiteUser__c == true and Contact.Active__c==true, then insert
LiteUsers.SalesforceId=[url removed, login to view], LiteUsers.LastName=[url removed, login to view],
LiteUsers.FirstName=[url removed, login to view], LiteUsers.UserId=[url removed, login to view], LiteUsers.Active=True
to LiteUsers.
b. On update: Query LiteUsers for Contact.Id.
1. If Record Found:
a. Update Record: LiteUsers.Active=Contact.isLiteUser__c
2. If record not found && Contact.isLiteUser__c, then insert [url removed, login to view], [url removed, login to view],
[url removed, login to view], Active=True to LiteUsers
c. On delete: Query LiteUsers for Contact.Id.
1. If Record Found:
a. Update Record: LiteUsers.Active=false
2. Create Login Page for Drupal Site
a. Validate Valid UserId & Password against LiteUsers table
i. If invalid, notify login requestor “UserId or Password Invalid”
ii. If valid
1. From Salesforce [Select StudentId__c, [url removed, login to view] From
StudentTeam__c WHERE ContactId==: [url removed, login to view]]
a. If Record(s) Exist
i. Populate Student Select Box on Page
1. Option Value= “[url removed, login to view]” +
[url removed, login to view]
2. Option Text = [url removed, login to view]
b. Else notify login requestor “No Students Found”
2. On change of Student Select Box
a. Update IFrame with Option Value
Nº du projet : #1081631