How to: Create a food diary…

Goal

  • Track daily macro Protein/Carb/Fat against micro cal goals and see remaining calories if have not met for each day

  • Associate each food entry with a corresponding caloric allotment, e.g., On X day = 1000 cal, on other days = 1200 cal

The challenge I am running into is that I don’t know the best way to structure the table or formula.

Any suggestions, please?

Thanks for your help. :raised_hands:

The problem that I see with such a system is that the data entry would be extremely cumbersome. Not only would you have to enter all the foods and their associated calorie counts, you would also have to enter all the food eaten per day. There are many diet apps for counting calories, and human data entry is still a huge pain. In fact, some diet systems rely on the difficulty in data entry–they hope that the effort in entering the data is enough to make people decide not to eat that snack after all.

That said, I think you would need a table system: one for days, another for foods, and a junction table between them. Store the calorie count for each food item in the food table. In the junction table, store the day, the food item, and the number of servings. Have a system of lookups, rollups, and formula fields to do the calculations.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.