how to store inputs in google sheets (other than HTML form)

Question

I have made a GUI which will record data remotely and store the data in a google sheet. I have been able to store the user inputs in google sheet but i am struggling with other values

My code (thanks to link)

```



  Listening Test
  
  
  

  
  

  
  
  

  
  
  
  
  





  
  
    
      
    
  
  
  
    Step 1: Enter sentence you want to start from 
 Step 2: click start and listen to the fixed set of audio files 
 If you detect speaker change point, give your response in the form of 'YES/NO'
    (Use earphones if available)

  
    
      Name
      
        
          
        
      
    
    
      Sentence Number
      
        
          
          
        
      
     

    
      
        
      
    

  

  






```

Validate google sheet and taking the google ID

```$(document).ready(function() {
    $('#test-form').bootstrapValidator({
        //submitButtons: '#postForm',
        // To use feedback icons, ensure that you use Bootstrap v3.1.0 or later
        feedbackIcons: {
            valid: 'glyphicon glyphicon-ok',
            invalid: 'glyphicon glyphicon-remove',
            validating: 'glyphicon glyphicon-refresh'
        },        
        fields: {
            firstName: {
             message: 'The first name is not valid',
                validators: {
                    notEmpty: {
                        message: 'The first name is required and cannot be empty'
                    },
                    stringLength: {
                        min: 1,
                        max: 30,
                        message: 'The first name must be more than 1 and less than 30 characters long'
                    },
                    regexp: {
                        regexp: /^[A-z]+$/,
                        message: 'The first name can only accept alphabetical input'
                    },
                }
            },
            lastName: {
                message: 'Last Name is not valid',
                validators: {
                    notEmpty: {
                        message: 'Last Name is required and cannot be empty'
                    },
                    stringLength: {
                        min: 1,
                        max: 30,
                        message: 'Last Name must be more than 1 and less than 30 characters long'
                    },
                    regexp: {
                        // regexp: /^[A-z]+$/,
                        message: 'Last Names can only consist of alphabetical characters'
                    },
                }
            },
            email: {
                validators: {
                    notEmpty: {
                        message: 'The email address is required and cannot be empty'
                    },
                    emailAddress: {
                        message: 'The email address is not a valid'
                    }
                }
            },
            address: {
                message: 'Address is not valid',
                validators: {
                    notEmpty: {
                        message: 'Address is required and cannot be empty'
                    }
                }
            }, 

        }
    })
    .on('success.form.bv', function(e) {
        // Prevent form submission
        e.preventDefault();

        // Get the form instance
        var $form = $(e.target);

        // Get the BootstrapValidator instance
        var bv = $form.data('bootstrapValidator');

        // Use Ajax to submit form data
        var url = 'https://script.google.com/macros/s/AKfycbxdbjLtkrE7SlC1OKBvOLoj7KpfFhKpZMb7xI-vxf64ZNIYsEViZl6kTJJMkab0wgyM/exec';
        var redirectUrl = 'recorder.html';
        // show the loading 
        $('#postForm').prepend($('').addClass('glyphicon glyphicon-refresh glyphicon-refresh-animate'));
        var jqxhr = $.post(url, $form.serialize(), function(data) {
            console.log("Success! Data: " + data.statusText);
            $(location).attr('href',redirectUrl);
        })
            .fail(function(data) {
                console.warn("Error! Data: " + data.statusText);
                // HACK - check if browser is Safari - and redirect even if fail b/c we know the form submits.
                if (navigator.userAgent.search("Safari") >= 0 && navigator.userAgent.search("Chrome") < 0) {
                    //alert("Browser is Safari -- we get an error, but the form still submits -- continue.");
                    $(location).attr('href',redirectUrl);                
                }
            });
    });
});```

My main javascript file where data will be loaded

```

  
    
    
    
    
  
  
    
      
        
        00:00 / 00:00
        
          
        
      

      

      
        
      
      
        
        

        
        
        
        
        

        

        

      
    

    
    
  

```

[![enter image description here][2]][2]


  [1]: https://gist.github.com/willpatera/ee41ae374d3c9839c2d6
  [2]: https://i.stack.imgur.com/sWmF7.png

As can be seen from the picture i want to add the value of button output from repeat, Yes and No to the google sheet.

That means every time the user presses 'Yes' the google sheet should update it as yes in that specific column. Same goes for the No and no. of repeatations.

Any kind of help would be greatly appreciated

Thank you

how to store inputs in google sheets (other than HTML form)

0 Answers