Hi, I have a basic Google Form for collecting company news for a monthly newsletter. I need help making it more user-friendly and then automating the data export into a google doc for easier editing/proofreading before I manually insert each response into an InDesign file. The Form and automation need to be easily duplicated So I can run a new form and data export each month. Is this something you could help with? If so, please get back to me with price and turnaround time. If you need any clarification I can talk you through it.
The steps I need in the process are as follows:-
1. User receives link to form in email
2. User adds their submission, with easy option to add multiple submissions (At the moment they have to enter their name on each submission. I'd like this to be pre-filled on subsequent submissions if possible. Also, it would be good to add a word limit to one field)
3. I receive an email notification of each submission (not the email address that owns the form/google drive)
3. Automated data export into a google doc for each submission (Ideally all submissions collated on a new page of one document, but if not, separate docs with custom filename containing form fields including name, project and sequence number)