Hello!
I am looking to build a survey that goes out weekly to customers who submit work items for repair. I am using the Directory Automations to collect the information from a query that is updated daily with new work items or completed work items. What I am looking for is a way to send a single weekly survey with a yes/no question if they are satisfied with the completed repair from that week. An example is below:
Week 1
Customer Name | Work Item# | Status |
---|---|---|
Customer A | A.1 Work Item | Open |
Customer A | A.2 Work Item | Completed |
Customer A | A.3 Work Item | Completed |
Customer A | A.4 Work Item | Open |
The survey should be as follows for Customer A every week.
Q1. Are you satisfied with the repair of A.2?
(Yes/No)
Q2. Are you satisfied with the repair of A.3?
(Yes/No)
Week 2
Customer Name | Work Item# | Status |
---|---|---|
Customer A | A.1 Work Item | Completed |
Customer A | A.2 Work Item | Completed |
Customer A | A.3 Work Item | Completed |
Customer A | A.4 Work Item | Completed |
Q1. Are you satisfied with the repair of A.1?
(Yes/No)
Q2. Are you satisfied with the repair of A.4?
(Yes/No)