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.3k
試して学ぶ数式項目・入力規則 / 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.3k
はじめてのCommunity Cloudデータセキュリティ / Community Cloud Data Sharing Basic
shunkosa
1
1k
Lightning Web ComponentでチャットのUIをカスタマイズしよう / Enhance Chat UI with LWC
shunkosa
0
1.2k
JP Salesforce SAML SSO for Beginners
shunkosa
0
980
Testing Lightning Flow
shunkosa
0
700
Schedule Your Process Without Coding
shunkosa
0
600
Service Cloud Omni-Channel Basics and New Features
shunkosa
0
880
Other Decks in Technology
See All in Technology
信頼性に挑む中で拡張できる・得られる1人のスキルセットとは?
ken5scal
2
530
New Relicを活用したSREの最初のステップ / NRUG OKINAWA VOL.3
isaoshimizu
2
580
Terraform Stacks入門 #HashiTalks
msato
0
350
EventHub Startup CTO of the year 2024 ピッチ資料
eventhub
0
110
社内で最大の技術的負債のリファクタリングに取り組んだお話し
kidooonn
1
550
20241120_JAWS_東京_ランチタイムLT#17_AWS認定全冠の先へ
tsumita
2
230
BLADE: An Attempt to Automate Penetration Testing Using Autonomous AI Agents
bbrbbq
0
290
AWS Lambda のトラブルシュートをしていて思うこと
kazzpapa3
2
170
[FOSS4G 2024 Japan LT] LLMを使ってGISデータ解析を自動化したい!
nssv
1
210
インフラとバックエンドとフロントエンドをくまなく調べて遅いアプリを早くした件
tubone24
1
430
いざ、BSC討伐の旅
nikinusu
2
780
RubyのWebアプリケーションを50倍速くする方法 / How to Make a Ruby Web Application 50 Times Faster
hogelog
3
940
Featured
See All Featured
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
31
2.7k
Product Roadmaps are Hard
iamctodd
PRO
49
11k
The Cost Of JavaScript in 2023
addyosmani
45
6.7k
Fireside Chat
paigeccino
34
3k
The Pragmatic Product Professional
lauravandoore
31
6.3k
[RailsConf 2023 Opening Keynote] The Magic of Rails
eileencodes
28
9.1k
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
159
15k
Documentation Writing (for coders)
carmenintech
65
4.4k
Agile that works and the tools we love
rasmusluckow
327
21k
The Cult of Friendly URLs
andyhume
78
6k
Writing Fast Ruby
sferik
627
61k
Gamification - CAS2011
davidbonilla
80
5k
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!