Issue with Variable Insertion in Google Apps Script

[Wessie3000x]

I am encountering an issue with variable insertion in Google Apps Script. I have a script where I'm trying to insert a variable from AppSheet into a text template, but I'm getting "undefined" as the result.

Here's a simplified version of my code:

function createFolderAndGoogleDocInDrive(folderName, abNumber) {
// ... (folder creation and document copying)

// Logging the value for debugging
Logger.log(abNumber["AB nummer"]);

// Extract the value of "AB nummer" from AppSheet and insert it into the content
var abNumberValue = abNumber["AB nummer"];
var content = `
...
AB number : ${abNumberValue}
...
`;

newDoc.getBody().setText(content);

Logger.log("Folder and Google Document created with ID: " + newFolder.getId());
}

What am I doing wrong?

[scott192]

What TYPE is abNumber in your fuction parameters (folderName,abNumber)?

What do you expect to see in the Log when you use (abNumber["AB nummer"])?

[Wessie3000x]

I have a column "AB nummer" with type LongText.
When i fill in for example "12" into the appsheet form I want it to create a document
where it says "AB number : 12"

Here is the whole script:

function createFolderAndGoogleDocInDrive(folderName, abNumber) {

  var parentFolderId = "11p6He8aR3X8EPmLQ5eKva9FjX9X8BBrH"; // Optioneel: vervang door de ID van een oudermap als je de nieuwe map binnen een andere map wilt maken

  var parentFolder = parentFolderId ? DriveApp.getFolderById(parentFolderId) : DriveApp.getRootFolder();

  var newFolder = parentFolder.createFolder(folderName);

  // Maak een nieuw Google Document door een sjabloon te klonen

  var templateFileId = "1uKooCaBPxLLNsh9wT0WLcy0sAMr9m10xsHONCu7pLDs"; // Vervang met het ID van je sjabloon Google Document

  var templateDoc = DriveApp.getFileById(templateFileId);

  var newDocFile = templateDoc.makeCopy(newFolder);

  var newDoc = DocumentApp.openById(newDocFile.getId());

  // Voeg deze regel toe voor debugging

  Logger.log(abNumber["AB nummer"]);

  // Haal de waarde van "AB nummer" op uit AppSheet en voeg deze toe aan de content

  var abNumberValue = abNumber["AB nummer"]; // Vervang met de juiste manier om de waarde op te halen uit AppSheet

  var content = `

D1. General information:

AB number                   : ${abNumberValue}

AB-category                 : ☐ Internal        V Supplier

`;

  newDoc.getBody().setText(content);

  Logger.log("Map en Google Document aangemaakt met ID: " + newFolder.getId());

}

This is what I get:

[Wessie3000x · Accepted solution]

I have changed  var abNumberValue = abNumber["AB nummer"];
to 
varabNumberValue = abNumber;
Now it works