FieldDescriptor.LinkFieldId(属性)

说明

可读写

引用内容 设置为 关联的字段Id 以联接数据表

返回值

String

浏览器环境示例

async function example() {
  await instance.ready();
  const Application = instance.Application
  const fieldDescriptor = await Application.Sheets("数据表").FieldDescriptors("@查找引用")
  const linkFieldId = await Application.Sheets("数据表").FieldDescriptors("@单向关联")
  const prop = await fieldDescriptor.Lookup
  prop.LinkFieldId = linkFieldId
  fieldDescriptor.Apply()
}

脚本编辑器 示例

function main() {
  const fieldDescriptor = Sheets("数据表").FieldDescriptors("@查找引用")
  const linkFieldId = Sheets("数据表").FieldDescriptors("@单向关联")
  const prop = fieldDescriptor.Lookup
  prop.LinkFieldId = linkFieldId
  fieldDescriptor.Apply()
}
main()