Add AccountTeamMember and TeamMemberRole when Account Request Object is Converted

Question

Good evening, I have been at the office since 0700 this morning and it is now 2309. I have the majority of all of the trigger and everything situated for my new custom object except for this last piece. I need to automatically assign the AccountTeamMember and TeamMemberRole to the New Account when an Account Request is converted to an actual Account.

The following is what I have... thank you in advance!

trigger addAccountTeamMember on Account_Request__c (after insert){    

    List<Account> AccountTeamMember = new List<Account>();

    for (Account_Request__c ar : Trigger.new){
        if(ar.Account_Request_Status__c == 'Convert'){
            AccountTeamMember.TeamMemberRole = ar.Account_Team_Role__c,
            AccountTeamMember.UserId = ar.Account_Team_Owner__c;
        }
    }

    insert AccountTeamMember;
}

Answer 1

I'm not familiar with AccountTeamMember and TeamMemberRole and so cannot comment on the logical sense of what you are doing.

But based on your code, here is how I would code the AccountTeamMember case and you can add similar code for the TeamMemberRole case:

trigger addAccountTeamMember on Account_Request__c (after insert) {    
    // Will collect the object to be inserted in this list
    List<AccountTeamMember> atms = new List<AccountTeamMember>();
    // Loop over the one or more inserted objects
    for (Account_Request__c ar : Trigger.new) {
        if (ar.Account_Request_Status__c == 'Convert') {
            // Create a new object, initialising some values at the same time
            AccountTeamMember atm = new AccountTeamMember(
                    AccountId = ???,
                    UserId = ar.Account_Team_Owner__c,
                    TeamMemberRole = ar.Account_Team_Role__c
                    );
            // Add the new object to the list
            atms(atm);
        }
    }
    // Insert all the objects in the list (bulkification)
    insert atms;
}

PS Found this Sharing and Team Selling Objects ERD that is helpful.