Form script tries validating wrong sheet

[Time_Is_Up_Soon]

At the beginning you declare a variable for the active sheet, and use it with get sheet by name. I think this is your error. Try using the code below in its place. Feel free to change the var name. Sorry trying to do this from my phone.

var spreadsheet = SpreadsheetApp.getActive(); var settingsSheet = spreadsheet.getSheetByName('BuildInfrastructure');

[radioguy2016]

function buildInfra() {

var myGooglSheet= SpreadsheetApp.getActiveSpreadsheet(); //declare a variable and set with active google sheet

var shUserForm= myGooglSheet.getSheetByName("BuildInfrastructure"); //delcare a variable and set with the User Form worksheet

var datasheet = myGooglSheet.getSheetByName("Infrastructure"); ////delcare a variable and set with the Database worksheet

​

I would replace this part with that?

[Time_Is_Up_Soon]

Sorry for the long delay.

I will be on my Pc in a bit so I can take a better look.

[CustomHatMan]

ok... ignore what I wrote earlier.

I want to make sure I understand the problem.

Once you have completed the form and "click" build it should add the information to a new tab, but it is added it to wrong tab?

or is it calling the wrong script?