如何将电子表格链接到App Maker? [英] How can I link my spread sheets to App Maker?

问题描述

我是App Maker的新用户，我刚刚开始使用Google App Script进行编码，所以基本上我对这个主题不了解太多，今天我正在开发一个已经存在的应用程序在Google表格中，我必须使用App Maker重新创建它.唯一的问题是，我所有的数据和脚本都存储在Google表格中，而老板要求我不要导入数据，而是将App Maker与电子表格链接起来.例如，我有一个搜索表单，当我单击提交"按钮时，我得到用户在表单中输入的值，并将其放入Google表格中的现有搜索表单中，然后在Google表格中运行脚本，然后获取搜索结果从表格中显示并在App Maker中显示它们，请问有什么建议我该怎么做?

I'm a new user of App Maker and I've just started coding with Google App Scripts, so basically I don't know so many things about the subject, and today I'm working on a app that already exists at Google Sheets, and I have to recreate it using App Maker. The only problem is that I have all my data and scripts on Google Sheets and my boss asked to not import data but to link the App Maker with spread sheet. For example I have a search form and when I click the submit button I get the values that the user entered in the form and place them into the existing search form in Google Sheets and run the script in Google Sheet, and then get the search results from Sheets and display them in App Maker, please any ideas how can I do that?

推荐答案

您可以使用电子表格应用脚本API .此API提供对电子表格文件的完整CRUD访问权限:

You can access Google Sheets files using Spreadsheet Apps Script API. This API provides full CRUD access to Spreadsheet files:

var spreadsheet = SpreadsheetApp.openById(spreadsheetId);
var sheet = spreadsheet.getSheetByName(sheetName);
...

完整的示例代码在这里:

Full sample code lives here:

https://developers.google.com/appmaker/samples/spreadsheet/

在回答此问题时，您可以找到使用App Maker为某些第三方服务构建UI的高级步骤: Google App Maker如何创建来自Google通讯录的数据源

In answer to this question you can find high level steps to build UI for some 3rd party services with App Maker: Google App Maker how to create Data Source from Google Contacts

这篇关于如何将电子表格链接到App Maker?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！