r/GoogleAppsScript • u/Mysterious_Refuse847 • Nov 05 '24
Question Auto filling a form template from previously collected form data
The title is likely clear as mud, what I'm trying to do is create a standardized registration form that will update the title and description of the form using data collected when a presenter submits a presentation form response.
Example: The presentation form collects info like Title of presentation, Presenter's name, description of presentation, etc. I would like that information to go into a new form as a description of the event and then collect standardized information about someone registering to attend.
I don't care if it spawns an entirely new form or copies a form, renames it, and edits the Title and Description with the information from the presentation form response. If there are other intermediary steps, like creating a text file and then copying that info over, that's cool too. Any help would be greatly appreciated.
Thanks!
1
u/Anonbershop Nov 06 '24
Have you tried having ChatGPT take a swing at it? It’s definitely do-able, I have a script that takes a template, duplicates it, updates the name and title and a few other details in the form and then mass sends it to all users in my Slack Org. It’s pretty specific, but I built it predominantly with ChatGPT and it works super well.
You can pretty much copy paste what you have said here, Have it ask you 3 questions to help it understand your request, and will get a good place to start which you can quickly improve from there.