I'm attempting to write a generic field check that our users can easily update for merging with conga docs.
I have a custom object that maps fields that are required for the docs to properly complete. I then create a sql query from those results and run it against the appropriate oject:
Map<id,Conga_Merge_Fields__c> reqFields = new Map<id,Conga_Merge_Fields__c>([select ID,field_name__c,object_name__c,deal_type__c from Conga_Merge_Fields__c where Object_Name__c = 'Property']);
Map<id,Merge_Fields__c> reqFields = new Map<id,Merge_Fields__c>([select ID,field_name__c,object_name__c from Merge_Fields__c where Object_Name__c = 'Property']);
for (Conga_Merge_Fields__c field : reqFields.values() )
{
query = query+field.Field_Name__c;
}
query = query+' from Property__c where id = \''+currentOpportunity.Property__c+'\'';
Property__c prop = Database.query(query);
I then query the DB with the query string and get the fields/values that are required.
I'm stuck on how i can loop over each returned field to check if it's null/blank/0. Is there any way to do this? I need to know which field failed to properly direct the users on what needs to be fixed.
I'm working on going through our triggers and ensuring they will preform with a bulk load. There is a trigger that I'm lost on how to remove the select statement from the loop. The purpose of the trigger is to ensure 3 fields are unique in the database.
trigger PROP_LotBlockPlanIsUnique on Property__c (before insert, before update)
{
for (Property__c currentProperty : Trigger.new)
{
for (Property__c currentProperty : Trigger.new)
{
list <Property__c> properties =
[select id, name from Property__c where
Block_Number__c =: currentProperty.Block_Number__c and
Plan_Number__c =: currentProperty.Plan_Number__c and
Lot_Number__c =: currentProperty.Lot_Number__c and
id <>: currentProperty.id limit 1];
//If we have any properties with this LOT BLOCK PLAN - notify user.
if (properties.size() <> 0 )
{
//Error
string errorMessage = 'Property Lot Block Plan is in use for property: ';
How could I move that query outside of the loop? I think my only option is to create a new field which concatenates the three fields together and use that in a query.
I have a custom number field on the Opportunity object: Desired DCR with a default value of 1.2. When I create a new opportunity the field is set to the default value correctly. When I convert a lead this field is left blank is this normal functionality?
I have a workaround but this behaviour is difficult to understand.
I have made many changes in a sandbox. Custom objects, Workflow, Leads/Account/Contact field removals, additions. Triggers, custom validation.
Just wondering what the easiest way to move this into production. Creating a change set and pushing the changes to the production instance? This would be a fairly huge changeset - curious about the most efficient way. All data in production (except leads) can be removed.
I've been having problems creating a custom object from an apex trigger on leads. Essentially I need a few extra objects created (and populated) if a lead is converted. The following trigger was just a test to see if creating a custom object when the convert button is triggerd would work - however it doesn't. Any help would be appreciated.
trigger LeadConvert on Lead (before update) {
// insert a custom object associated with the contact GIC_Deal__c obj = new GIC_Deal__c(); obj.Name = 'temp'; insert obj; }
I got a exception as below. Any suggestions? Thanks in advance:
"Error: Invalid Data. Review all error messages below to correct your data. Apex trigger RentMergeTrigger caused an unexpected exception, contact your administrator: RentMergeTrigger: execution of BeforeUpdate caused by: System.Exception: Too many script statements: 10201: Class.RentMerge.RentCalculate: line 70, column 8"
I have a custom number field on the Opportunity object: Desired DCR with a default value of 1.2. When I create a new opportunity the field is set to the default value correctly. When I convert a lead this field is left blank is this normal functionality?
I have a workaround but this behaviour is difficult to understand.
I've been having problems creating a custom object from an apex trigger on leads. Essentially I need a few extra objects created (and populated) if a lead is converted. The following trigger was just a test to see if creating a custom object when the convert button is triggerd would work - however it doesn't. Any help would be appreciated.
trigger LeadConvert on Lead (before update) {
// insert a custom object associated with the contact GIC_Deal__c obj = new GIC_Deal__c(); obj.Name = 'temp'; insert obj; }
I have a query on web-to-lead. I have created two web-to-lead HTML pages for different record types basing on the fields and the lead records needs to be created in thier respective record types when the form is submitted, but all the lead forms which get submitted are getting created in the default record type and not in their respective record types. How can I solve this issue?
