Skip to main content

Feed

Connect with fellow Trailblazers. Ask and answer questions to build your skills and network.

Hi All, 

 

I have built a formula to calculate the contract Length based on the Contract Start Date and Contract End Date fields but it seems to be a month out. Any ideas? 

 

This is the formula, 

 

(( YEAR (Contract_End_Date__c ) - YEAR ( Contract_Start_Date__c ))*12) + (MONTH(Contract_End_Date__c) - MONTH(Contract_Start_Date__c )) 

 

Ive included a snippet of a test i have just performed. 

 

I would expect this to show 12 months not 11.  

Formula doesnt seem to calculate correctly

 

 

thanks  

Laura 

 

 

#Sales Cloud  #Salesforce Admin  #Formulas  #Formula Help

1 answer
  1. Today, 11:31 AM

    Hi @Laura Gairn

     

    Try this formula below:

    IF(

    DAY(Contract_End_Date__c) >= DAY(Contract_Start_Date__c),

    ((YEAR(Contract_End_Date__c) - YEAR(Contract_Start_Date__c)) * 12) + (MONTH(Contract_End_Date__c) - MONTH(Contract_Start_Date__c)),

    ((YEAR(Contract_End_Date__c) - YEAR(Contract_Start_Date__c)) * 12) + (MONTH(Contract_End_Date__c) - MONTH(Contract_Start_Date__c)) - 1

    )

    Thanks!

0/9000
0/9000

 I’m getting the error "duplicate property [actionNames] found on the component [force:highlightsPanel]" during deployment of the FlexiPage code below. However, there doesn’t appear to be any actual duplicate actionNames property in the code. Could you help me understand why this error is occurring and how to fix it?  

 

<?xml version="1.0" encoding="UTF-8"?>  

<FlexiPage xmlns="

http://soap.sforce.com/2006/04/metadata

"> 

    <flexiPageRegions> 

        <itemInstances> 

            <componentInstance> 

                <componentInstanceProperties> 

                    <name>actionNames</name> 

                    <valueList> 

                        <valueListItems> 

                            <value>Edit</value> 

                        </valueListItems> 

                        <valueListItems> 

                            <value>Contact.Add_Multiple_Stores</value> 

                        </valueListItems> 

                        <valueListItems> 

                            <value>Contact.Invite_to_Portal</value> 

                            <visibilityRule> 

                                <criteria> 

                                    <leftValue>{!Record.PES_SFP_Invite_Button__c}</leftValue> 

                                    <operator>EQUAL</operator> 

                                    <rightValue>true</rightValue> 

                                </criteria> 

                            </visibilityRule> 

                        </valueListItems> 

                        <valueListItems> 

                            <value>Delete</value> 

                        </valueListItems> 

                        <valueListItems> 

                            <value>Clone</value> 

                        </valueListItems> 

                        <valueListItems> 

                            <value>LoginToPortalAsUser</value> 

                        </valueListItems> 

                       

                    </valueList> 

                </componentInstanceProperties> 

                <componentInstanceProperties> 

                    <name>collapsed</name> 

                    <value>false</value> 

                </componentInstanceProperties> 

                <componentInstanceProperties> 

                    <name>enableActionsConfiguration</name> 

                    <value>true</value> 

                </componentInstanceProperties> 

                <componentInstanceProperties> 

                    <name>enableActionsInNative</name> 

                    <value>true</value> 

                </componentInstanceProperties> 

                <componentInstanceProperties> 

                    <name>hideChatterActions</name> 

                    <value>false</value> 

                </componentInstanceProperties> 

                <componentInstanceProperties> 

                    <name>numVisibleActions</name> 

                    <value>3</value> 

                </componentInstanceProperties> 

                <componentName>force:highlightsPanel</componentName> 

                <identifier>force_highlightsPanel</identifier> 

            </componentInstance> 

        </itemInstances> 

 

#Salesforce Developer

2 answers
  1. Today, 11:28 AM

    Hi @Usman Khan,

     

     I converted the Record Page to Dynamic Forms, added a new Quick Action button, and configured a visibility condition for one of the buttons. 

0/9000

Our demand planning team has asked for a way to see what opportunity products have changed week over week.  I see there is no history tracking available for opportunity products.  Has anyone else had success in tracking changes to the products on an opportunity at a detail level (products added / deleted / changed) and quantity?  Thank you. 

3 answers
  1. Today, 11:22 AM

    @Patty Bowers I realise this post is quite old now but I wanted to let you know that I solved this with a simple record triggered flow that triggers on the Opportunity Product. My use case is when a line is deleted but it could be updates. The flow has one 'post to chatter' component that sends a notification to a group of users including numerous opportunity fields, who made the change and when. This logs an audit trail of changes and also records all related opportunities where products were changed. It was a quick win!

0/9000

If I were to create 2 record types on Gift Transaction 

Regular Gift 

In-Kind Gift 

 

(Instead of having to log that at Gift Commitment level) 

 

How do I then set it up so that every Gift Transaction that gets created from Gift Commitment picks up the record type for Regular Gift?  

 

The only way I can think of is to create a flow to update the record type for any Gift Transaction associated with a Gift Commitment. Any other way?  

A place to see settings similar to NPSP Settings?

2 answers
0/9000
7 answers
  1. Eric Burté (DEVOTEAM) Forum Ambassador
    Today, 11:09 AM

    @Noga Weiss in this case, you might need to log (just a few seconds) to another one of your playgrounds in the meantime, logout once logged in, and then you should be able to detach it (the problem here is that the Agentforce playground is the last one in which you have logged into). Eric

0/9000

I am following trail 'Add Visibility Rules for Dynamic Pages' 

At the bottom it asks you to open the app on your phone. However I can only see the playground in the non-Lightening format and don't know how to get to the Lightening version on my mobile. 

 

  1. Open the app on your phone.
  2. Log in using your Trailhead Playground credentials. 

    Not sure what your playground username and password are? Find out how to get them in the

    Trailhead Playground Management module.
  3. Open the menu, tap the App Launcher, and open the Sales app.
  4. Tap Opportunities, then navigate to the Dickenson Mobile Generators opportunity. 

    What you see at first is what you’d expect: actions, record highlights, Path. But scroll down a bit... 

#Trailhead Challenges

1 answer
  1. Divya Chauhan (Kcloud Technologies) Forum Ambassador
    Today, 11:07 AM

    Hello @Samir Mabruk

     

    1. Log in to go to your profile, click 'Hands-on Orgs', and grab your playground username and reset your password if needed. 

    2. Open your phone's browser, go to Salesforce.com, and log in with your playground credentials. 

    3 . Log in, click your profile icon to switch to Lightning Experience if it's available, or check Setup > User Interface > Enable Lightning Experience to activate it. 

    4. From the App Launch, select the Sales app, tap Opportunities, and find the 'Dickinson Mobile Generators' opportunity. 

0/9000
1 answer
  1. Eric Burté (DEVOTEAM) Forum Ambassador
    Today, 11:05 AM

    Hello @Parul Patil please make sure before that the data streams have been correctly configured and data have been successfully ingested. Eric

0/9000