Hi there! I would like to be able to get data of only this week from the database.
I have a database that consists of "workedHours" (field key). It is a number that value is of worked hours. I would want to filter the database so that it would show the total number of worked hours by using a TEXT Element. I think it needs to get this week's info, then it would do a loop to add these workedhours items and set their total to a text element.
I also must note that the database is updated everyday. So workedHours are added everyday. They might have 0 or 20 or 30 total hours depending on their worked hours. And then when it's Monday, it backs to total of 0 worked hours since it's a new week.
I tried searching here but found nothing. I tried looking at the API documentation as well but unfortunately, those were of different use.
Please help. Thank you and stay safe.