Text
Example: Data Modelling (Hotel Reservation) 创建APP&Tabs
搜索App和Tabs,定制Lightning App
0 notes
Text
Example: Data Modelling (Hotel Reservation) 创建Junction Object
Contact和Room关系是Many to many,所以中间有一个Junction Object,这里Reservation就是Junction Object
start date是Date类型
End Date, 比如三天之后
打开Schema Builder即可看到Objects的关系
0 notes
Text
Example: Data Modelling (Hotel Reservation) 创建Fields 2
Object Rooms里面建Master detail 和Hotel关联
再建Tariff Field,类型选择Currency
Occupancy Field选择使用Picklist
0 notes
Text
Example: Data Modelling (Hotel Reservation) 创建Fields
1. 打开相对应的Objects里面,根据Data Modelling的要求创建Fields
比如Hotel要创建Street Address,field type选择Text
State & City,这需要设置dependent field
先弄State Picklist,选择Picklist Field Type, 再建City Picklist, 设置和上面一样
设置两个Field的dependence,点击Field dependence按钮
New, Controlling Field选择State,因为得先选State才能选择City。Dependent Field依赖Controlling Field的选择。可以Preview查看设置对否
0 notes
Text
Example: Data Modelling (Hotel Reservation) 创建Objects
1. 设计Data Modelling,如图
2. 打开Object Manager里的Custom Object,新建Hotel、Room、Reservation objects,contact不用建因为是standard object
0 notes
Text
Dependent Picklist
Standard Field = Out of box 系统自带的Field
Controlling Field & Dependent Field
比如你选择澳洲,State变成各种州,选择州可以选择各种城市
Controlling Field 控制 Dependent Field
比如State是Controlling Field,City就是Dependent Field
0 notes
Text
Relationships between Lookup & Master detail
Lookup, 像reference连接两个objects,删除互不影响, lookups不支持roll-up summary,sharing和security设置互不影响,每个object最多支持25个lookups
Master detail里,所有都是主从关系,删掉主等于自动删除从,所有设置都是承继关系
0 notes
Text
Field Types in Salesforce
Formula Field像excel里面的function,比如sum
Lookup Relationship就像reference
Master-detail relationship直接展示detail
Test(Encrypted) 可以用在保存银行卡信息,比如只展示后几位
0 notes