I have MDA table to store usage data. I'm doing some calculations based on this table and when I see a drop in one of the usage elements I want to create a CTA and assign it to the CSM of the account.
I did a join between the MDA to the Account object but when joining the tables the CSM field is not a lookup anymore and I can't use it to assign the CTA.
Does anyone know a workaround for this problem?
Thanks,
Aviv.
Page 1 / 1
Hi Aviv,
If you go to Admin -> Data Management -> and Edit the CSM field on Account, is this mapped as User ID under SFDC Mapping? This is what will allow it to be selected as a CTA assignee field.
Best,
Joe
If you go to Admin -> Data Management -> and Edit the CSM field on Account, is this mapped as User ID under SFDC Mapping? This is what will allow it to be selected as a CTA assignee field.
Best,
Joe
Thanks Joseph!
When doing what you wrote I had the option to choose the CSM as the owner field, but I don't have any Data on this object.. it's empty.
Do I need to do something active in order to update this object?
What is it for?
Thanks,
Aviv.
When doing what you wrote I had the option to choose the CSM as the owner field, but I don't have any Data on this object.. it's empty.
Do I need to do something active in order to update this object?
What is it for?
Thanks,
Aviv.
Aviv,
I apologize I didn't realize it was that object. Sometimes these objects get created for a scorecard process by the system. I would actually suggest creating a new object with the Account ID, along with any other Account attributes like CSM you might need. You would then populate this with an upsert rule, using Account ID as your only identifier. Then do the join from your usage object -> this new account details object.
Let me know if this helps.
Joe
I apologize I didn't realize it was that object. Sometimes these objects get created for a scorecard process by the system. I would actually suggest creating a new object with the Account ID, along with any other Account attributes like CSM you might need. You would then populate this with an upsert rule, using Account ID as your only identifier. Then do the join from your usage object -> this new account details object.
Let me know if this helps.
Joe
Thanks Joseph! :)
So basically the only way to set CSM as an owner of a CTA in this case is by joining 2 MDA tables while one of them has the CSM as a field?
and how can I join between 2 MDA tables?
Thanks much!!
So basically the only way to set CSM as an owner of a CTA in this case is by joining 2 MDA tables while one of them has the CSM as a field?
and how can I join between 2 MDA tables?
Thanks much!!
Aviv,
Yes, you could go the join route or could use a rule that just loads the CSM field directly to the MDA Usage details object you have.
If you wanted to do a join, you can find a support article here. Keep in mind to do the join from the usage object -> account details object. (From the many to one direction.)
Yes, you could go the join route or could use a rule that just loads the CSM field directly to the MDA Usage details object you have.
If you wanted to do a join, you can find a support article here. Keep in mind to do the join from the usage object -> account details object. (From the many to one direction.)
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.