New answers tagged

0

You are trying to identify data submitted for a given Google Form question. Your debugging code is not displaying the information that you expect. You are confusing the pathway to list items with the pathway to list item responses. Though form.getItemById(id) returns a given item, it is a path to getting more information about item properties. It is NOT a ...


0

Q1:"duplicate a form retaining both responses and summary tables & charts". Yes. Refer Importing data into a Google Forms response sheet - your question is arguably a duplicate. I've just used this to do a proof-of-concept (also, the 1st answer provides a great explanation of the relationship between form and spreadsheet). As @Rubén notes, the ...


0

This is not a built-in feature but you can use Google Apps Script with some limitations copy the responses from the original form to the copy. One of the limitations is that timestamp will not be the same. From https://developers.google.com/apps-script Many Google apps, one platform in the cloud Increase the power of your favorite Google apps — like ...


0

Programs cannot make changes to your computer without administrative rights, for security reasons. The administrative privilege prevents applications or scripts from adjusting your computer without your consent, because those adjustments could potentially put malware on your computer. In addition, the right for a program to make changes often requires ...


0

You can build the Google Form with a Google Script. I am not sure if that will work dynamically while the form is in use or if you have to set the range of values for number validation up front and they remain static once the form is created. The following resource may come in handy: Class TextValidationBuilder Even if it says Text Validation, it refers to a ...


0

I'm sorry, but you cannot change the font color.


Top 50 recent answers are included