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:
- Will check if there are any responses that have not got a 'Yes' in the Processed column
- 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'.
- Email the created csv
- Mark the exported responses as 'Yes' in the Processed column
Many thanks
David
