Set Forth Formula Field with airSlate SignNow

Notarize formula field

hello Salesforce Ohana Walters 954 here welcome to the ultimate guide to Salesforce formula fields this series of videos is going to be a snippet from my course where I show you how to master Salesforce formula fields I'm putting this out here for free for all of my Salesforce family this course will take you through the basics of what a formula field is creating your first formula field going over the must-know formula functions and more at the end if you want to take your formula knowledge to the next level following real-life examples and projects to become a formula fiend check out the description below where the course is discounted for only $5 if you want more video tutorials like this make sure to hit that like and subscribe button leave a comment down below on some advanced formula techniques that you use thank you all so much for watching and remember I believe in you formula fields let you on the fly calculate manipulate and display your Salesforce orgs information I believe they are the foundation for all Salesforce automation process builder flow builder even visualforce pages use formulas for advanced calculations of data in this video we will be going over what a formula field is some of the different types of formula fields functions that can be used in formula fields and overall problems with formula fields for you to take note of formula fields are used to calculate information on a record these formulas are done automatically by Salesforce without the user needing to break out a calculator or do any type of hand math for example if you want to discount an opportunity by 14% every time it has a certain product a formula field can do that for you pretty easily you can also pull information from different related objects using formula fields this is called a cross object relationship and it's very powerful very simple example if you want to display on the opportunity the accounts primary contact you just use a formula field to pull that in all of this is done in the formula field editor this is a text editor window that gives you access to that objects sales force fields any related object fields and formula functions as well formula field editor is not exclusive to the formula fields it can also be found in validation rules process builder and flow builder once you learn formula fields you will also know how to create formulas in these other automation tools if you are familiar with Excel formulas and the functions that are there you will be right at home a lot of the same functions and capabilities that Excel has our baked right into Salesforce there are a few different formula field types the type of calculation that you are doing dictates your formula return type if you want to display a reps Commission on a cell you'll most likely be using a numeric return type like currency if you don't need the dollar sign in front of that use the number return type use the check box return type to evaluate true and false expressions and text to display information there are temporal return types as well for time calculations but watch out for those time zones process object formulas must be one of the types I mentioned above they go through the current objects relationships to do calculations just like in Excel there are functions that can be used in formula fields to save time and do advanced calculations like the square root of a number there are hundreds of salesforce functions to learn some functions you'll be using very frequently for example the if statement which based on some expression will give you a true result or a false result concatenation which is the combination of information or just simple arithmetic operations like addition and subtraction other functions are a situation specific like it's change which will tell you the value has been updated on a record another one is picklist bow which will help you understand what the current value of a picklist is throughout this course we will explore each of these functions giving real-world scenarios of where they can be used the formula field editor gives you access to system variables system variables are org and context specific values for example you can use the current users system variable to only display information to a certain type of profile using that system variable we talked about I just explained how amazing formula fields are and now you want to go out and make a hundred of them but hold your horses there are some problems with formula fields you should be aware of formula fields calculate on record load what does that mean only when the user clicks on a record or they're viewing that information even on a report that is when the information or the formula executes that is when the calculation takes place once the user is seeing that information the value in the formula field is not held in the database anywhere for quick access this is different than regular fields which are stored inside of the database one drawback of the on-the-fly calculation is that pages can load slower if you have a ton of formula fields on a page or report it can really bog down the users load times there are certain limits to formula fields to protect you from locking up the system with too complex a formula there's an overall character limit of almost 4,000 and a few other limits you should be aware of let's get into time zones the bane of every programmers existence and formula fields are no exception when working with date and time related formula fields be careful to work in the correct time zone normally everything will be expected to be in GMT and you'll need to offset your formula field to get the correct zone since formula fields are not stored in the database they cannot easily be used to trigger other automation tools for example if a formula field checkbox gets marked true every twenty-fifth day of the month there is no way to trigger a process builder to fire based on that formula field checkbox being changed to true there may be other ways to accomplish this but the formula field cannot do this by itself don't let these limits stop you from creating formula fields just remember with great power comes great responsibility as a Salesforce professional you need to be aware of these limits and restrictions of formula fields check the resources below for the full list of all formula field limits formula fields are the stepping stones to all automation in Salesforce in the next videos we will be creating our first formula field along with going over every different return type we talked about we will also be breaking down each and every function going over the most common ones to the extremely obscure functions that you may never use there's also a curated trail mix design for you to master formula fields with a little time and exposure you will be a formula fiend creating formula fields left and right and reaching those maximum limits and remember I believe in you in this video we will be creating our first formula film what we want to get done is get the calculation of the net income of this sale we have this opportunity the 2019 schmoyoho parola that we are selling for $600 and as a lot of you may know when you're selling a car you have to make sure that your paperwork is in check one of those items is the title and sometimes you may need to get a new title if you've lost yours and let's say that we did in this instance and it's going to cost us $50 to get a new title what we want to get done is to minus this $50 or the cost of the title from our overall selling amount so we can calculate our net amount that we are going to get to do this let's start by navigating and going into the setup object manager find our opportunity object we will be calculating this automatically on the fly on record load using a formula field this will be the first formula field we create in this series to get an understanding of what claiming the fields can do navigate to fields and relationships hit new really quickly we can read here the definition of a formula field a read-only field that derives its value from a formula expression you define the formula field is updated when any of these source fields change we'll hit next to select that field data type let's pick a field label of net income anywhere so that sales force generates a field name and scrolling down we can see all of the formula return types that are available to us our next videos will explore all of the different return types for now we will select currency because we are doing some type of dollar calculation we will leave our decimal place as to looking around at the simple formula filled editor in the first drop-down we have the objects that we are selecting from in this case we want to access fields on the opportunity object to run our calculation so we are selecting opportunity in the second pick list we have all of the fields that we have access to run any of our calculations on the next drop down is the operations that we have access to so we can add subtract multiply use opponents and have open and close parentheses for order of operations in this text area is the formula editor this is where we'll be writing our actual formula at the bottom we have the check syntax which will let us know if our formula compiles correctly or if there are any errors at the bottom we have the standard description and help text that we always want to fill in for additional information so let's do this calculation what we want to do is subtract our overall amount from our title cost I will go into the insert merge fields add in the amount go into the insert operation add subtract and then finally add in our title cost from the insert fields that should be it let's check to make sure that our syntax is correct perfect we got no errors let's hit next next to put this on our layout and see the results I just created this formula field but I'm not seeing any values there could be a bunch of different reasons behind this but most likely it's just Salesforce calculating across all of the records this new formula that we created so let's refresh again there you have it we can see that our net income has loaded in we are doing the amount minus 50 to get 550 this calculation is done automatically so if we change our title amount we can see that our net income drops down to 500 if we change our overall selling amount we can see our net income automatically calculates once more so that is creating our first formula field in the next video we'll be going over each of the individual formula field return types starting with the check box