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.6k
はじめてのCommunity Cloudデータセキュリティ / Community Cloud Data Sharing Basic
shunkosa
1
1.2k
Lightning Web ComponentでチャットのUIをカスタマイズしよう / Enhance Chat UI with LWC
shunkosa
0
1.4k
JP Salesforce SAML SSO for Beginners
shunkosa
0
1.1k
Testing Lightning Flow
shunkosa
0
750
Schedule Your Process Without Coding
shunkosa
0
650
Service Cloud Omni-Channel Basics and New Features
shunkosa
0
940
Other Decks in Technology
See All in Technology
LLM開発を支えるエヌビディアの生成AIエコシステム
acceleratedmu3n
0
370
Strands Agents & Bedrock AgentCoreを1分でおさらい
minorun365
PRO
6
230
Claude Codeから我々が学ぶべきこと
s4yuba
6
1.8k
大規模イベントに向けた ABEMA アーキテクチャの遍歴 ~ Platform Strategy 詳細解説 ~
nagapad
0
190
【2025 Japan AWS Jr. Champions Ignition】点から線、線から面へ〜僕たちが起こすコラボレーション・ムーブメント〜
amixedcolor
1
120
生成AI時代におけるAI・機械学習技術を用いたプロダクト開発の深化と進化 #BetAIDay
layerx
PRO
1
1k
ビジネス文書に特化した基盤モデル開発 / SaaSxML_Session_2
sansan_randd
0
260
Kiroから考える AIコーディングツールの潮流
s4yuba
4
660
人に寄り添うAIエージェントとアーキテクチャ #BetAIDay
layerx
PRO
8
2k
o11yツールを乗り換えた話
tak0x00
1
130
相互運用可能な学修歴クレデンシャルに向けた標準技術と国際動向
fujie
0
200
Unson OS|48時間で「売れるか」を判定する AI 市場検証プラットフォーム
unson
0
170
Featured
See All Featured
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
656
60k
Why Our Code Smells
bkeepers
PRO
337
57k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
30
2.2k
GraphQLの誤解/rethinking-graphql
sonatard
71
11k
Connecting the Dots Between Site Speed, User Experience & Your Business [WebExpo 2025]
tammyeverts
8
420
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
110
19k
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
kevinliebholz
34
6k
Intergalactic Javascript Robots from Outer Space
tanoku
272
27k
Unsuck your backbone
ammeep
671
58k
The Power of CSS Pseudo Elements
geoffreycrofte
77
5.9k
Java REST API Framework Comparison - PWX 2021
mraible
32
8.8k
Bootstrapping a Software Product
garrettdimon
PRO
307
110k
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!