Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
試して学ぶ数式項目・入力規則 / Salesforce Formulas and Valida...
Search
Shun Kosaka
October 31, 2019
Technology
3
1.4k
試して学ぶ数式項目・入力規則 / Salesforce Formulas and Validation Rules Hands on
Shun Kosaka
October 31, 2019
Tweet
Share
More Decks by Shun Kosaka
See All by Shun Kosaka
プロセスビルダーの設計書を生成しよう / Document Your Process
shunkosa
0
1.4k
はじめてのCommunity Cloudデータセキュリティ / Community Cloud Data Sharing Basic
shunkosa
1
1.1k
Lightning Web ComponentでチャットのUIをカスタマイズしよう / Enhance Chat UI with LWC
shunkosa
0
1.3k
JP Salesforce SAML SSO for Beginners
shunkosa
0
1k
Testing Lightning Flow
shunkosa
0
720
Schedule Your Process Without Coding
shunkosa
0
630
Service Cloud Omni-Channel Basics and New Features
shunkosa
0
910
Other Decks in Technology
See All in Technology
事業継続を支える自動テストの考え方
tsuemura
0
300
組織貢献をするフリーランスエンジニアという生き方
n_takehata
1
1k
AndroidデバイスにFTPサーバを建立する
e10dokup
0
240
地方拠点で エンジニアリングマネージャーってできるの? 〜地方という制約を楽しむオーナーシップとコミュニティ作り〜
1coin
1
130
CZII - CryoET Object Identification 参加振り返り・解法共有
tattaka
0
240
エンジニアの育成を支える爆速フィードバック文化
sansantech
PRO
3
660
Ask! NIKKEI RAG検索技術の深層
hotchpotch
13
2.8k
インフラをつくるとはどういうことなのか、 あるいはPlatform Engineeringについて
nwiizo
5
2.1k
Fintech SREの挑戦 PCI DSS対応をスマートにこなすインフラ戦略/Fintech SRE’s Challenge: Smart Infrastructure Strategies for PCI DSS Compliance
maaaato
0
450
Ask! NIKKEIの運用基盤と改善に向けた取り組み / NIKKEI TECH TALK #30
kaitomajima
1
450
スタートアップ1人目QAエンジニアが QAチームを立ち上げ、“個”からチーム、 そして“組織”に成長するまで / How to set up QA team at reiwatravel
mii3king
1
1.1k
バックエンドエンジニアのためのフロントエンド入門 #devsumiC
panda_program
16
6.5k
Featured
See All Featured
Done Done
chrislema
182
16k
The Invisible Side of Design
smashingmag
299
50k
How to Create Impact in a Changing Tech Landscape [PerfNow 2023]
tammyeverts
49
2.3k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
251
21k
What’s in a name? Adding method to the madness
productmarketing
PRO
22
3.3k
Statistics for Hackers
jakevdp
797
220k
GraphQLの誤解/rethinking-graphql
sonatard
68
10k
Art, The Web, and Tiny UX
lynnandtonic
298
20k
The Cult of Friendly URLs
andyhume
78
6.2k
Automating Front-end Workflow
addyosmani
1367
200k
Gamification - CAS2011
davidbonilla
80
5.1k
Fontdeck: Realign not Redesign
paulrobertlloyd
82
5.4k
Transcript
& TERAKOYA EAST Shun Kosaka | Accenture Japan | @shunkosa
✏ Salesforce Trailhead Playground Developer Edition 1 ✋ • •
• https://sli.do/ # 8230 2019 10 31 Salesforce TERAKOYA FORCE (Advanced + )
[ ] … 1. 2. 3.
IF(AND(ISBLANK(Terakoya_c), IsActive = true ), ‘ ’, ‘ ’ )
IF( AND( ISBLANK(Terakoya__c), IsActive = true ), ‘ ’, ‘ ’ ) https://help.salesforce.com/articleView?id=customize_formula_best_practices.htm&type=5 ( ) IF AND OR CASE • • = true
/
Step1. Help MONTH(2017/12/18) = 12 ❌ MONTH(LastModi edDate) ⭕ MONTH(LastModi
edDate ) /
/ Step2. / MONTH(LastModi edDate ) = MONTH(DATEVALUE(LastModi edDate)) =
12 DATEVALUE(2017/12/18 16:10) = 2017/12/18 STEP1 MONTH
/ Step3. ❌ MONTH(DATEVALUE(LastModi edDate)) & ⭕ MONTH(DATEVALUE(LastModi edDate)) &
& = 12 ( ) ( ) NG 12 ( ) ( ) Apex + +
/ Step4. / TEXT(12) = 12 MONTH(DATEVALUE(LastModi edDate)) & =
TEXT(MONTH(DATEVALUE(LastModi edDate))) & = 12 & = 12
1. • • 2. • 3. ❌ ⭕ ☺ Owner.ProfileId
= ’0e28000001qLOa’ …
ON ( ) PRIORVALUE
1. Playground Developer Edition 2. packaging/installPackage.apexp?p0=04t2v000005aNhH 3. URL lightning.force.com/ 2
https://brave-badger-180775-dev-ed.lightning.force.com/packaging/instalackage.apexp?p0=04t2v000005aNhH URL OK 4.
1 OK NG AND( ISPICKVAL(PRIORVALUE(StageName), ‘Value Proposition’), OR( ISPICKVAL(StageName, ‘Needs
Analysis’), ISPICKVAL(StageName, ‘Qualification’), ISPICKVAL(StageName, ‘Prospecting’) ) ) Value Proposition …
1 OK NG AND( ISPICKVAL(PRIORVALUE(StageName), ‘Value Proposition’), OR( ISPICKVAL(StageName, ‘Needs
Analysys’), ISPICKVAL(StageName, ‘Qualification’), ISPICKVAL(StageName, ‘Prospecting’) ) ) Value Proposition …
1 CASE(StageName, ‘Prospecting’, 1, ‘Qualification, 2, ‘Needs Analysis, 3, …
… ‘Closed Won’, 9, ‘Closed Lost’,9, 0 ) CASE(PRIOVALUE(StageName), ‘Prospecting’, 1, ‘Qualification, 2, ‘Needs Analysis, 3, … … ‘Closed Won’, 9, ‘Closed Lost’, 9, 0 ) 1 2 3 4 5 6 7 8 9 CASE 0縄 OK
2 • (TERAKOYA) • a IF(Account.ShippingState = , 500, 700)
2 • (TERAKOYA) • a IF(Account.ShippingState = , 500, 700)
2 • (TERAKOYA) • a IF(Account.ShippingState = , 500, 700)
2 Label Cost__c DeveloperName 500 Tokyo 600 Kanagawa 700 Others
IF( Account.ShippingState = $CustomMetadata.Terakoya_Shipping_Cost__mdt.Tokyo.MasterLabel, $CustomMetadata.Terakoya_Shipping_Cost__mdt.Tokyo.Cost__c, $CustomMetadata.Terakoya_Shipping_Cost__mdt.Others.Cost__c ) (Terakoya_Shipping_Cost__mdt)
2 ( ) • • • • • Apex •
( ) • Sandbox •
3 ( ) ⭕ ⭕ ⭕ ⭕ ⭕ ❌ ❌
ShippingState <> ‘ ’ || ShippingState <> ‘ ’ || ShippingState <> ‘ ’ || … 44 … …
3 ( ) NOT( CONTAINS( ‘ : : : :
: : : : : : : : : : : : : 結 : : : : : : : : : : : : : : : : : : : : : : : : : : : : : ’ , ShippingState ) ) || LEN(ShippingState) < 3 = ShippingState 3 ( ) OR IF CONTAINS
4 2 10% 8% ※ (TERAKOYA) ID API (DeveloperName)
5 (TERAKOYA) 30%縄
5 ※ TERAKOYA
https://gist.github.com/shunkosa/acf995909947d95174cd7ae5252ae4dd
• • ID • DeveloperName • • • • •
Trailhead Salesforce Help - https://help.salesforce.com/articleView?id=useful_advanced_formulas.htm&type=5
Thank you!