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.

How to: Create a food diary…

Topic Labels: Formulas
1924 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Steven_Villarin
4 - Data Explorer
4 - Data Explorer

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:

3 Replies 3

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.

tacobellmenus
4 - Data Explorer
4 - Data Explorer

To calculate food costs for Taco Bell Bowl Menu, break down each ingredient (rice, beans, protein, etc.) into its cost per serving. Enter these into the food costing calculator to get the total dish cost. This helps in pricing menu items efficiently while maintaining profitability.

jackpaul21
4 - Data Explorer
4 - Data Explorer

Figuring out the best way to structure your macro tracking is like ordering from  Del Taco Menu—you want the right balance of protein, carbs, and fats, just like you want the right mix of tacos, burritos, and fries! Maybe structuring your table like a menu could help: each day gets a ‘caloric budget’ (like a meal price), and each food entry subtracts from that total. Just like customizing your order, you can tweak your macros to fit your goals while still enjoying what you eat!