google-form | Simple AJAX request to POST data to a google form | Form library

I'm hoping to combine this open letter/Google Suite workflow (https://jeffreyeverhart.com/2020/05/18/open-letter-maker-with-google-forms-docs-and-apps-script/) with an extra approval step that requires some form of approval (e.g. a checkbox in the Google Sheet, or some sort of edit/change in a Google Sheet) that would then and only then relay the information to the final Google Doc. I've been able to use the code from Jeffrey Everhart (see below) to successfully set up a Google Form -> Google Sheet -> Google Doc open letter workflow that takes Google Form information and adds it to the Google Doc on form submit. But I have not been able to make the script work for on edit/on change triggers, despite pulling out my hair trying all day yesterday. That would be ideal, because I could simply add a Checkbox "Approval" column in the google sheet that signals whether a form submission should proceed to the next step of being added to the Google Doc. Any suggestions?

Hi GAS/Javascript experts,

I found the script to auto-generate sequential IDs starts from which number we defined in a variable : Auto sequence ID However, I need to add 3 leading zeros to make sure the number of digits will be standardized to 6 digits in total inclusive the generated IDs. eg. 000100, 000101, 000102, 000103, .... And if so happens that the data rows will be more than 999999, the subsequence digit should automatically be added to be 7 digits and so forth.

Anyone can help to amend the script to achieve the above objectives, please? Tqvm.

The current script is as follows :-

This question comes from a previous one almost solved: Save a Google Form as PDF on a Drive's folder using Google Scripts

Perhaps this is a technical question and I am not programmer, so if possible I want a step-by-step answer so I can fully understand it.

The steps and purpose of the code are explained here: Hacking it: Generate PDFs from Google Forms.

The code is posted on the link but I post it here anyways:

I used the code from @contributorpw on this post get Entry ID which is used to pre-populate fields (Items) in a Google Form URL and added the extended list of form types from @SourceFli (in same post).

I get the error message: "Exception: The parameters (String) don't match the method signature for FormApp.CheckboxItem.createResponse". That checkbox has only 1 option: "yes".

The rest of all my form items are only TEXT items and work fine.

I am comparing the two string in the IF block and both of the strings are not null but a really weird error is being shown. Even though this same code is working with using simply servlets. But when I run this code in JSP it gives the error. I have already checked if the values were null but the output is exactly what was input in the form. My code is this

This is the next episode of my previous question (which was solved): Google Form Upload files to specific new folder based on the value submitted

SO, I succeeded to create a new folder on Google Drive based on value inputted by user in field NAME using this script.

so basically the task is quite simple, but I didn't find any workable solution for my problem. I have a huge upload script on my website (at the moment localhost), but lets reduce all the complexity to the only neccessary.

So I just want to upload a single file to Google Drive with Google App Script and receive the URL of it to save it in a var, to work with that information on a later point in my function.

Now the problem is I already have the form on my website, I dont want the form inside script.google.com as extra html, I want to transfer my user input to Google App Script, then upload it to google drive and return the url back to my website where I can save it into a var.

My problem now is, I cant put all the stuff together.

This is the form on my website (simplified):

I have a google sheet that gets updated from a Google Form. Unfortunately, Google forms insert a new row for every response so I can't get the formula applied to every row automatically. I found a workaround using arrayformulas here: https://www.labnol.org/google-form-formulas-050520#auto-number-form-responses-with-a-unique-id

and tried this:

I'm creating a Google-Form like application using angularJS and md-table, and to create my questionnaires i iterate through an array of questions, then through the possible answers: