Skip to main content
Topics#Trailhead ChallengesQuestion de Brooke Escudier
Brooke Escudier (Digital Mailing Solutions) a posé une question dans #Trailhead Challenges
21 déc. 2020, 19:21

help with formula ' next billing date lease'

Hi, I would like to see if there is any way to add a column to Lease Details section for ‘Next Billing Date’ this will need to be caculated based on the ‘Lease Start Date’ (From Lease Details section) but also using the selected ‘Payment Frequency’ from the 'Lease Financials section'. Where Monthly means Monthly, Quarterly means every 3 months, Semi-Annual means every 6 months and Annual means every 12 months.

 

Is this possible and can anyone help?

 

help with formula ' next billing date lease'

 

lease financials payment frequency options
4 réponses
  1. Tony Trinh
    21 déc. 2020, 20:50
    Ah, I overlooked that part. I see that Lease Details and Lease Financials are two separate child records. You would need to find a way to bridge that gap. Maybe if only one Lease Detail is related to the parent at a time, have Process Builder update that value into the parent, which can then trickle down into the Lease Details.
Rédiger une réponse...
0/9000