Brian Dunagan bdunagan
bdunagan
/ salesforce-timezones.txt
Created
December 29, 2016 04:34
Salesforce: How to Set Up US Timezones with a Custom Formula
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Salesforce Custom Formula for US Timezones based on Billing State | |
| # Note there are 51 because DC counts. | |
| CASE(BillingState, | |
| "HI","US-PST", | |
| "AK","US-PST", | |
| "WA","US-PST", | |
| "OR","US-PST", | |
| "CA","US-PST", | |
| "NV","US-PST", | |
| "MT","US-MST", |
bdunagan
/ salesforce-report-object.rb
Created
January 29, 2017 10:44
Salesforce: Create a Report object using Analytics API
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Instantiate Salesforce Report using Restforce. | |
| # Requires Salesforce Analytics API with v29. | |
| # Usage | |
| # report = Restforce::Report.find("1234567890") | |
| # puts report.name | |
| # puts report.filters | |
| # puts report.rows | |
| module Restforce |
bdunagan
/ salesforce-opportunity-field-release-name.txt
Last active
March 18, 2017 13:11
Salesforce: Add an Opportunity formula field for "Release Name"
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Salesforce Custom Formula for Release Name based on Opportunity CloseDate | |
| IF( | |
| /* 2012 - Win 8, Mac 10 */ | |
| AND( | |
| CloseDate >= DATE(2012,11,6), | |
| CloseDate < DATE(2014,3,4) | |
| ), | |
| "2012 - Win 8, Mac 10", | |
| IF( | |
| /* 2014 - Win 9, Mac 11 */ |
bdunagan
/ salesforce-opportunity-field-days-since-release.txt
Last active
March 18, 2017 13:11
Salesforce: Add an Opportunity formula field for "Days since release"
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Salesforce Custom Formula for "Days Since Release" based on Opportunity CloseDate | |
| IF( | |
| /* 2012 - Win 8, Mac 10 */ | |
| AND( | |
| CloseDate >= DATE(2012,11,6), | |
| CloseDate < DATE(2014,3,4) | |
| ), | |
| CloseDate - DATE(2012,11,6), | |
| IF( | |
| /* 2014 - Win 9, Mac 11 */ |
OlderNewer