How to do Math Inside Database, which Runs After Period of Time?

autovantaofficial · 2024-10-03T18:51:52.325Z

Hi.

Is it possible to achieve this:

User Inputs Mileage on Car [Miles]
User Inputs Distance Driven Per Month, on Average [MonthDist]
Application Divides MonthDist by 30 to calculate average each day, DayDist
As Each Day Passes (or any recurrence), Application adds DayDist to Miles for an approximation. (Precision is not important for my use case. Tolerance of about ~1K Miles)

Bold Represents Data Type.

I’m stuck on how to go about the last two steps. Any guidance would be great.

I am okay with any recurrence, minimum being a day and maximum being a month. The smaller the recurrence, the better, but as long as it’s between those two parameters I don’t really care.

AliFarahat · 2024-10-04T02:12:07.234Z

Hey @autovantaofficial

You can achieve this in three different ways

Schedule a backend workflows to run across all records and update them. You will need to schedule a recurring workflow
only update the record when you need to. For example if the data does not need to be updated till it needs to, then adjust your formula to also get the difference in dates between the last update date and current date then update a single record.
you can use a service like zapier or easycron to call a backend workflow to run the calcs across your dataset.

Obviously each method has pros and cons, the 1st should be the easiest to do.

The keys message here is to be efficient. Avoid updating records that are not needed. Only update when you need it. Less Workload Units = less $$$

autovantaofficial · 2024-10-04T18:33:07.489Z

Let me give that a try. Thank you Ali!