Salesforce responses - is there a way to change the "Created By" field to be the Case Owner?
This is for a CSAT survey. I have my responses mapping back to the case and the contact record. However, since the survey response is owned by me (I linked the survey project to SF), we are not able to set security in SF on the Survey Response object so that case owners only see the responses for their own case. ie, it cannot be set to private, it has to be read-write all since for example, Case Owner = Tom by Survey Response Owner = me, so if private, Tom cannot see items created by me.
What can be done as a workaround to let case owners see the survey responses tied to their case? I created a lookup on the Survey Response object for CaseOwner, but support was not able to give any other guidance about how to populate this back and use it within SF.
Another issue this raises for us is when we try to trigger an email to the manager when there is a poor response to a survey, since the owner is me, my manager is the only one who gets emails.
I am sure there has to be some sort of workaround in SF or missing setup in Q to get me where I need to be. Can anyone enlighten me?