{"id":4628,"date":"2015-07-07T20:07:04","date_gmt":"2015-07-07T20:07:04","guid":{"rendered":"http:\/\/www.jitendrazaa.com\/blog\/?p=4628"},"modified":"2015-07-07T20:14:16","modified_gmt":"2015-07-07T20:14:16","slug":"become-expert-in-formulas-salesforce-video-newsletter-july-2015","status":"publish","type":"post","link":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/become-expert-in-formulas-salesforce-video-newsletter-july-2015\/","title":{"rendered":"Become expert in formulas – Salesforce Video Newsletter – July 2015"},"content":{"rendered":"

Below are short videos on how to get things done in Salesforce from documentation and user interface team.<\/p>\n

Formulas<\/strong><\/p>\n

Formulas are very powerful. They can help you to do everything from pulling informations from parent to child objects or caluclate something on basis of other field present on same record or parent record. Below are list of videos to make you more productive on formula.<\/p>\n

<\/p>\n

Getting started with Formulas<\/a><\/p>\n

This video gives brief intoroduction to Salesforce formulas accessing the formulas editor in the app, and how to use the editor tools to create formulas.<\/p>\n

Formulas : Tips and gotchas<\/a><\/p>\n

Formulas are powerhouse and can be used in reports and fields. This video will walk you through a few professional tips on how to get started, and how to avoid some common pitfalls. We use best practices such as writing your formula in plain language and using formatting to organize the formula so it’s easy to read. We cover how to handle blank fields in both addition or substraction or division.<\/p>\n

Formula : Calculate number of days<\/a><\/p>\n

Have you every wanted to calculate the number of days that case has been open ? This short video walks you through constructing a formula that will calculate the number of days it took to close a case, or if the case is still open, how many days have passed since it was opened.<\/p>\n

Accessing email from lookup field<\/a><\/p>\n

Have you ever wanted to use a field from a lookup object on its child object ? Example – Accessing email field from lookup object\u00a0in a workflow that is created on child object ? This video will give you demo on such scenario. There is script object which has writer object as parent. Using series of formula fields, email is sent to writer by workflow triggered by script.<\/p>\n

Creating Image formula<\/a><\/p>\n

Have you ever wanted to get more graphics in your salesforce org ? In this quick video demo, rating field is created which shows 5 star for hot lead, 3 star for warm and 1 star for cold.<\/p>\n

Please follow @salesforcedocs<\/a>\u00a0to provide feedback or idea on Video newsletter.<\/p>\n","protected":false},"excerpt":{"rendered":"

Salesforce video newletter of July 2015 for Formula<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"jz_research_post":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[9],"tags":[254,331,326,212],"class_list":["post-4628","post","type-post","status-publish","format-standard","hentry","category-salesforce","tag-formula-field","tag-salesforce","tag-video-newsletter","tag-video-tutorial"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":5113,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/merry-trailhead-and-happy-new-year-full-of-goodies\/","url_meta":{"origin":4628,"position":0},"title":"Merry Trailhead and Happy New Year full of goodies","author":"Jitendra","date":"December 24, 2015","format":false,"excerpt":"Trailhead wishes every Salesforce Admin, Developer, Business users\u00a0a very \"Merry Christmas\" and \"Happy New Year\" with lots of goodies in form of new modules and project. I have always been big fan of Trailhead and already wrote few articles previously. It has huge response, support and expectation from community. We\u2026","rel":"","context":"In "Salesforce"","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Prizes - Build a Battle Station App","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/12\/Prizes-Build-a-Battle-Station-App.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/12\/Prizes-Build-a-Battle-Station-App.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/12\/Prizes-Build-a-Battle-Station-App.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/12\/Prizes-Build-a-Battle-Station-App.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":1038,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/salesforce-interview-questions-part-2\/","url_meta":{"origin":4628,"position":1},"title":"Salesforce Interview Questions \u2013 Part 2","author":"Jitendra","date":"September 11, 2010","format":false,"excerpt":"Interview questions of salesforce.com, interview questions of visualforce.com and APEX","rel":"","context":"In "Salesforce"","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Account Child relationship in salesforce","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/09\/Account-Child-relationship-in-salesforce.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":30745,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/salesforce-business-rules-engine-guide\/","url_meta":{"origin":4628,"position":2},"title":"Salesforce Business Rules Engine Guide","author":"Jitendra Zaa","date":"December 20, 2025","format":false,"excerpt":"Master Salesforce Business Rules Engine. Complete guide covering expression sets, decision tables, matrices, real-world use cases, and implementation.","rel":"","context":"In "Salesforce"","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Salesforce Business Rules Engine Complete Guide - Featured Image","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2025\/12\/BRE-Guide-Featured-16x9-1.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2025\/12\/BRE-Guide-Featured-16x9-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2025\/12\/BRE-Guide-Featured-16x9-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2025\/12\/BRE-Guide-Featured-16x9-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2025\/12\/BRE-Guide-Featured-16x9-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":7646,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/when-to-use-custom-metadata-vs-custom-object\/","url_meta":{"origin":4628,"position":3},"title":"When to use Custom Metadata vs Custom Object","author":"Jitendra","date":"October 29, 2022","format":false,"excerpt":"When & how to choose between Custom metadata & custom object","rel":"","context":"In "Salesforce"","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Salesforce Custom Metadata","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2022\/10\/Custom-Metadata.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2022\/10\/Custom-Metadata.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2022\/10\/Custom-Metadata.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2022\/10\/Custom-Metadata.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2022\/10\/Custom-Metadata.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":4447,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/all-about-upsert-and-external-id-in-dataloader-and-apex-videos\/","url_meta":{"origin":4628,"position":4},"title":"All about Upsert and External ID in Dataloader and Apex – Videos","author":"Jitendra","date":"May 11, 2015","format":false,"excerpt":"You may be wondering that there are tons of articles available for upsert operation and what is need of one more blog post. I wanted to note everything important about upsert operations using datalaoder and Apex with identified gotchas at single place, and that's why its here :) . External\u2026","rel":"","context":"In "Apex"","block_context":{"text":"Apex","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/apex\/"},"img":{"alt_text":"Field Mapping to create Parent Child relationship using ExternalId in Salesforce","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/05\/Field-Mapping-to-create-Parent-Child-relationship-using-ExternalId-in-Salesforce-e1431304939365.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/05\/Field-Mapping-to-create-Parent-Child-relationship-using-ExternalId-in-Salesforce-e1431304939365.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/05\/Field-Mapping-to-create-Parent-Child-relationship-using-ExternalId-in-Salesforce-e1431304939365.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":4632,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/how-to-use-login-flow-in-salesforce\/","url_meta":{"origin":4628,"position":5},"title":"How to use Login Flow in Salesforce","author":"Jitendra","date":"July 7, 2015","format":false,"excerpt":"What is Login flow in Salesforce and how to solve common yet important problem using Salesforce declarative ability only.","rel":"","context":"In "Salesforce"","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Salesforce Login Flow Connection","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/07\/Salesforce-Login-Flow-Connection.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/07\/Salesforce-Login-Flow-Connection.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/07\/Salesforce-Login-Flow-Connection.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/4628","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/comments?post=4628"}],"version-history":[{"count":3,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/4628\/revisions"}],"predecessor-version":[{"id":4631,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/4628\/revisions\/4631"}],"wp:attachment":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/media?parent=4628"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/categories?post=4628"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/tags?post=4628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}