SN OOB survey capabilities

[JeraldP]

Two Questions:

1. Can we write to a custom table instead of the asmt_metric_result global table. It seems that you cannot extend the global "asmt_" tables and there are ACL roles(survey_admin, survey_reader, survey_creator)which allows anyone with those roles to read who answered the questions from the survey.    We need to protect the information which identifies who answered the question in the survey responses.  We do not want to negatively impact the  SN OOB survey function and capabilities for any other users.

2. Or, can we basically duplicate the SN OOB survey function and capabilities in a custom app in a SN Instance?

[AshishKM · Accepted solution]

Hi @JeraldP, 

As a work-around, did you try to hide the column "which identifies who answered the question" based on ACLs or try to mask the field data.

-Thanks,

AshishKM

[JeraldP]

I only have about 2 years of SN Experience on a team where I was learning.  That team always avoided global tables and ACL roles whenever possible, they always did custom where the had complete control.  On this project they now want to use OOB survey in SN instead of a past application custom surveys and survey responses and since survey responses are in a global tables where survey_admin role gets assigned to other developers and admins and they can assign survey_admin, survey_reader, survey_creator etc.. to whomever they want outside of my control.  If I hide the field by saying read, edit, write, all is set to only XXX=application survey_admin, XXXsurvey_reader, XXXsurvey_creator. etc... then delete the default survey_admin,survey_reader, survey_creator ACLs on that table then I impact all of survey responses for all surveys that others may need to create.. Also the ACLS are all "or'ed" so if one is true they are allowed to read write edit etc... how would I keep any user not using XXXcustom app from not seeing the hidden column  "which identifies who answered the question" based on ACLs or try to mask the field data?  We are talking thousands of users using this multi-tenent app  SN platform. 

[JeraldP]

I'm not certain how to do that without impacting other users with survey_reader, survey_creator, assessment_admin ACL roles on the table.