Automate Daily CSV Export New Responses

%3CLINGO-SUB%20id%3D%22lingo-sub-1962213%22%20slang%3D%22en-US%22%3EAutomate%20Daily%20CSV%20Export%20New%20Responses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1962213%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20wanting%20to%20add%20automate%20script(s)%20to%20my%20excel%20for%20web%20file%20that%20I%20could%20schedule%20to%20run%26nbsp%3Bat%20a%20specified%20time%20each%20day%20to%20do%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EWill%20check%20if%20there%20are%20any%20responses%20that%20have%20not%20got%20a%20'Yes'%20in%20the%20Processed%20column%3C%2FLI%3E%3CLI%3E%3CFONT%20face%3D%22inherit%22%3Eif%20there%20are%20any%20then%20create%20a%20csv%20file%20(is%20this%20possible%20yet%3F)%20with%20user-%3C%2FFONT%3Efriendly%3CFONT%20face%3D%22inherit%22%3E%26nbsp%3Bcolumn%20names%2C%20such%20as%20for%20a%20column%20in%20excel%20named%20'Will%20you%20be%20at%20least%2018%20years%20of%20age%20at%20the%20start%20of%20your%20course%3F'%2C%20the%20column%20name%20in%20the%20export%20could%20say%20'18_years'.%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%20face%3D%22inherit%22%3EEmail%20the%20created%20csv%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%20face%3D%22inherit%22%3EMark%20the%20exported%20responses%20as%20'Yes'%20in%20the%20Processed%20column%3C%2FFONT%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%3CFONT%20face%3D%22inherit%22%3EMany%20thanks%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20face%3D%22inherit%22%3EDavid%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1962213%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I am wanting to add automate script(s) to my excel for web file that I could schedule to run at a specified time each day to do the following:

 

  1. Will check if there are any responses that have not got a 'Yes' in the Processed column
  2. if there are any then create a csv file (is this possible yet?) with user-friendly column names, such as for a column in excel named 'Will you be at least 18 years of age at the start of your course?', the column name in the export could say '18_years'.
  3. Email the created csv
  4. Mark the exported responses as 'Yes' in the Processed column

Many thanks

David

0 Replies