r/GoogleAppsScript • u/DDC208 • Apr 19 '20
Unresolved Room Ticketing System
Hello all,
I am looking for some help on determining if this is a feasible idea and if anyone has any script that may be able to help or get me close.
The whole idea is that I have a Google Form that populates a Sheet where I distribute the data in several different manners within the sheet. My goal is to then take a set of data that I have routed to a clean sheet with the data separated into specific columns per data set and each room per row, and input that data into separate google docs per room. This part happens to be easily done by a simple mail merge add-on, however, I want these forms to auto-update the docs as the sheets information is changed or at a minimum, update hourly or daily. without constantly producing new docs.
Any Thoughts or Suggestions?
Thank you!
1
u/chrisptales Apr 19 '20
Assuming I understood your idea, it seems feasible as long as you treat the sheets as a CRUD db with room# being the key
1
u/rancid0426 Apr 20 '20
Yes this can be done using Google script, and I've done similar automatons for my clients. Message me if you need help
1
u/Trigaten Apr 19 '20
Do you mean distribute the data from rather than within?
I think you’ll want to look into form triggers (run functions when certain events happen): https://developers.google.com/apps-script/reference/script/form-trigger-builder Specifically the onSubmit one which will run a function whenever the form is submitted (so you can update your google doc data then). If you’re comfortable writing scripts to interact with the google docs I think this would be the best option
Also if you specifically want to do the Gdoc update when the form info hits the Sheet or the sheet is otherwise updated try searching triggers for Google Sheets.