Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Summary View for Current Month

Topic Labels: Views
Solved
Jump to Solution
332 3
cancel
Showing results for 
Search instead for 
Did you mean: 
MrRemarkable
4 - Data Explorer
4 - Data Explorer

Noob here. Frankly don't know where to start, and my mind is whirling with the results in the community, so let me describe what I'm going for.

I've created a form that allows my community to report data in four areas for a health challenge: calories consumed, exercise calories, water consumption, and sleep hours. There's also the date and the person's name in the table.

What I want my community to see is a summary of each of the four areas for the current month. I'll embed the view on a web page. Rollups, aggregations, linked records — I'm starting from square one in using Airtable and haven't figured out which and how to make this work. 'Lil help? Thanks!

1 Solution

Accepted Solutions
ATSolutionist
6 - Interface Innovator
6 - Interface Innovator

Hi there! 

do you plan on doing it for current month, or for the 30-day cycle? and are you utilizing an interface dashboard embed? I'd  recommend this route - you could set a condition to your number elements. Here's a quick example of a similar format (counting currency during a month)

ATSolutionist_0-1736893891029.png

Let me know if this was helpful ! 

 

 

Katelyn
info@consultasolutionist.com

See Solution in Thread

3 Replies 3
ATSolutionist
6 - Interface Innovator
6 - Interface Innovator

Hi there! 

do you plan on doing it for current month, or for the 30-day cycle? and are you utilizing an interface dashboard embed? I'd  recommend this route - you could set a condition to your number elements. Here's a quick example of a similar format (counting currency during a month)

ATSolutionist_0-1736893891029.png

Let me know if this was helpful ! 

 

 

Katelyn
info@consultasolutionist.com

The interface dashboard is what I'm looking at now, because it's soooo much better looking than something like a gallery card. And, yes, it would be for the current month — probably a separate one for the current year or even lifetime.

Thanks for this: your example prompted me to think of something differently and the embed looks great!

ATSolutionist
6 - Interface Innovator
6 - Interface Innovator

Amazing to hear! Happy I could help and here as a soundboard if needed. 

 

Katelyn
info@consultasolutionist.com