PermissionSetting.ViewableRecordSetting(属性)

说明

可读写 Sheet类型为数据表且权限类型为可编辑/可查看时支持读写属性 可查看的记录(行)范围，其他情况下不支持读写

当PermissionRecordConfigType为Custom时，ViewableRecordSetting才有效表示设置的筛选区域内记录可编辑

返回值

Criteria

浏览器环境示例

async function example() {
    await instance.ready();
    const app = instance.Application;
    const customRole = await app.Permission2.Roles.Add("CustomRole");
    const criteria = await app.Criteria('@文本', 'Intersected', ['1', '2']);
    // 设置ViewableRecordSetting
    customRole.PermissionSettings(1).ViewableRecordSetting = [criteria];
    // 读取ViewableRecordSetting
    const viewableRecordSetting = await customRole.PermissionSettings(1).ViewableRecordSetting;
    console.log(viewableRecordSetting);
}

脚本编辑器 示例

function main() {
    const customRole = Application.Permission2.Roles.Add("CustomRole");
    // 设置ViewableRecordSetting
    const criteriaArr = [];
    const criteria = Application.Criteria('@文本', 'Equals', ['1']);
    criteriaArr.push(criteria);
    customRole.PermissionSettings(1).ViewableRecordSetting = criteriaArr;
    // 读取ViewableRecordSetting
    const viewableRecordSetting = customRole.PermissionSettings(1).ViewableRecordSetting
    console.log(viewableRecordSetting);
}
main();