Finding values within a Database field based on a date range and summing it up

Really needing some help.

Im creating a dashboard where its going to give you values of fields in a database summed up by a date range.

So for example, you select a beginning date and an end date, in the text field " Sales" it will produce the sum of all sales within that date range.

I just cant find how to do this, hope somebody can help, Im still new to bubble

its easy bro.

What i would have done, if i am referencign that number many places, i will create a var-repeating group and inside it i do a search with two date constraint.

Start date >= Sale Created date say 01 August 2024
End date >= Sale Created date say 10 August 2024

this will only return all the sale between 1st August till 10th August and then do a sum.

if its confusing book a meeting in profile and we will do it together. i would love to help.

Hi, thanks for the reply, the way you are stating it sounds like something fixed within the repeating group, the user needs to be able to choose the 2 dates he wants results for

you can add constraint inside do search, you use constranint one for start date and one for end date, now its your choice how you ask user for date. or you can use Today, This week , This month, this year, and depending on user choice you know when is start date and when is end data.

Hey I just want to thank you again for helping! you are fantastic!!!

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.