• #34132
     Anjali #8
    Forcetalks

    why formula fields are useful

    Explain why formula fields are useful.And explain use case for formula fields.

    #34135
    Forcetalks

    Hi Anjali,

    You’ve got a lot of data in your organization. Your users need to access and understand this data at-a-glance without doing a bunch of calculations in their heads. Enter formula fields, the powerful tool that gives you control of how your data is displayed.

    Let’s say you wanted to take two numeric fields on a record and divide them to create a percentage. Or perhaps you want to turn a field into a clickable hyperlink for easy access to important information from a record’s page layout. Maybe you want to take two dates and calculate the number of days between them. All these things and more are possible using formula fields.

    Thanks.

    #34141
    Forcetalks

    Hello Anjali,

    The formula field is useful as we can perform many tasks without writing a single code in Apex.

    Thanks.

    #34144
    Salesforce | Parul Parul #2
    Forcetalks

    Hi

    It’s a read only field, the value of formula filed evaluate from expression defined by us. If we update any value in the expression, it automatically updates formula field value. We can create formula fields in both standard and custom object.

     We can return formula result in 7 ways those are:

    1. Checkbox: Calculate a boolean value
    2. Currency: Calculate a dollar or other currency amount and automatically format the field as a currency amount.
    3. Date: Calculate a date, for example, by adding or subtracting days to other dates.
    4. Date/Time: Calculate a date/time, for example, by adding a number of hours or days to another date/time.
    5. Number: Calculate a numeric value.
    6. Percent: Calculate a percent and automatically add the percent sign to the number.
    7. Text: Create a text string, for example, by concatenating other text fields.

     

    Thanks

    #34203
    Salesforce | shariq shariq #1
    Forcetalks

    Hi,

    Formula & Cross Object Formula Field in Salesforce: Formula Field is a read only field whose value is evaluated from the formula or expression defined by us. We can define formula field on both standard as well as custom objects. Any change in expression or formula will automatically update the value of formula field.

    It is a read only field, the value of formulafiled evaluate from expression defined by us. If we update any value in the expression, it automatically updates formula field value. We can create formula fields in both standard and custom object.

    We can return formule result in 7 ways those are:

    1. Checkbox: Calculate a boolean value
    2. Currency: Calculate a dollar or other currency amount and automatically format the field as a currency amount.
    3. Date: Calculate a date, for example, by adding or subtracting days to other dates.
    4. Date/Time: Calculate a date/time, for example, by adding a number of hours or days to another date/time.
    5. Number: Calculate a numeric value.
    6. Percent: Calculate a percent and automatically add the percent sign to the number.
    7. Text: Create a text string, for example, by concatenating other text fields.

    Creating this type of filed is like creating a normal salesforce field with data type formulae and we need to select result typed & provide expression.

    Hope this helps.

    #34733
    Forcetalks

    Here’s the use case of formula fields:

    • Let’s take an example of Account Object, which has 3 record types say (Group, Branch, Vendor) so If the Account RecordType is “Group”
    • Picklist value of Account “Status” is set to “Closed”
    • And Value in field ReasontoClose__c is Blank, the validation rule should fire.

    AND(
    ISBLANK(  ReasontoClose__c),

    ISPICKVAL( Status, “Closed”),

    RecordType.Name=” Group ”

    )

Viewing 6 posts - 1 through 6 (of 6 total)

Please to reply to this topic.

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending

About Us

Forcetalks is a Salesforce collaboration platform for coders & developers, geeks & nerds, consultants & business heads, admins & architects, managers & marketers and of course the business owners. A community where you can learn from, where you can contribute to. For you. For Salesforce. Read More...

Copyright 2018 Forcetalks. All Right Reserved.

Log in with your credentials

or    

Forgot your details?