组脚本帮助需要
问题描述:
我已经拿到了剧本以下工作对我来说......(脚本自动生成与电子表格是填充了从表单数据的自动数据的谷歌组...)组脚本帮助需要
function onFormSubmit() {
var sheet = SpreadsheetApp.openById("17KZXpWHipISZSqgD9w255VrirzITrks0fLaBpXp7Ybk")
var email = sheet.getRange("B"+sheet.getLastRow()).getValue()
var name = sheet.getRange("C"+sheet.getLastRow()).getValue()
var user = sheet.getRange("AH"+sheet.getLastRow()).getValue()
try{
AdminDirectory.Groups.insert(
{
"email": email,
"name": name,
}
)
AdminDirectory.Members.insert(
{
"email": user,
"role": "OWNER",
}
, email)
GmailApp.sendEmail("[email protected]",email + " Group creation | Success", " address has been created for " + name)
} catch(e){}
}
有人能帮助我完成它的剩余步骤,我不能获得工作是:
集集团适度设置:跳过审核队列发布消息组
设置发帖权限:公共
function onFormSubmit() {
var sheet = SpreadsheetApp.openById("17KZXpWHipISZSqgD9w255VrirzITrks0fLaBpXp7Ybk")
var email = sheet.getRange("B"+sheet.getLastRow()).getValue()
var name = sheet.getRange("C"+sheet.getLastRow()).getValue()
var user = sheet.getRange("AH"+sheet.getLastRow()).getValue()
try{
AdminDirectory.Groups.insert(
{
"email": email,
"name": name,
}
)
AdminDirectory.Members.insert(
{
"email": user,
"role": "OWNER",
}
)
AdminDirectory.Groups.update(
{
"whoCanJoin": "CAN_REQUEST_TO_JOIN",
"whoCanViewMembership": "ALL_IN_DOMAIN_CAN_VIEW",
"whoCanViewGroup": "ALL_IN_DOMAIN_CAN_VIEW",
"whoCanInvite": "ALL_MANAGERS_CAN_INVITE",
"allowExternalMembers": "false",
"whoCanPostMessage": "PUBLIC",
}
)
AdminDirectory.Groups.moderation(
{
"Spammessages": "Skip_the_moderation_queue_and_post_to_the_group"
}
, email)
GmailApp.sendEmail("[email protected]",email + " Group creation | Success", " address has been created for " + name)
} catch(e){}
}
我试过,但无论是我累了还是我失去了一些愚蠢的......?
答
从这个documentation为本,whoCanPostMessage
属性可能的值是:
-
ALL_IN_DOMAIN_CAN_POST
- 任何人的帐户可以发布的消息。 -
ALL_MANAGERS_CAN_POST
- 经理人,包括集团的业主,可以发帖子。 -
ALL_MEMBERS_CAN_POST
- 任何组成员可以张贴的消息。 -
ANYONE_CAN_POST
- 您的帐户之外的任何谷歌Apps的用户可以访问谷歌网上论坛服务,并发布消息。
提示:当whoCanPostMessage
设置为ANYONE_CAN_POST
时,我们建议将messageModerationLevel
属性设置为MODERATE_NON_MEMBERS
以保护该组免受可能的垃圾邮件。 -
NONE_CAN_POST
- 集团被禁用和归档。没有人可以发布消息给这个组。- 当
archiveOnly value="false"
,将whoCanPostMessage
属性更新为NONE_CAN_POST
时,会导致错误。 - 如果
archiveOnly
从"true"
恢复为"false"
,则whoCanPostMessages
属性设置为ALL_MANAGERS_CAN_POST
。
- 当
另外,我没有看到关于AdminDirectory.Groups.moderation
和Spammessages
任何引用。您可能要检查给定的文件,看看是否messageModerationLevel
和spamModerationLevel
帮助。