Creating a follow-up process for survey responses

[Daniel Voutt]

Hi,

We want to introduce a process to ensure that we follow-up on any negative responses to surveys.

I have created the workflow, notifications etc and all is working perfectly except that the workflow is triggering each time the negative response is registered from each question and ideally I only want it to trigger once per completed survey.

Does anyone have any ideas on how to update the code to ensure the wf is only triggered once for each survey and not each question.

Thanks in advance,

Dan

[Harish Murikina · Accepted solution]

if you open the table "task_survey" you can see state field. you have to write workflow on this table

[Daniel Voutt]

I'm currently using the survey_response table, however I will look to see if I can make some changes and get this working.

[Daniel Voutt]

OK, it was simple in the end - I removed the trigger on the survey_response workflow and just created another workflow for the task_survey table and created a condition to only run when state was completed and then within that workflow I called my existing WF and so now I only get one instance of the WF running - Thanks for your help and pointing me in the right direction.

[Daniel Voutt]

After further testing I have now found that when I update a field in the record to "true" it doesn't correspond to the WF and so the wf just hangs - do you have any examples on how I can look for the field to change and then populate a new table with both static values and actual from the response.   I can then trigger the WF from the new table and the rest is fairly simple.

[Harish Murikina]

Sorry didnt get you could you explain bit more