Skip to main content
Question

Modify a survey list automatically from a file with values


philippeb
Enthusiast
Forum|alt.badge.img+20

Hi there,

 

With Covid, all our employees going to work need to fill a survey about their health status now. Every day. It's the same for kids going in summer camp for activities.

 

So we've been asked to develop a survey that could change in time, depending on the kids that subscribed to the activities. The subscribed kids are exported into an Excel file every week. For the same activity, one week it could be 40 kids, the next one it could be 80.

 

I thought to read the file with FME and push the kids into the survey every week. That way the list of kids in the survey could change without our help. And the kid (or his parent) could select his name to fill the survey.

 

The issue is that we don't know any survey plateform able to change automatically from a script. Do you know if any kind of plateform could change when FME push new values into it? Survey123, Microsoft Forms, SurveyMonkey or something else?

 

Thanks.

4 replies

Forum|alt.badge.img+2

*Updated to add Safe article

 

You could try using a mix of FME, Zappier, and SurveyMonkey.

 

FME for your analytics/configuration

Zappier for the integration

Survey Monkey for the collection.

 

https://www.safe.com/blog/2014/02/zapier-web-enterprise-automation/

 

https://zapier.com/apps/surveymonkey/integrations/google-sheets


mark2atsafe
Safer
Forum|alt.badge.img+44

Do you have FME Server? You could set up the survey as an app. I just wrote a question-of-the-week article about how you might make a dynamic choice parameter using FME workspaces and an FME Server app.

https://knowledge.safe.com/questions/114810/question-of-the-week-dynamic-but-hacky-updates-to.html


philippeb
Enthusiast
Forum|alt.badge.img+20
  • Author
  • Enthusiast
  • June 1, 2020
mark2atsafe wrote:

Do you have FME Server? You could set up the survey as an app. I just wrote a question-of-the-week article about how you might make a dynamic choice parameter using FME workspaces and an FME Server app.

https://knowledge.safe.com/questions/114810/question-of-the-week-dynamic-but-hacky-updates-to.html

Yes, I do! That's amazing! I'll try to implement this as soon as possible. Thanks a lot!


mark2atsafe
Safer
Forum|alt.badge.img+44
philippeb wrote:

Yes, I do! That's amazing! I'll try to implement this as soon as possible. Thanks a lot!

Excellent. Let us know how it goes.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings