You need to sign in to do that
Don't have an account?
grandmaster
How to retrieve a user with a specific role from Account Team Member ?
Hello
Say a user 'John' has a role 'X' and is set as an Account Team Member for an Account (say ABC Corp), who has a contact 'Mark Twain' .
I want to pull the value of the username with a role 'X' in the Account Team of an Account, and then consequently display it in a custom text field CF__c in the Contact object.
In short, I want to display username of John in the CF__c of the contact Mark.
Is there a way using a formula, I can set the CF__c?
Thanks
Doesn't look like you will be able to do so using a formula field. Since you want to query the Account Team Member object (which is at the Account level of the Contact) and bring over the Team Member (User) username at the Contact record, there are multiple tables involved here and a formula field will not do the trick for you.
You would need to write a trigger in order to bring over the username of the Account Team member into this CF__c field on the Contact.
Hope this helps!
All Answers
Doesn't look like you will be able to do so using a formula field. Since you want to query the Account Team Member object (which is at the Account level of the Contact) and bring over the Team Member (User) username at the Contact record, there are multiple tables involved here and a formula field will not do the trick for you.
You would need to write a trigger in order to bring over the username of the Account Team member into this CF__c field on the Contact.
Hope this helps!
Thank you CloudKinght. Even I did some research on this and concluded the same. Your inputs further solidify my conclusion.
Cheers!
gm
Did someone find a sustainable answer for this specific problem ?
I'm facing exactly the same issue and I can't find any answer anywhere.
Thanks for your time !
Xavier