根据Google表格文档自动填充Google日历 [英] Auto populating Google Calendar based on Google Sheets document

问题描述

我读过很多与我的问题相关的帖子...问题是我不是一个计算机程序员，它就像读一门外语给我。我试图混淆我的方式通过它，但无济于事。我主要是从这个帖子以及该页面的链接。

I've read a lot of posts related to my problem... The problem is I'm not a computer programmer and it's like reading a foreign language to me. I've tried to muddle my way through it but to no avail. I've mainly been working from this post and the links from that page.

我有一个Google表格文档，其中包含身份证号码列表，以及治疗的开始日期和结束日期。我希望能够运行一个脚本，该脚本将自动填充Google日历，ID号码作为活动标题和处理时间范围。我不需要开始和结束时间，我只是寻找日期。

I have a Google Sheets document with a list of id numbers and a start date and end date for treatments. I'd like to be able to run a script that will auto populate a Google Calendar with the id numbers as the event title and the treatment time frame. I don't need a start and end time, I'm only looking for dates.

我也想从同一个电子表格创建另一个Google日历。我有6列与每个ID号相关联 - 一个投影日期和3个不同类型的测试的实际日期。我希望能够运行另一个脚本，将测试类型填充为Google日历作为活动标题。再次，不关心时间，只是日期。

I would also like to create another Google Calendar from the same spreadsheet. I have 6 columns associated with each id number - a projected date and an actual date for 3 different types of testing. I would like to be able to run another script that populates a Google Calendar with the type of testing as the event title. Again, not concerned with times at all, just the dates.

我使用这个跟踪我正在运行的实验，它只是很多信息要看在电子表格。这将是很容易看到所有的测试，我需要做一个日历格式，所以我不会在错过测试天或什么时候停止治疗更多的错误。

I'm using this to track an experiment I'm running and it's just a lot of information to see on a spreadsheet. It would be nice easier to see all the testing I need to do in a calendar format so I don't make any more mistakes in missing testing days or when to stop treatments.

我一直在尝试3个星期来自己解决这个问题。

I've been trying for 3 weeks to figure this out on my own. Let's just say, I know nothing about coding...

推荐答案

您应该尝试在Google Apps脚本中编写函数。

You should try writing a function in Google Apps script.

1. 获取有效的 sheet ，get 范围，并检索id号码以及开始日期和结束日期。


2. 然后通过引用此链接。

1. Get the active sheet, get range and retreive the id numbers and a start date and end date.
2. Then create a calender event by referring to this link.

希望有所帮助！

这篇关于根据Google表格文档自动填充Google日历的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！