-
ChatterFeed
-
0Best Answers
-
0Likes Received
-
0Likes Given
-
3Questions
-
8Replies
Return Text from a SOQL Query
I am trying to update the following 3 custom fields under my Member_Vendor_del__c custom object:
Vendor_ID__c
Member_Account_ID__c
Member_State__c
I have created the code below to update the Vendor_ID__c and Member_Account_ID__c
trigger VendorRepUpdateTrigger on Member_Vendor_del__c (before update) {
// Update the Vendor's ID, Member's ID, and Member's Physical State into the Member Vendor Record.
for (Member_Vendor_del__c u : trigger.new){
if (u.Vendor_ID__c == null)
u.Vendor_ID__c = u.Vendor__c;
u.Member_Account_ID__c = u.Member__c;
}
}
My issue is with getting Member_State__c to populate with the Physical State(API Field Name: BillingState) from the related member account. I have createdthe SOQL query below to return the string text value on the account but I keep getting the error "Illegal assignment from List to String"
// Update the Member's Physical State onto the Member Vendor Record.
for (Member_Vendor_del__c u : trigger.new)
if (u.Member_State__c == null)
u.Member_State__c = [Select BillingState
From Account
Where Account.Name = :u.Member__c];}
I can add .Id to the query and the error goes away but then the trigger wants to return a Salesforce ID rather than the 2 letter abbreviation for the State.
Question #1: What can I do to my SOQL query to return the text value rather than an ID?
Question #2: Can I add the SOQL query to the first part of the trigger? Something like:
trigger VendorRepUpdateTrigger on Member_Vendor_del__c (before update) {
// Update the Vendor's ID, Member's ID, and Member's Physical State into the Member Vendor Record.
for (Member_Vendor_del__c u : trigger.new){
if (u.Vendor_ID__c == null)
u.Vendor_ID__c = u.Vendor__c;
u.Member_Account_ID__c = u.Member__c;
u.Member_State__c = [Select Id, Account.BillingState
From Account
where Account_ID__c = :u.Member__c].Id;
}
}
Vendor_ID__c
Member_Account_ID__c
Member_State__c
I have created the code below to update the Vendor_ID__c and Member_Account_ID__c
trigger VendorRepUpdateTrigger on Member_Vendor_del__c (before update) {
// Update the Vendor's ID, Member's ID, and Member's Physical State into the Member Vendor Record.
for (Member_Vendor_del__c u : trigger.new){
if (u.Vendor_ID__c == null)
u.Vendor_ID__c = u.Vendor__c;
u.Member_Account_ID__c = u.Member__c;
}
}
My issue is with getting Member_State__c to populate with the Physical State(API Field Name: BillingState) from the related member account. I have createdthe SOQL query below to return the string text value on the account but I keep getting the error "Illegal assignment from List to String"
// Update the Member's Physical State onto the Member Vendor Record.
for (Member_Vendor_del__c u : trigger.new)
if (u.Member_State__c == null)
u.Member_State__c = [Select BillingState
From Account
Where Account.Name = :u.Member__c];}
I can add .Id to the query and the error goes away but then the trigger wants to return a Salesforce ID rather than the 2 letter abbreviation for the State.
Question #1: What can I do to my SOQL query to return the text value rather than an ID?
Question #2: Can I add the SOQL query to the first part of the trigger? Something like:
trigger VendorRepUpdateTrigger on Member_Vendor_del__c (before update) {
// Update the Vendor's ID, Member's ID, and Member's Physical State into the Member Vendor Record.
for (Member_Vendor_del__c u : trigger.new){
if (u.Vendor_ID__c == null)
u.Vendor_ID__c = u.Vendor__c;
u.Member_Account_ID__c = u.Member__c;
u.Member_State__c = [Select Id, Account.BillingState
From Account
where Account_ID__c = :u.Member__c].Id;
}
}
- Gabe Mejia
- September 29, 2017
- Like
- 0
- Continue reading or reply
Apex trigger using apex class
i have a custom field(Vendor_Rep__c) that i am trying tp update automatically when a record(Member Vendor) is created or edited.
I have created visualforce page, which i am starting to believe that i no longer need to acheive what i need.
Also, with some help, i have created the following code for an Apex Class:
public class contactsearch {
public Contact searchContact(string ContactType, string MemberState, String vendorId)
{
return[Select Name From Contact Where Contact_Type__c = 'Vendor Rep' AND States__c = :MemberState AND Vendor__c = :vendorId limit 1];
}
}
Lastly, after reading several questions already posted and a few Apex Developer Guide articles, i created the trigger below.
trigger VendorRepUpdateTrigger on Member_Vendor_del__c (before insert, after update) {
for (Member_Vendor_del__c u : trigger.new);{
u.Vendor_Rep__c = null;
}
}
What i want to do is only if Vendor_Rep__c is blank/null, have the trigger use the parameters from the apex class to return with the name of the contact into the Vendor_Rep__c field. I want to eventually add in an additional factor to check against, the name of the county the contact services vs. the account's county.
I have created visualforce page, which i am starting to believe that i no longer need to acheive what i need.
Also, with some help, i have created the following code for an Apex Class:
public class contactsearch {
public Contact searchContact(string ContactType, string MemberState, String vendorId)
{
return[Select Name From Contact Where Contact_Type__c = 'Vendor Rep' AND States__c = :MemberState AND Vendor__c = :vendorId limit 1];
}
}
Lastly, after reading several questions already posted and a few Apex Developer Guide articles, i created the trigger below.
trigger VendorRepUpdateTrigger on Member_Vendor_del__c (before insert, after update) {
for (Member_Vendor_del__c u : trigger.new);{
u.Vendor_Rep__c = null;
}
}
What i want to do is only if Vendor_Rep__c is blank/null, have the trigger use the parameters from the apex class to return with the name of the contact into the Vendor_Rep__c field. I want to eventually add in an additional factor to check against, the name of the county the contact services vs. the account's county.
- Gabe Mejia
- September 05, 2017
- Like
- 0
- Continue reading or reply
apex class contactsearch
Wondering if anyone would be able to assist. I am trying to perform a contactsearch that would return the name of a contact(or Salesforce ID) based on a couple cirteria. Any help is appreaciated.
- Gabe Mejia
- August 28, 2017
- Like
- 0
- Continue reading or reply
Return Text from a SOQL Query
I am trying to update the following 3 custom fields under my Member_Vendor_del__c custom object:
Vendor_ID__c
Member_Account_ID__c
Member_State__c
I have created the code below to update the Vendor_ID__c and Member_Account_ID__c
trigger VendorRepUpdateTrigger on Member_Vendor_del__c (before update) {
// Update the Vendor's ID, Member's ID, and Member's Physical State into the Member Vendor Record.
for (Member_Vendor_del__c u : trigger.new){
if (u.Vendor_ID__c == null)
u.Vendor_ID__c = u.Vendor__c;
u.Member_Account_ID__c = u.Member__c;
}
}
My issue is with getting Member_State__c to populate with the Physical State(API Field Name: BillingState) from the related member account. I have createdthe SOQL query below to return the string text value on the account but I keep getting the error "Illegal assignment from List to String"
// Update the Member's Physical State onto the Member Vendor Record.
for (Member_Vendor_del__c u : trigger.new)
if (u.Member_State__c == null)
u.Member_State__c = [Select BillingState
From Account
Where Account.Name = :u.Member__c];}
I can add .Id to the query and the error goes away but then the trigger wants to return a Salesforce ID rather than the 2 letter abbreviation for the State.
Question #1: What can I do to my SOQL query to return the text value rather than an ID?
Question #2: Can I add the SOQL query to the first part of the trigger? Something like:
trigger VendorRepUpdateTrigger on Member_Vendor_del__c (before update) {
// Update the Vendor's ID, Member's ID, and Member's Physical State into the Member Vendor Record.
for (Member_Vendor_del__c u : trigger.new){
if (u.Vendor_ID__c == null)
u.Vendor_ID__c = u.Vendor__c;
u.Member_Account_ID__c = u.Member__c;
u.Member_State__c = [Select Id, Account.BillingState
From Account
where Account_ID__c = :u.Member__c].Id;
}
}
Vendor_ID__c
Member_Account_ID__c
Member_State__c
I have created the code below to update the Vendor_ID__c and Member_Account_ID__c
trigger VendorRepUpdateTrigger on Member_Vendor_del__c (before update) {
// Update the Vendor's ID, Member's ID, and Member's Physical State into the Member Vendor Record.
for (Member_Vendor_del__c u : trigger.new){
if (u.Vendor_ID__c == null)
u.Vendor_ID__c = u.Vendor__c;
u.Member_Account_ID__c = u.Member__c;
}
}
My issue is with getting Member_State__c to populate with the Physical State(API Field Name: BillingState) from the related member account. I have createdthe SOQL query below to return the string text value on the account but I keep getting the error "Illegal assignment from List to String"
// Update the Member's Physical State onto the Member Vendor Record.
for (Member_Vendor_del__c u : trigger.new)
if (u.Member_State__c == null)
u.Member_State__c = [Select BillingState
From Account
Where Account.Name = :u.Member__c];}
I can add .Id to the query and the error goes away but then the trigger wants to return a Salesforce ID rather than the 2 letter abbreviation for the State.
Question #1: What can I do to my SOQL query to return the text value rather than an ID?
Question #2: Can I add the SOQL query to the first part of the trigger? Something like:
trigger VendorRepUpdateTrigger on Member_Vendor_del__c (before update) {
// Update the Vendor's ID, Member's ID, and Member's Physical State into the Member Vendor Record.
for (Member_Vendor_del__c u : trigger.new){
if (u.Vendor_ID__c == null)
u.Vendor_ID__c = u.Vendor__c;
u.Member_Account_ID__c = u.Member__c;
u.Member_State__c = [Select Id, Account.BillingState
From Account
where Account_ID__c = :u.Member__c].Id;
}
}
- Gabe Mejia
- September 29, 2017
- Like
- 0
- Continue reading or reply
Apex trigger using apex class
i have a custom field(Vendor_Rep__c) that i am trying tp update automatically when a record(Member Vendor) is created or edited.
I have created visualforce page, which i am starting to believe that i no longer need to acheive what i need.
Also, with some help, i have created the following code for an Apex Class:
public class contactsearch {
public Contact searchContact(string ContactType, string MemberState, String vendorId)
{
return[Select Name From Contact Where Contact_Type__c = 'Vendor Rep' AND States__c = :MemberState AND Vendor__c = :vendorId limit 1];
}
}
Lastly, after reading several questions already posted and a few Apex Developer Guide articles, i created the trigger below.
trigger VendorRepUpdateTrigger on Member_Vendor_del__c (before insert, after update) {
for (Member_Vendor_del__c u : trigger.new);{
u.Vendor_Rep__c = null;
}
}
What i want to do is only if Vendor_Rep__c is blank/null, have the trigger use the parameters from the apex class to return with the name of the contact into the Vendor_Rep__c field. I want to eventually add in an additional factor to check against, the name of the county the contact services vs. the account's county.
I have created visualforce page, which i am starting to believe that i no longer need to acheive what i need.
Also, with some help, i have created the following code for an Apex Class:
public class contactsearch {
public Contact searchContact(string ContactType, string MemberState, String vendorId)
{
return[Select Name From Contact Where Contact_Type__c = 'Vendor Rep' AND States__c = :MemberState AND Vendor__c = :vendorId limit 1];
}
}
Lastly, after reading several questions already posted and a few Apex Developer Guide articles, i created the trigger below.
trigger VendorRepUpdateTrigger on Member_Vendor_del__c (before insert, after update) {
for (Member_Vendor_del__c u : trigger.new);{
u.Vendor_Rep__c = null;
}
}
What i want to do is only if Vendor_Rep__c is blank/null, have the trigger use the parameters from the apex class to return with the name of the contact into the Vendor_Rep__c field. I want to eventually add in an additional factor to check against, the name of the county the contact services vs. the account's county.
- Gabe Mejia
- September 05, 2017
- Like
- 0
- Continue reading or reply
apex class contactsearch
Wondering if anyone would be able to assist. I am trying to perform a contactsearch that would return the name of a contact(or Salesforce ID) based on a couple cirteria. Any help is appreaciated.
- Gabe Mejia
- August 28, 2017
- Like
- 0
- Continue reading or reply