Creating tickets using google form as ui

Filippoc · October 28, 2021, 12:25pm

Hi!
I’ve written few lines of code (Google Apps Script) to create a ticket every time a user submit the form.
The code works and it handles the uploaded files aswell but since i’m not a developer i’m looking forward to improve it (or to avoid issues i’m not considering). Is this the right place to post a blog-post about the code and/or the code itself?
Thanks!

astrugatch · October 28, 2021, 2:14pm

Put it in GitHub and share that.

Filippoc · October 29, 2021, 6:09am

github.com

crnfpp/GoogleForm-to-Zammad/blob/main/gFormToZammad.js

var POST_URL = "________";
var MY_TOKEN = "________"
function onSubmit(e) {
    var form = FormApp.getActiveForm();
    var allResponses = form.getResponses();
    var latestResponse = allResponses[allResponses.length - 1];
    var response = latestResponse.getItemResponses();
    
    // "collect e-mail function" under settings is required for this script to work
    var mail = allResponses[allResponses.length - 1].getRespondentEmail();

    // Creating the ticket body 
    var ticketBody ="";
    for (let i = 0; i < response.length; i++) {
       
       // The following code is only needed if you have your users uploading files. 
        if (response[i].getItem().getType() == "FILE_UPLOAD")   
            {
                var string = response[i].getResponse().toString();
                var splitted = string.split(",");

This file has been truncated. show original

Here it is!

Filippoc · January 26, 2023, 9:38am

Hi!
We’ve refactored the code to include a better error handling logic and moved the repository here: