Appearance
用户选择
说明
| 说明项 | 内容 |
|---|---|
| 分类 | 控件类 |
| 存储类型 | TableAccountSimple,Array<TableAccountSimple> |
| 是否可排序 | 是 |
| 是否支持过滤 | 是 |
| 支持过滤器类型 | 包含、不包含、等于、不等于、等于空、不等于空、在列表中、不在列表中 |
设置项
| 设置项 | 说明 |
|---|---|
| 允许不填写 | 设置该字段是否必填 |
| 多选 | 开启后该用户选择将支持多选，多选后会更改字段的存储类型 |
| 未填写时在表单中的占位符 | 在该字段未输入信息时展示在输入框内的文字信息 |
| 使用当前用户作为默认值 | 开启后将使用当前操作用户作为默认值 |
| 数据源 | 可设置选项值的数据源 选项： 应用成员、团队成员 |
| 选择器样式 | 可设置选择器的展示选项时的样式，仅在数据源为团队成员时显示 选项： 列表、部门树和成员列表 |
| 选定选择范围 | 数据源为应用成员时，开启后可通过应用角色限定选择用户成员的范围 |
| 显示样式 | 可设置字段内容的显示样式 选项： 头像和名称、头像、名称、纯文本 |
| 使用自动化设置待选列表 | 支持使用自动化对设置的选项值进行过滤 |
| 自动化输入参数 | 调用自动化计算待选值时的可传入参数 |
注意事项
因为单选和多选的存储类型不同，所以在开启/关闭多选可能会丢失数据，需谨慎操作
在数据库中的存储格式
| 字段类型 | 说明 |
|---|---|
| jsonb | 存储JSON格式数据，JSON数据结构见下方 |
在数据表中，用户选择字段数据会存储为json格式,如果是多选，会存储为json数组。json结构如下：
ts
interface TableAccountSimple {
id:string;//ID
name:string;//名称
avatar:string;//头像
}1
2
3
4
5
2
3
4
5
使用自动化设置待选列表（应用成员）
js
let users=
[
{
"avatar": "pic16.png",
"hint": "lisiming",
"id": "lisiming",
"name": "李思明",
"remark": "mingsi.li"
},
{
"avatar": "pic17.png",
"hint": "wangmingjun",
"id": "wangmingjun",
"name": "王明君",
"remark": "wangmingjun992"
}
]
automatic.setReturnValue(users);1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
使用自动化设置待选列表（团队成员）
js
let userDepts=
[
{
"id": "900001",
"name": "深圳XXX科技有限公司",
"type": "department",
"children": [
{
"avatar": "pic16.png",
"hint": "zhaosunfu",
"id": "zhaosunfu",
"name": "赵孙福",
"remark": "zhaosunfu001",
"type": "member",
"departmentIdList": [
"900001",
"900103"
]
},
{
"id": "900103",
"name": "总办",
"type": "department",
"children": [
{
"avatar": "pic16.png",
"hint": "zhaosunfu",
"id": "zhaosunfu",
"name": "赵孙福",
"remark": "zhaosunfu001",
"type": "member",
"departmentIdList": [
"900001",
"900103"
]
},
{
"avatar": "pic16.png",
"hint": "lisiming",
"id": "lisiming",
"name": "李思明",
"remark": "mingsi.li",
"type": "member",
"departmentIdList": [
"900101",
"900103"
]
}
]
},
{
"id": "900101",
"name": "研发部",
"type": "department",
"children": [
{
"avatar": "pic16.png",
"hint": "lisiming",
"id": "lisiming",
"name": "李思明",
"remark": "mingsi.li",
"type": "member",
"departmentIdList": [
"900101"
]
},
{
"avatar": "pic17.png",
"hint": "wangmingjun",
"id": "wangmingjun",
"name": "王明君",
"remark": "wangmingjun992",
"type": "member",
"departmentIdList": [
"900101"
]
}
]
},
{
"id": "900102",
"name": "市场部",
"type": "department",
"children": [
{
"id": "900111",
"name": "上海部",
"type": "department",
"children": [
{
"avatar": "pic17.png",
"hint": "qiansijiang",
"id": "qiansijiang",
"name": "钱思疆",
"remark": "qiansijiang003",
"type": "member",
"departmentIdList": [
"900111"
]
}
]
},
{
"id": "900112",
"name": "深圳部",
"type": "department",
"children": [
{
"avatar": "pic17.png",
"hint": "sunming",
"id": "sunming",
"name": "孙明",
"remark": "sunming004",
"type": "member",
"departmentIdList": [
"900112"
]
}
]
},
{
"id": "900113",
"name": "西安部",
"type": "department",
"children": [
{
"avatar": "pic17.png",
"hint": "zhangwu",
"id": "zhangwu",
"name": "张武",
"remark": "zhangwu",
"type": "member",
"departmentIdList": [
"900113"
]
}
]
}
]
}
]
}
]
automatic.setReturnValue(userDepts);1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
展示效果
