Hi all, hope someone can help with this. I have an object called New_Interactions__c and it stores individual records of any likes and thanks that happen. In this object we also record the notification_ID__c which is an external ID and a unique ID to each notification (this is not the same as the salesforce ID which is different). This means if multiple people like a particular notification then the record in salesfroce gets created with the like o rthanks they chose along with the notification ID. I want this to rollup to an object called Total_News_Interactions__c and create a new record if the notification_id__c is unique and if not unique gets counted within the record that it matches the notification_ID__c. I know hwo to do the sums etc but struggling with making it create a new record if the notification_ID__c is unique or add to the existing one.
How might I accomplish this?
@Scott Walker This is a tricky one because based on the way you explain it I would actually change the entire data model. You should probably look into having a parent object called Notifications where you roll up all the New_Interactions. This way you can create a master Detail and if the notification ID is unique you will need to make sure a new record is created.
Let me know if I didn't understand the object relationships and if so please give some more examples
