通过公式获取指定成员部门
1. 使用场景
借助此例我们学习一下如何通过宜搭公式获取指定成员的部门。
2. 实现功能
成员开启【多选模式】时默认只获取第一个选择的成员部门。
2.1. 配置页面
![](https://yida-support.oss-cn-shanghai.aliyuncs.com/static/png/1711608284127-91719f61-391d-40ec-8ae7-79518e7b8575.png)
成员:成员组件
部门文本:单行文本组件
单个部门:部门组件
全部部门:部门组件,开启【多选模式】
2.2. 配置字段公式
部门文本(单行文本组件):
![](https://yida-support.oss-cn-shanghai.aliyuncs.com/static/png/1711608317550-36bf71a9-91cd-4541-93fe-da340a90776f.png)
{"text":"DEPTNAME(GetArrayItem(成员,1))","marks":[{"from":{"line":0,"ch":22,"sticky":null},"to":{"line":0,"ch":26,"sticky":null},"value":"employeeField_lu9ieou3","invalid":false}],"isCmData":true}
单个部门(部门组件):
![](https://yida-support.oss-cn-shanghai.aliyuncs.com/static/png/1711608439274-bfa4dd67-85e0-440e-808b-18a9de93afc0.png)
{"text":"DeptBuilder(GetArrayItem(成员,1))","marks":[{"from":{"line":0,"ch":25,"sticky":null},"to":{"line":0,"ch":29,"sticky":null},"value":"employeeField_lu9ieou3","invalid":false}],"isCmData":true}
全部部门(部门组件且开启【多选模式】):
![](https://yida-support.oss-cn-shanghai.aliyuncs.com/static/png/1711608514495-f1d7697a-1b8b-4b74-85d8-3c59e502547e.png)
{"text":"DeptBuilder(GetArrayItem(成员,1))","marks":[{"from":{"line":0,"ch":25,"sticky":null},"to":{"line":0,"ch":29,"sticky":null},"value":"employeeField_lu9ieou3","invalid":false}],"isCmData":true}
3. 实现效果
![](https://yida-support.oss-cn-shanghai.aliyuncs.com/static/png/1711608592447-b699d565-0107-45ee-a164-6c7dc497ebae.png)
![](https://yida-support.oss-cn-shanghai.aliyuncs.com/static/png/1711608628231-489da000-70d2-45e3-ab20-4f5c87158666.png)
4. 在线试玩
本文档对您是否有帮助?