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.
Thanks
Notes:
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)
Can you please share the link of form you are talking about?
When you say "The Form and automation need to be easily duplicated So I can run a new form and data export each month." can you please explain which automation you want to duplicate?
can we have a quick chat?
I'm very interested in getting your work done. I feel confident to complete it according to your requirements because I have some experience in google doc automation setup. I have gone through the project details and I understand the job description perfectly. Kindly get back to me with more details. I look forward to working and also to your prompt and favorable reply. Thanks in advance!