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:
If account's score is 100%, use template1. If below 100%, use template2.
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格式的证书。
- 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.
我相信有可能创建可通过电子邮件发送的证书。
我是一名优秀的程序员,十分优秀!