gpt4 book ai didi

Create Bulk Certificates By Account Owner(按帐户所有者创建批量证书)

转载 作者:bug小助手 更新时间:2023-10-25 18:30:42 25 4
gpt4 key购买 nike



is this possible in Google Slides with GAS? If so, I hope someone can help me.

在带汽油的谷歌幻灯片中,这是可能的吗?如果是这样的话,我希望有人能帮助我。


I have two templates of certificate. 1 template is for Accounts with 100% score, and another template for Accounts with scores below 99%.

我有两张证书模板。1个模板用于100%分数的帐户,另一个模板用于分数低于99%的帐户。


Here is the Google Sheet data source.

这里是Google Sheet数据源。


[Test File Certificates] (https://docs.google.com/spreadsheets/d/1negtTNpsyLJDghquVa3SJLkYFFv4vVpDRB_G0u7pYl4)

[测试文件证书](https://docs.google.com/spreadsheets/d/1negtTNpsyLJDghquVa3SJLkYFFv4vVpDRB_G0u7pYl4)


What I want to happen are the ff:

我希望发生的是ff:



  1. If account's score is 100%, use template1. If below 100%, use template2.



  2. If account belongs to same Owner, the certificates should only be in one Google Slide file.




For example, since Jason has 2 accounts, his slide with his name on file name will contain 2 pages, 1 page for template1 and another page for template2. Same for Cero, but both pages are template2. Then Alie's google slide file will only have 1 certificate with the template1 format.

例如,由于Jason有2个帐户,他的文件名上有他的名字的幻灯片将包含2页,1页用于模板1,另一页用于模板2。Cero也是如此,但两个页面都是模板2。那么Alie的Google幻灯片文件将只有一个模板1格式的证书。



  1. Copied certificates must be save into a specific drive.


Templates has the same format. Just has Account and Month in it. The difference between the two is just the picture.

模板具有相同的格式。里面只有账户和月份。两者之间的区别只是画面而已。


Template for 100%

100%的模板


Template for below or equal to 99%

低于或等于99%的模板


Can these be done? I hope someone can help/guide me.

这些都可以做到吗?我希望有人能帮助/引导我。


更多回答

I believe it’s possible to create emailable certificates.

我相信有可能创建可通过电子邮件发送的证书。

perhaps this sample script can help you: developers.google.com/apps-script/samples/automations/…

也许这个样例脚本可以帮助您:developers.google.com/apps-script/samples/automations/…

优秀答案推荐
更多回答

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com