How to insert a cell value from another cell in an appendRow app script?

forgive me, I am new to app script. Thank you in advance.

I have a submit button form with a range of data, the destination is in another sheet. However, I need to insert the date, entity name and office in the appendRow.

The form:

Output (another sheet) :

Above output only appends the row. How do I submit it with those values also.

Submit button code:

function btn_dataEntryPrevSubmit(){
  var ui = SpreadsheetApp.getUi();
  var response = ui.alert('Are you sure you want to continue?', 
ui.ButtonSet.YES_NO);
  var result = ui.alert('Successfully submitted request!',ui.ButtonSet.OK)
  
  if (response == ui.Button.YES) {
    const idCell = formDE.getRange("A4")

    /*
    let deDate = formDE.getRange("F4")
    let deEntityName = formDE.getRange("F8")
    let deOffice = formDE.getRange("F10")
    */
    let dataEntryRange = formDE.getRange("D14:H")
    let values = dataEntryRange.getValues()

    for(let index = 0; index < values.length; index++){
      db_RequisitionOffice.appendRow(values[index])

      const nextIDCell = formDE.getRange("A4")
      const nextID = nextIDCell.getValue()
      values[index].unshift(nextID)

      idCell.setValue(nextID+1)
      nextIDCell.setValue(nextID+1)

      result
    }

      //====================================
      //DELETE VALUES IN DATA ENTRY FORM
      //====================================

      const dataEntryFieldRangeForDeletion = ["D14:H"]

      dataEntryFieldRangeForDeletion.forEach(f => formDE.getRange(f).clearContent())
  }
}

Thank you so much for your help.

Alternate Approach

You may use the map and unshift functions to adjust the output of the script to the proper columns.

Script:

You may use the following script as a basis for your own code:

function adjustData() {
  var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Form");
  var ssOut = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Output");
  var ssLastRow = ss.getLastRow();
  var ssLastColumn = ss.getLastColumn()

  var deDate = ss.getRange("F4").getValue();
  var deEntityName = ss.getRange("F8").getValue();
  var deOffice = ss.getRange("F10").getValue();

  //Extract Data
  var ssData = ss.getRange(14, 1, ssLastRow - 13, ssLastColumn).getValues();
  ssData.map(x => {
    x.unshift(deDate, deEntityName, deOffice); //Add date, entity name, and office to data
    ssOut.appendRow(x); //Transfer data
  });
  //delete data from form
  ss.getRange(14, 1, ssLastRow - 13, ssLastColumn).clear();
}

Result

Since you have not shared a sample spreadsheet, I went ahead and created a test case based on your post.

1. Form Sheet (Input)

2. Output Sheet (Output)

3. Cleared Form Sheet

Reference:

• unshift()
• map()
• appendRow()