Tuesday, 15 November 2022

FIND THE TOTAL TIME IN HOURS USING FORMULA FIELD IN SALESFORCE

 (NOTE: HERE WE TAKE ONE EXAMPLE FOR FINDING TOTAL TIME)          

* CREATE ONE CUSTOM OBJECT AS TIME ENTRIES

* ON TIME ENTRIES OBJECT CREATE TWO FIELDS AS START TIME AND END TIME USING   FIELD TYPE TIME

* NEXT, TO CREATE ANOTHER FIELD AS TOTAL TIME USING FORMULA  FIELD 

*AND IN FORMULA CHOOSE FORMULA RETURN TYPE AS NUMBER WITH 2 DECIMAL PLACES

* AND GIVE THE BELOW FORMULA IN THE ADAVNCED FORMULA AREA

( HOUR(END_TIME__c)  -  HOUR(START_TIME__c)) + (( MINUTE( END_TIME__c )  -  MINUTE( START_TIME__c ))/60)

* CHECK WITH SYNTAX ERROR AND SAVE THE FIELD

* NOW GO BACK TO TIME ENTRIES IN APP LAUNCHER 

* CREATE NEW TIME ENTRIES BY SELECT NEW 

* THEN GIVE  START TIME AND END TIME VALUE AND CLICK SAVE 

* NOW YOU GET TOTAL TIME ON THE RECORD PAGE

                       !!!!!THANK YOU FOR VISTING MY WEBSITE!!!!!!

No comments:

Post a Comment

Create Bundle Product with Product Option in Revenue Cloud

Let's explore how to create a Bundle Product along with its Product Options. First, we need to create the Bundle product.  App Launcher ...