Hospital project ; Sum column in another table

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

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