I am quite new to bubble, so forgive the possible amateur question! I am building a tool to forecast maintenance expenses for residential apartment blocks. So, in this app, a user can define the the following:
Maintenance job (e.g. window cleaning)
Job start date (when does it next need to be done)
Frequency (e.g. annually)
Maintenance cost
I then “submit” that job and it saves to a database. I’m all OK up to this point.
Here’s the part I am struggling with:
Once I have a maintenance job logged, I would then like to produce a future forecast, showing the next due dates for that job. Once you have multiple jobs loaded, the idea is that you can then get a forecast of your upcoming maintenance expenses.
My issue is that I don’t know how to calculate the future job dates!
You can consider schedule a workflow on a list to accomplish this by using a “list of dates.” These dates can be generated using a plugin. One I know the name of is “T1 - List of Dates.”
@oliver.abrahams so… whenever you are showing your prescribed frequency is it just in a text box or what?
Obviously your initial date is saved so your next occurrence would just be a dynamic value of saved date. ie, job start date + date/time + days 30. Thus would get you 39 days from the start date.
I’ve got a maintenance app i can show you how I do it.
Hi @twilson9034 , the user will fill out a simple input form, as below. That then gets saved to a database of projects.
I am now trying to develop a page where I can show a list of upcoming projects. So if the user selects a date range, say 2020 to 2040, this project should come up twice, 2022 and 2032, as it is a 10 year frequency.
if you’ve got a maintenance app I’ve be keen to check it out!
If you would like to share, make it so anyone can view, send me a link, ill pm you so you can send me the link and I’ll send you my number, and I’ll guide you through it over the phone.
