Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Hospital project ; Sum column in another table

Topic Labels: Sync
167 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Airtzable

Hello.
I’m trying to develop a tool to help obese teenagers track the calories they eat, at a health centre near me.

I’ve got the first part right, but I’m struggling with the last part.

I created a table with all the foods.
Then I create a table for each new day, where they add what they eat each day.

In table 3, I would like to create a new line for each day, adding all the calories consumed that day.

I can’t manage to create a new line for each table, nor to add the total for the day automatically.

Can you help me?
Thank you very much

1 Reply 1

Hi Jefferson, I don’t think there’s an automatic way to create one new line for each table I’m afraid.

If I were you, instead of having one table per day, I’d have one table where each record represented one day

From there, users could select that day and the food they’re tracking, and you could then use a rollup field for the day itself like so:
Screenshot 2022-08-22 at 3.17.44 PM
Screenshot 2022-08-22 at 3.17.47 PM
Screenshot 2022-08-22 at 3.17.50 PM

Here’s a link to the base