|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/google-apps-script-calendarapp/
课程评论：没有评论
**课程名称：Google Apps Script 日历与表格应用项目** **课程概述：** 本课程将引导您探索如何利用 Google Apps Script 开发交互式应用程序，以优化业务流程并扩展 Google 套件的功能。通过一个实际项目，您将学会如何在一个 Google 表格中搜索用户的 Google 日历，并将结果记录在表格中。此外，课程还将教授如何通过电子表格菜单或 Web 应用 URL 表单，将条目添加到用户的日历中。 **先修知识：** * **JavaScript：** Google Script 基于 JavaScript，因此具备 JavaScript 基础知识是必需的。许多 JavaScript 的方法和代码可以直接用于 Google Script 编写。 * **HTML 和 CSS：** 了解 HTML 和 CSS 对于构建用户界面和 Web 应用至关重要。 **核心内容：** * **CalendarApp：** * 选择和检索日历事件。 * 创建新事件到日历。 * **SpreadsheetApp：** * 更新用户界面，添加按钮。 * 从 UI 工具菜单运行函数。 * 创建新的工作表。 * 向电子表格添加行和内容。 * 使用 UI 对话框窗口、Toast 提示和侧边栏。 * **HTML Service：** * 使用 HTML 模板文件生成项目输出和弹出窗口。 * **Web 应用：** * 创建 Web 应用，通过 URL 连接到 Google Script 方法。 * 从客户端发送数据到服务器端，并进行响应处理。 * **JavaScript 技巧：** * 检查字符串中是否存在特定值。 * 使用 JavaScript、HTML 和 CSS 配合模板作为对话框。 * 将表单数据发送到 Google Script 进行处理。 **课程特色：** * **项目驱动：** 课程采用项目为导向，循序渐进地指导您构建实际应用。 * **源码提供：** 包含项目源代码，方便您动手实践。 * **零基础友好：** 即使是从未接触过 Google Script 的初学者，也能轻松上手。 * **强大功能：** 展现 Google Script 如何轻松实现各种令人惊叹的功能，节省宝贵时间。 * **Q&A 支持：** 提供友好支持，解答您的学习疑问。 * **保障：** 提供 30 天退款保证。 **学习价值：** 通过本课程，您将能够： * 掌握 Google Apps Script 的核心应用，连接 Google 日历和表格。 * 提升工作效率，自动化重复性任务。 * 拓展 Google Workspace 的功能，创造更强大的业务工具。 * 为您的 Web 开发技能注入 Google 的强大动力。 **立即尝试，释放 Google Script 的无限潜能！**
Explore how you can use Google Apps Script to develop interactive applications that can be used to improve business workflow and extend the functionality of the google suite of products. This course covers building a project which adds the ability within a Google Spreadsheet to search the users Google Calendar and track results within the spreadsheet. In Addition create an option to add items into the users calendar from the spreadsheet menu as well as from a web app url form.JavaScript is a prerequisite to Google Script as its based on JavaScript coding. Many of the methods and code from JavaScript can be used to write Google Script. If you know JavaScript you know Google Script!!!! Google provides classes and methods that can be applied within the code to connect various Google products together to create some REALLY REALLY amazing functionality that can save time. Power up your web development using the POWER of GOOGLESo many amazing things can be done - if you have never used Google Script then prepare to be AMAZED - best of all its easy and you can do SOOOO MUCH with just a few lines of code.Course Contents -CalendarApp - selecting eventsCalendarApp - creating events into your calendarSpreadsheetApp - updating UI adding buttonsSpreadsheetApp - running functions from UI tool menuSpreadsheetApp - Creating new sheetSpreadsheetApp - Adding rows and content to spreadsheetHTMLService -Use of html templates files for project output and popup windowsSpreadsheetApp - UI dialog window, toast, sidebarWeb App with URL to connect to Google Script methodsSending data from client side to server side - return and response handlingJavaScript for checking if values exist in a stringJavaScript HTML and CSS for template used as dialogSending form data to Google Script to handlePlease note that this is a project based course covering step by step how to build and construct the project - source code is also included so you can try the code yourself.Step by step learning with all steps included.Beginner JavaScript knowledge is required. Also HTML and CSS knowledge is essential. Along with friendly support in the Q & A to help you learn and answer any questions you may have. Try it now you have nothing to lose, comes with a 30 day money back guarantee. Create your own Google Script see what amazing things you can build with it.
