Hi,

I have a trigger that updates a currency field on a custom object (Pitch).  The amount reflects the Sum of Opportunty Amounts among all Pitch records that have the same Property group.  However, it can only update the one record that triggers it.  I really want to update all the Pitch records that have the same property group so all records would then have the same value.  I get an error when doing the other records.  I am trying to use ChatGPT but am stuck.  Let me know of any suggestions.

Error when updating a record

CalculatePropertyGroupAmountBefore4: Execution Of BeforeUpdate Caused By: System.DmlException: Update Failed. First Exception On Row 0 With Id A0a1O00000cd3zEQAQ;

First Error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, CalculatePropertyGroupAmountBefore4: Execution Of BeforeUpdate Caused By: System.DmlException: Update Failed. First Exception On Row 0 With Id A0a1O00000cd3zdQAA;
First Error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, CalculatePropertyGroupAmountBefore4: Execution Of BeforeUpdate Caused By: System.DmlException: Update Failed. First Exception On Row 0 With Id A0a1O00000cd3zEQAQ;
First Error: SELF_REFERENCE_FROM_TRIGGER, Object (id = A0a1O00000cd3zE) Is Currently In Trigger CalculatePropertyGroupAmountBefore4, Therefore It Cannot Recursively Update Itself: [] Trigger.CalculatePropertyGroupAmountBefore4:

Line 45, Column 1: [] Trigger.CalculatePropertyGroupAmountBefore4:
Line 45, Column 1: [] Trigger.CalculatePropertyGroupAmountBefore4:
Line 45, Column 1

Trigger CalculatePropertyGroupAmountBefore4 on Pitch__c (before insert, before update) {
  // Check if the trigger is currently running.
  //if (Trigger.isRunning) {
    //return;
  //}

  // Get the records that are being triggered on.
  List<Pitch__c> records = Trigger.new;

  // Get the property group amount for each record.
  for (Pitch__c record : records) {
    List<AggregateResult> propertyGroupAmounts = [
      SELECT SUM(Opportunity__r.Amount)
      FROM Pitch__c
      WHERE Id = :record.Id OR     
     Property_Group__c = :record.Property_Group__c
      GROUP BY propertyhighspot__r.Property_Group_Text__c
    ];

    // Set the property group amount for each record.
    if (propertyGroupAmounts != null && propertyGroupAmounts.size() > 0) {
      record.Property_Group_Amount__c = (Decimal)propertyGroupAmounts[0].get('expr0');
    } else {
      // Set the property group amount to 0 if there is no amount.
      record.Property_Group_Amount__c = 0;
    }
  }

  // Update all records with the same value for Property_Group__c.
  for (Pitch__c record : Trigger.new) {
    if (record.Property_Group__c != null) {
      // Get all records with the same value for Property_Group__c.
      List<Pitch__c> matchingRecords = [
        SELECT Id, Property_Group_Amount__c, IsUpdated__c
        FROM Pitch__c
        WHERE Property_Group__c = :record.Property_Group__c
        AND Id != :record.Id
      ];

      // Update the property group amount for all matching records.
      for (Pitch__c matchingRecord : matchingRecords) {
        if (!matchingRecord.isUpdated__c) {
          matchingRecord.Property_Group_Amount__c = record.Property_Group_Amount__c;
          matchingRecord.isUpdated__c = true;
          update matchingRecord;
        }
      }
    }
  }
}