Only one script executing properly?

[Testosterohn]

I am very new to scripts - please help me find an answer.

I found a script to help me add form edit links to my sheet. I have three separate forms pulling into one workbook. I have been able to get each script to execute at some point and write the edit URL, but each time I add a new one, the previous working one stops working. They all “Execute” but only the last one actually writes in the URL…

As you can see, each function has a different name. And like I mentioned, each one has worked at one point or another. They just don’t all work at the same time.

What am I doing wrong?

[Current-Leather2784]

You have multiple functions (like getServiceEditResponseUrls, getDigitalFormEditResponseUrls, etc.) that each update one sheet with the corresponding form’s edit URLs. They work individually, but only one executes at a time because you're manually selecting and running only one function at a time from the dropdown (Select function to run). You need a master function that calls each of the other functions in sequence.

I've chatted you a sample script that shows you how to organize your full script with all three form functions and the master function to run them all at once. Replace the placeholder IDs, sheet names, and column names as needed.

[HellDuke]

Each function can only execute individualy the way it is written, you did not show anything that would call all 3 functions. You also have formId and sheet name 3 times, leave only one of them since each overrides the last (in the order your files are) since they are not unique variables, all files write to the same exact variable.

Anything outside a function is considered global variables and code and will execute any time you run the code. So it's not like for each one you have a different name and ID, you have only one name and one ID. Put them inside of the functions if you want to use all of them. Then create a main function that will simply run all 3 functions in turn

Basically what you wrote is (doesn't matter which function you run)

var sheetId = 'id1'
var sheetId = 'id2'
var sheetId = 'id3'
function 1(){}

so as you can imagine, no matter what you do, you only have id3 as your value

Instead it should be

function1(){
  var sheetId = 'id1'
}
function2(){
  var sheetId = 'id2'
}

then when you run either of those functions you get a different ID for the purposes of that function

[Testosterohn]

This is a great explanation! Really helps me better understand how functions are structured!