When we send an outbound email from Salesforce lightning record page, a task gets created and will be captured in activity history of that particular record.
Now, when we send this email from Lead record, neither the email is getting captured under lead record nor the task record is getting created.
This functionality is working fine for all the objects except for leads. Can anyone let me know any solution here? Thanks!
I have a requirement to create a new email_capture__c record whenever a new task gets created.
Here is the logic I have:
trigger EmailTrigger on Task (after insert) {
Email_Capture__c ec = new Email_Capture__c();
for(Task t:trigger.new){
for(Email_Capture__c e : [SELECT id, email__c from Email_Capture__c where email__c != null]){
if(e.email__c != t.description.substringBefore('CC:').substringAfter('To:')){
ec.email__c = t.description.substringBefore('CC:').substringAfter('To:');
}
}
}
insert ec;
}
Now, whenever I send an email from a record and new task is getting created, instead of 1 email capture record, I am seeing multiple records getting created.
Can anyone let me know how to overcome this error.
I have an email service which creates a task when an inbound email comes to salesforce. I have created this on opportunity and the logic is as follows:
The above code is working fine and i could able to see a task created for inbound emails on opportunities. But when the same email is configured on multiple records, the response is getting stored on other record but not on the record which was used to send outbound email.
Can anyone let me know how to attach the inbound response under its appropriate oppty record.
I have a requirement to fetch Parent, Child, and Grandchild and Store them as JSON in the same hierarchy.
Here is my logic:
public List<Parent_Project__c> ProjectRecordsList {get; set;}
ProjectRecordsList = [SELECT Id, Name,Parent_Project__c, (SELECT Id, Name, (select name from Orders__r) FROM Child_Projects__r) FROM Parent_Project__c];
string strJSON = JSON.serialize(ProjectRecordsList);
Now the issue here is that, when I run this query, I am getting the error as
SOQL statements cannot query aggregate relationships more than 1 level away from the root entity object.
I could able to fetch Parent Project and its child Project successfully whereas when I include Orders (Grandchild), I am seeing this error. I know that I can write queries 5 levels up if I start with Child but in this case, I need to fetch the records starting from Parent to Grandchild.
Can anyone please let me know how to add Orders of Child Projects in the JSON?
I have a requirement to display Account and its child Accounts using Gantt Chart. Here is my Logic:
Controller:
public with Sharing class Account_Gantt {
public Account ParentRecord{get; set;}
public Account ChildRecord{get; set;}
public Account_Gantt() {
ParentRecord = [SELECT Id, Name,start_date__c, end_date__c FROM Account WHERE name = 'Test Parent Account'];
}
public Account_Gantt(Account_Gantt Controller){
ChildRecord = [SELECT ID, Name, start_date__c, end_date__c from Account where parent_account__r.name = 'Test Parent Account'];
}
}
Under the Parent Account, I have 15 child Accounts. The issue here is that I could able to see Parent Account Name in the chart but not Child Accounts. I am seeing only the blank values instead of proper account names. The screenshot is as follows:
Can anyone please let me know how to display all the 15 child account names under the parent account in the chart?
I have a requirement to get all the Project Ids of Resource under User Detail page.
Below is my Object Schema: Parent: Project (Field: ProjectId) Child: Timecard (Field: Project__c, Resource_Name__c)
Now, if the Resource Name under timecard matches with User Name, the Project Ids from that timecard should be stored on User detail page separated by a semicolon. Below is my logic that I have achieved so far:
list<user> user = [SELECT name from User where isactive = true];
list<string> str = new list<string>();
for(user u1 : user){
str.add(u1.name);
}
List <Timecard__c> timecard = [
SELECT ID,Project__c,resource_name__c
FROM Timecard__c
Where Resource_name__c = :str and Project__c != null and Resource_Name__c != null];
set<string> allProsset = new set<string>();
for (Timecard__c timecards : timecard) {
allProsset.add(timecards.Project__c);
}
list<string>allProsList = new list<string>(allProsset);
list<User> userupdates = new list<user>();
for(User us : user){
us.Project_Ids__c = String.join(allProsList,';');
userupdates.add(us);
}
update userupdates;
Now when i execute the above logic, Project Ids under User record is getting updated with some random Project IDs but not from the timecard where the User name is matching. Instead of pulling all the project Ids that the resource is working under, I am seeing some random project ids
Is there anyway that I can update user records with the exact project ids that matches resource name with user name in timecard under a project?
Grand-Child: Sponsor. Sponsor Holds a field called ProId. These as 16 digit Ids.
Now, my requirement is to get all the ProIds from the sponsor records populate on the User record as a multi-select picklist value. The field on User is named All_Pros__c For eg: On User A, All_Pros__c field should hold values as 'id1';'id2';'id3'.
Can anyone please suggest any approach on ths regard.
I know this isnt possible, but is there anyway that we can use transformed lens to an Einstein Discovery Story.
We have some complex calculations that are built using formula in lens and we want the same in Einstein Discovery Story. Along with that we have also columns created for standard deviation which we want to use in our story.
Instead of uploading the calculated columns in csv and using them in Story, can anyone please let me know if there is any possibility lf using lens itself while building the story. Thanks!
I have a requirement to get all the Project Ids of Resource under User Detail page.
Below is my Object Schema: Parent: Project (Field: ProjectId) Child: Timecard (Field: Project__c, Resource_Name__c)
Now, if the Resource Name under timecard matches with User Name, the Project Ids from that timecard should be stored on User detail page separated by a semicolon. Below is my logic that I have achieved so far:
list<user> user = [SELECT name from User where isactive = true];
list<string> str = new list<string>();
for(user u1 : user){
str.add(u1.name);
}
List <Timecard__c> timecard = [
SELECT ID,Project__c,resource_name__c
FROM Timecard__c
Where Resource_name__c = :str and Project__c != null and Resource_Name__c != null];
set<string> allProsset = new set<string>();
for (Timecard__c timecards : timecard) {
allProsset.add(timecards.Project__c);
}
list<string>allProsList = new list<string>(allProsset);
list<User> userupdates = new list<user>();
for(User us : user){
us.Project_Ids__c = String.join(allProsList,';');
userupdates.add(us);
}
update userupdates;
Now when i execute the above logic, Project Ids under User record is getting updated with some random Project IDs but not from the timecard where the User name is matching. Instead of pulling all the project Ids that the resource is working under, I am seeing some random project ids
Is there anyway that I can update user records with the exact project ids that matches resource name with user name in timecard under a project?
I have a requirement to create a new email_capture__c record whenever a new task gets created.
Here is the logic I have:
trigger EmailTrigger on Task (after insert) {
Email_Capture__c ec = new Email_Capture__c();
for(Task t:trigger.new){
for(Email_Capture__c e : [SELECT id, email__c from Email_Capture__c where email__c != null]){
if(e.email__c != t.description.substringBefore('CC:').substringAfter('To:')){
ec.email__c = t.description.substringBefore('CC:').substringAfter('To:');
}
}
}
insert ec;
}
Now, whenever I send an email from a record and new task is getting created, instead of 1 email capture record, I am seeing multiple records getting created.
Can anyone let me know how to overcome this error.
I have a requirement to fetch Parent, Child, and Grandchild and Store them as JSON in the same hierarchy.
Here is my logic:
public List<Parent_Project__c> ProjectRecordsList {get; set;}
ProjectRecordsList = [SELECT Id, Name,Parent_Project__c, (SELECT Id, Name, (select name from Orders__r) FROM Child_Projects__r) FROM Parent_Project__c];
string strJSON = JSON.serialize(ProjectRecordsList);
Now the issue here is that, when I run this query, I am getting the error as
SOQL statements cannot query aggregate relationships more than 1 level away from the root entity object.
I could able to fetch Parent Project and its child Project successfully whereas when I include Orders (Grandchild), I am seeing this error. I know that I can write queries 5 levels up if I start with Child but in this case, I need to fetch the records starting from Parent to Grandchild.
Can anyone please let me know how to add Orders of Child Projects in the JSON?
I have a requirement to get all the Project Ids of Resource under User Detail page.
Below is my Object Schema: Parent: Project (Field: ProjectId) Child: Timecard (Field: Project__c, Resource_Name__c)
Now, if the Resource Name under timecard matches with User Name, the Project Ids from that timecard should be stored on User detail page separated by a semicolon. Below is my logic that I have achieved so far:
list<user> user = [SELECT name from User where isactive = true];
list<string> str = new list<string>();
for(user u1 : user){
str.add(u1.name);
}
List <Timecard__c> timecard = [
SELECT ID,Project__c,resource_name__c
FROM Timecard__c
Where Resource_name__c = :str and Project__c != null and Resource_Name__c != null];
set<string> allProsset = new set<string>();
for (Timecard__c timecards : timecard) {
allProsset.add(timecards.Project__c);
}
list<string>allProsList = new list<string>(allProsset);
list<User> userupdates = new list<user>();
for(User us : user){
us.Project_Ids__c = String.join(allProsList,';');
userupdates.add(us);
}
update userupdates;
Now when i execute the above logic, Project Ids under User record is getting updated with some random Project IDs but not from the timecard where the User name is matching. Instead of pulling all the project Ids that the resource is working under, I am seeing some random project ids
Is there anyway that I can update user records with the exact project ids that matches resource name with user name in timecard under a project?
