ContributionsMost RecentMost LikesSolutionsDoes anyone know of chat bot integrations with Quick Base?chat bot, AI, integrationRe: How to calculate fee based on package size, incurred daily 60 days after [Date Received] to a max of 30 daysit's a date typeHow to calculate fee based on package size, incurred daily 60 days after [Date Received] to a max of 30 daysHere are the criteria: 3 different [Package Size] each [Package Size] has a different fee fees are calculate after 60 days after [Date Received]. On the 61st day, the fee begins. fees are charged daily, and up to a max of 30 consecutive days. In for the formula below,on 61 days the fee should be $0.50, then at 90 days it should accrued to $15, instead it calculates a total of only $0.50 when the [Date Received] was in 2017. var number DaysOverDue = Min(90, ToDays(Today()-[Date Received])); If(([Package Size]="Light" or [Package Size]="Regular") and ($DaysOverDue>60),($DaysOverDue-60),0.5) And how do I add another If package size to the formula?Re: How to Calculate Fees Incurred Daily from [Date Received]Thank you for your help good sir!Re: How to Calculate Fees Incurred Daily from [Date Received]made it work var number DaysOverDue = Min(90, ToDays(Today()-[Date Received])); If($DaysOverDue > 60, $DaysOverDue - 60) Re: How to Calculate Fees Incurred Daily from [Date Received]Sorry, it's not giving me the calculation I'm looking for. Even added the ) to the var number DaysOverDue = Min(30, ToDays(Today()-[Date Received])); If($DaysOverDue > 60, $DaysOverDue - 60) Re: How to Calculate Fees Incurred Daily from [Date Received]Thank you but it goes on indefinitely. The fee should start at 60 days after date received, incurring $1 a day up to a max of 30 days (90 days after date received)?Re: How to Calculate Fees Incurred Daily from [Date Received]This reply was created from a merged topic originally titled How to Calculate Fees Incurred Daily from [Date Received]. I'm looking for a more elegant formula to calculate fees incurred after a certain date, then daily up to 30 days. Below is what I've put together; is there a shorter way of expressing this? f(ToDays(Today()-[Date Received])=61,1, ToDays(Today()-[Date Received])=62,2, ToDays(Today()-[Date Received])=63,3, ToDays(Today()-[Date Received])=64,4, ToDays(Today()-[Date Received])=65,5, ToDays(Today()-[Date Received])=66,6, ToDays(Today()-[Date Received])=67,7, ToDays(Today()-[Date Received])=68,8, ToDays(Today()-[Date Received])=69,9, ToDays(Today()-[Date Received])=70,10, ToDays(Today()-[Date Received])=71,11, ToDays(Today()-[Date Received])=72,12, ToDays(Today()-[Date Received])=73,13, ToDays(Today()-[Date Received])=74,14, ToDays(Today()-[Date Received])=75,15, ToDays(Today()-[Date Received])=76,16, ToDays(Today()-[Date Received])=77,17, ToDays(Today()-[Date Received])=78,18, ToDays(Today()-[Date Received])=79,19, ToDays(Today()-[Date Received])=80,20, ToDays(Today()-[Date Received])=81,21, ToDays(Today()-[Date Received])=82,22, ToDays(Today()-[Date Received])=83,23, ToDays(Today()-[Date Received])=84,24, ToDays(Today()-[Date Received])=85,25, ToDays(Today()-[Date Received])=86,26, ToDays(Today()-[Date Received])=87,27, ToDays(Today()-[Date Received])=88,28, ToDays(Today()-[Date Received])=89,29, ToDays(Today()-[Date Received])>=90,30, null) How to Calculate Fees Incurred Daily from [Date Received]I'm looking for a more elegant formula to calculate fees incurred after a certain date, then daily up to 30 days. Below is what I've put together; is there a shorter way of expressing this?" "If(ToDays(Today()-[Date Received])=61,1, ToDays(Today()-[Date Received])=62,2, ToDays(Today()-[Date Received])=63,3, ToDays(Today()-[Date Received])=64,4, ToDays(Today()-[Date Received])=65,5, ToDays(Today()-[Date Received])=66,6, ToDays(Today()-[Date Received])=67,7, ToDays(Today()-[Date Received])=68,8, ToDays(Today()-[Date Received])=69,9, ToDays(Today()-[Date Received])=70,10, ToDays(Today()-[Date Received])=71,11, ToDays(Today()-[Date Received])=72,12, ToDays(Today()-[Date Received])=73,13, ToDays(Today()-[Date Received])=74,14, ToDays(Today()-[Date Received])=75,15, ToDays(Today()-[Date Received])=76,16, ToDays(Today()-[Date Received])=77,17, ToDays(Today()-[Date Received])=78,18, ToDays(Today()-[Date Received])=79,19, ToDays(Today()-[Date Received])=80,20, ToDays(Today()-[Date Received])=81,21, ToDays(Today()-[Date Received])=82,22, ToDays(Today()-[Date Received])=83,23, ToDays(Today()-[Date Received])=84,24, ToDays(Today()-[Date Received])=85,25, ToDays(Today()-[Date Received])=86,26, ToDays(Today()-[Date Received])=87,27, ToDays(Today()-[Date Received])=88,28, ToDays(Today()-[Date Received])=89,29, ToDays(Today()-[Date Received])>=90,30, null)" How to automate emails based on [Date Received] and at different intervals thereafter?For example, I have an order come in for a customer, how can I automate an email to that specific customer based on [Date Received], then another 15days after [Date Received], then finally a third at 30 days?