Solved: Expression to get Table Data "Source Id" - Page 2

takuya_miyai · 04-17-2022 03:17 PM

Hi evreyone,

Is there an Expression that retrieves the Source Id?

I know there have been many requests for this in the past, but this is because Apps Script integration is now available and there are more and more cases where people want to use data sources from spreadsheets.

Note that when Google Drive is used as the data source, the parent folder ID can be obtained by passing the file ID to the Apps Script as shown below.
This will be the Table Data Source Id in AppSheet.

function getSourceId(fileId) {
  const file = DriveApp.getFileById(fileId);
  const parentsFolder = file.getParents();

  Logger.log(parentsFolder.next().getId());
}

I want to achieve the same thing in the Google sheet.

Thanks,

@carlinyuen
@nico

@Koichi_Tsuji

graham_howe

Why not store the ID in a tab in the Google Sheet, then you could access it as a table in AppSheet. If you wanted to have the cell automatically update (something that would really only be useful if you were likely to copy the Sheet) then you could add a script like the following to the spreadsheet:

function myID() {
   var thisURL = SpreadsheetApp.getActiveSpreadsheet().getUrl();
   var regex = new RegExp("\/d\/(.+)\/edit");
   var res = regex.exec(thisURL);
   return res[1];
}

View solution in original post