Skip to main content
aviv_caspi
Contributor ⭐️⭐️⭐️⭐️
August 22, 2016
Question

Assign a CTA to CSM when Using MDA Table

  • August 22, 2016
  • 5 replies
  • 98 views
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.

5 replies

joseph_siudzinski
Helper ⭐️
August 22, 2016
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
aviv_caspi
Contributor ⭐️⭐️⭐️⭐️
August 23, 2016
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.
joseph_siudzinski
Helper ⭐️
August 23, 2016
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 
aviv_caspi
Contributor ⭐️⭐️⭐️⭐️
August 24, 2016
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!!
joseph_siudzinski
Helper ⭐️
August 25, 2016
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.)